Company News Products Projects Texts Museum Download Contact Map RSS Polski
YAC Software Museum DataGate Suite Reserved words Trybiks' Dive
  Back

Information

SPSS-2-Excel

DataGate Suite

Script Language

Reserved words

Reserved words
Script structure > Reserved words > List

In this and following topics you will find description of all reserved words used in DataGate Systems scripts.

Below is the list of reserved words in alphabetical order:

AUTO
BEEP
COMMENT
CONST
GROUP
HEIGHT
ITEM
LABEL
LEFT
PAGE
RANGE
RECID
REPEAT
RIGHT
SIGNAL
TEXT
UPDATE
VALLAB
VARLAB
VARNAME
WHEN
WIDTH



Top

Script structure > Reserved words > AUTO

Definition of an automatic value.

Attribute format:

AUTO=<number>  
AUTO=<string>  
AUTO=<reference>  

Example:

AUTO=99 LABEL=Q1*  
AUTO='99' TEXT WIDTH=2*  
AUTO='\.' TEXT WIDTH=40*  
AUTO='N/A' TEXT WIDTH=3*  
AUTO=^Q1 *  

You will find more information about this attribute under the
Automatic field value
topic.



Top

Script structure > Reserved words > BEEP

A field with this attribute set is distinguished from other fields in that when the keypuncher enters this field a short signal is emitted.

Attribute format:

BEEP  

You will find more information about this attribute under the
Sound signaling
topic.



Top

Script structure > Reserved words > COMMENT

This instruction shows the specified text in the data entry window; e.g. it can inform the keypuncher about any special conditions for entering latter fields.

Instruction format:

COMMENT=<string>  
COMMENT=<reference>  

Example:

COMMENT='No missing data!!!' LABEL=Q1*  
COMMENT=''*  
COMMENT=^Q1*  

You will find more information about this instruction under the
Comment instruction
topic.



Top

Script structure > Reserved words > CONST

Definition of a field with a constant value.

Attribute format:

CONST  

You will find more information about this attribute under the
Constant field
topic.



Top

Script structure > Reserved words > GROUP

Definition of a group of fields, which can be filled out with automatic values with one press of a button (numeric plus).

Attribute format:

GROUP=<label name>  

After this definition, some other field must have the corresponding label definition:

LABEL=<label name>  

Example:

LEFT='Other - which 1' TEXT WIDTH=40 GROUP=other*  
LEFT='Other - which 2'*  
LEFT='Other - which 3'*  
LEFT='Other - which 4' LABEL=other*  

You will find more information about this attribute under the
Field groups
topic.



Top

Script structure > Reserved words > HEIGHT

For long text fields, the height of the field may be defined (for easier input). Instead of a single line edit field, a memo field of the given height (in lines) will be shown.

Attribute format:

HEIGHT=<number>  
HEIGHT=<reference>  

Example:

LEFT='Description 1' TEXT WIDTH=500 HEIGHT=10 LABEL=Desc*  
LEFT='Description 2' TEXT HEIGHT=^Desc*  

Note

The
HEIGHT attribute is not inheritable.



Top

Script structure > Reserved words > ITEM

Defines the first value of the wildcard character in the simultaneous definition of several fields.

Attribute format:

ITEM=<number>  

Example:

LEFT='Q1.$' WIDTH=1 REPEAT=5 ITEM=4*  

The above instruction will automatically generate the following (virtual) fields:

LEFT='Q1.4' WIDTH=1*  
LEFT='Q1.5'*  
LEFT='Q1.6'*  
LEFT='Q1.7'*  
LEFT='Q1.8'*  

You will find more information about this attribute under the
Simultaneous definition of several fields
topic.



Top

Script structure > Reserved words > LABEL

A label is a name (symbol) that is assigned to a given instruction. This is done so that the instruction can be referenced by other instructions in the latter part of the script - the instruction referencing other instructions may import certain definitions from them.

Attribute format:

LABEL=<string>  

Example:

LABEL=Question1 COMMENT='Enter only marked codes'*  
LEFT='Code1' WIDTH=2*  
LEFT='Code2'*  
LEFT='Code3'*  
COMMENT=^Question1*  

You will find more information about this attribute under the
Label
topic.



Top

Script structure > Reserved words > LEFT

Left field description is for defining a text that will be displayed on the left-hand side of the field in the data entry window.

Attribute format:

LEFT=<string>*  
LEFT=<reference>*  

Example:

LEFT='Q1.a' WIDTH=2*  
LEFT='Q1.b'*  
LEFT='Q1.c'*  

You will find more information about this attribute under the
Left and right field descriptions
topic.



Top

Script structure > Reserved words > PAGE

Clear page instruction forces the data entry editor to start new fields on a clean page (previous fields are hidden).

Instruction format:

PAGE*  

