
VisualPQL Procedures		SPSS Save File

SPSS Save File

SPSS^®, the Statistical Package for the Social Sciences, is a multi-purpose data analysis and reporting tool. The

SPSS SAVE
FILE

procedure provides an interface to this product. (SPSSX is a synonym for SPSS.)

SPSS SAVE FILE creates a portable file that can be accessed by SPSS. One SPSS case is created for each procedure table record generated by the VisualPQL program. In addition to the data, the dataset contains value and variable labels and missing value indicators.

SPSS SAVE FILE FILENAME = filename
     [/ BOOLEAN = ( logical_expression ) ]
     [/ NOLABELS ]
     [/ PORTABLE ]
     [/ SAMPLE    = fraction [ ,seed ]  ]
     [/ SORT      = [ (n) ] variable [(A)|(D)] , ...]
     [/ VARIABLES = varlist | ALL  ]
     [/ WEIGHT    =  varname  ]

`FILENAME`	Specifies the filename created by the procedure.
`VARIABLES`	Specifies the procedure variables that are written to the output file. The order in which variables are specified is the order in which they appear in the output file. If this option is not specified, the default variables are output.
`NOLABELS`	Specifies that variable and value labels are not copied to the `SPSS SAVE FILE`. This can save time if many labels are involved.
`PORTABLE`	Specifies that the output file is in portable file format. By default, the output file is in system file format.
`SORT`	Specifies the order in which the procedure table records and therefore the output are sorted.n is an integer that specifies the maximum number of records to be sorted. The default for this parameter is either the number of records in the database or the value specified in the sortn parameter and need only be specified if the number of records in the procedure table is greater than the default. The procedure table is sorted by the specified variables in variable list order. A variable name followed by (A) or (D) specifies that for that variable the sort is in Ascending order (the default) or in Descending order.
`BOOLEAN`	Specifies which procedure table records are used by the procedure. The procedure table records for which the logical expression is true are used by the procedure. If this option is not specified, all procedure table records are used.
`SAMPLE`	Specifies that a random sample of the procedure table records are used by the procedure. The fraction specifies the percent of records used and is specified as a positive decimal number less than or equal to 1 (one). .25, for example specifies that a 25% sample be used. The optional seed is an integer that is used to initialise the random number generator.
`WEIGHT`	Specifies the variable that is the `CASWGT` variable which provides a permanent weighting of the cases in the SPSS file. The default `WEIGHT` is 1.

Notes on SPSS Files

The basic numeric unit is an 8 byte real.
The file uses base 30 arithmetic to represent all numbers.
Strings are represented in 8 byte units. A short string is one that is less than or equal to 8 characters. For string variables that are greater than 8 characters, dummy variables are generated for every 8 characters.
Undefined string variables are represented by blanks.
Undefined numeric values and blank missing numeric values are represented by the SPSS system missing value (see SYSMIS in SPSS).
SPSS missing value ranges cannot be used.

Example

RETRIEVAL
PROCESS CASES ALL
AUTOSET
PROCESS REC EMPLOYEE
. GET VARS ALL
. PROCESS REC OCCUP WITH (CURRPOS)
.   GET VARS ALL
. END PROCESS REC
. PERFORM PROCS
END PROCESS REC
END PROCESS CASE

SPSS SAVE FILE
       FILENAME  = 'EMPLOYEE.DAT' /
       VARIABLES = ALL
END RETRIEVAL

When a VisualPQL program with an SPSS interface procedure is run, a summary report is produced and has the following form:

SPSS SAVE FILE SYNOPSIS
-----------------------
WRITTEN TO: 'EMPLOYEE.DAT'
Number of Records      20
USER VARIABLES:        14
VARIABLES IN SAVE FILE ORDER
----------------------------
NAME        GENDER      MARSTAT     SSN       BIRTHDAY    EDUC      NDEPENDS
CURRPOS     SALARY      CURRDATE    POSITION  STARTDAT    STARTSAL  DIVISION