You will find more information about this instruction under the
Clear page instruction
topic.



Top

Script structure > Reserved words > RANGE

Defines the range of admissible values for numeric fields.

Attribute format:

RANGE=<range>  
RANGE=<reference>  

Example:

RANGE=[0:2230:40919397:99LABEL=Q1*  
RANGE=^Q1*  

You will find more information about this attribute under the
Range of admissible field values
.



Top

Script structure > Reserved words > RECID

Definition of the data record identifier.

Attribute format:

RECID  

You will find more information about this attribute under the
Data record identifier
topic.



Top

Script structure > Reserved words > REPEAT

Simultaneous definition of several fields.

Attribute format:

REPEAT=<number>  

Example:

LEFT='Q1.$' WIDTH=1 REPEAT=5*  

The above instruction will automatically generate the following (virtual) fields:

LEFT='Q1.1' WIDTH=1*  
LEFT='Q1.2'*  
LEFT='Q1.3'*  
LEFT='Q1.4'*  
LEFT='Q1.5'*  

You will find more information about this attribute under the
Simultaneous definition of several fields
topic.



Top

Script structure > Reserved words > RIGHT

Right field description is for defining a text that will be displayed on the right-hand side of the field in the data entry window.

Attribute format:

RIGHT=<string>*  
RIGHT=<reference>*  

Example:

LEFT='Q1' WIDTH=RIGHT='!!! Enter only marked responses !!!'*  
LEFT='Q2'*  
LEFT='Q3'*  

You will find more information about this attribute under the
Left and right field descriptions
topic.



Top

Script structure > Reserved words > SIGNAL

Filter definition of the weak type.

Attribute format:

SIGNAL=<range><field range>  

Example:

SIGNAL=[0][q11]*  
SIGNAL=[0][q11, q12]*  
LABEL=q11 AUTO=9*  
LABEL=q12 WIDTH=2 AUTO=99*  

You will find more information about this attribute under the
Filters
topic.



Top

Script structure > Reserved words > TEXT

The field type is determined by the existence of the reserved word TEXT. If it is included in an instruction, a text field will be defined. Otherwise the program assumes that is should be a numeric field.

Attribute format:

TEXT  

Example:

COMMENT='Question 1'*  
LEFT='Brand 1' WIDTH=1*  
LEFT='Brand 2'*  
LEFT='Brand 3'*  
LEFT='other' WIDTH=40 TEXT*  



Top

Script structure > Reserved words > UPDATE

Fields designated for editing in update mode.

Attribute format:

UPDATE  



Top

Script structure > Reserved words > VALLAB

Definition of value labels when exporting definitions to SPSS.

Attribute format:

VALLAB=<value labels>  
VALLAB=<reference>  

Example:

VALLAB=[1 'very good' 5 'very bad'LABEL=eval_1*  
VALLAB=^eval_1*  

You will find more information about this attribute under the
Value labels topic.



Top

Script structure > Reserved words > VARLAB

Definition of the variable's label when exporting definitions to SPSS.

Attribute format:

VARLAB=<string>  
VARLAB=<reference>  

Example:

VARLAB='Brand 1' LABEL=Brand1*  
VARLAB='Brand 2' LABEL=Brand2*  
. . .  
VARLAB=^Brand1*  
VARLAB=^Brand2*  

You will find more information about this attribute under the
Variable labels topic.



Top

Script structure > Reserved words > VARNAME

Definition of the variable's name when exporting definitions to SPSS.

Attribute format:

VARNAME=<variable name>  

Example:

VARNAME=Sex*  
VARNAME=Age*  

You will find more information about this attribute under the
Variable name topic.



Top

Script structure > Reserved words > WHEN

Filter definition of the strong type.

Attribute format:

WHEN=<range><field range>  

Example:

WHEN=[0][q11]*  
WHEN=[0][q11, q12]*  
LABEL=q11 AUTO=9*  
LABEL=q12 WIDTH=2 AUTO=99*  

You will find more information about this attribute under the
Filters
topic.



Top

Script structure > Reserved words > WIDTH

Definition of the field's width.

Attribute format:

WIDTH=<number>  
WIDTH=<reference>  

Example:

LEFT='Respondent - sex' WIDTH=1 LABEL=RespSex*  
LEFT='Respondent - age' WIDTH=2 LABEL=RespAge*  
LEFT='Main buyer - sex' WIDTH=^RespSex*  
LEFT='Main buyer - age' WIDTH=^RespAge*  

You will find more information about this attribute under the
Field width
topic.



Top

Topics

List

AUTO

BEEP

COMMENT

CONST

GROUP

HEIGHT

ITEM

LABEL

LEFT

PAGE

RANGE

RECID

REPEAT

RIGHT

SIGNAL

TEXT

UPDATE

VALLAB

VARLAB

VARNAME

WHEN

WIDTH