|OpenVMS specifics:||All aspects are host-specific|
|Output Data Sets|
|PROC CONVERT product-specification <option(s)>;|
The CONVERT procedure converts an OSIRIS or SPSS data file to a SAS data set. It produces one output data set but no printed output. The new data set contains the same information as the input system file; exceptions are noted in Output Data Sets. The OSIRIS and SPSS engines provide more extensive capabilities.
Because the OSIRIS and SPSS products are maintained
by other companies or organizations, changes may be made that make the system
files incompatible with the current version of PROC CONVERT. SAS Institute
upgrades PROC CONVERT to support changes made to these products only when
a new version of the SAS System is available.
If a numeric
variable in the input data set has no value, or if it has a system missing
value, PROC CONVERT assigns a missing value to it.
This section describes the attributes of the output SAS data set for each product-specification value.
variables, the V1-V9999 name
becomes the SAS variable name. For multiple-response variables, the suffix
Rn is added to the variable name, where n is the response number. For example, V25R1 is the first response
of the multiple-response variable V25. If the variable after V1000 has 100
or more responses, responses above 99 are eliminated. Numeric variables that
OSIRIS stores in character, fixed-point binary, or floating-point binary mode
become SAS numeric variables. Alphabetic variables become SAS character variables;
any alphabetic variable that is longer than 200 is truncated to 200. The OSIRIS
variable description becomes a SAS variable label, and OSIRIS print formats
become SAS formats.
SPSS variable names and variable labels become unchanged variable names and labels. SPSS alphabetic variables become SAS character variables of length 4. SPSS blank values are converted into SAS missing values. SPSS print formats become SAS formats, and the SPSS default precision of no decimal places becomes part of the variables' formats. SPSS value labels are not copied. DOCUMENT data are copied so that PROC CONTENTS can display them.
Using the CONVERT procedure is similar to using the OSIRIS and SPSS engines. For example, the following two programs provide identical results:
/* using the CONVERT procedure */ filename xxx 'mybmdp.dat'; proc convert osiris=xxx out=temp; run;
/* using the OSIRIS engine */ libname xxx osiris 'myosiris.dat'; data temp; set xxx._first_; run;
However, the OSIRIS and SPSS engines provide more extensive capability than PROC CONVERT.
The following is an example of converting an OSIRIS
file to a SAS data set, using a fileref named
filename save '[mydir]osiris.dat'; proc convert osiris=save; run;
If you have more than one save file in the OSIRIS file referenced by fileref, then you can use two additional options in parentheses after the fileref. The CODE= option lets you specify the code of the save file that you want, and the CONTENT= option lets you specify the save file's content. For example, if a save file had CODE=JUDGES and CONTENT=DATA, you could use the following statements to convert the save file to a SAS data set:
filename save '[mydir]osiris1.dat'; proc convert osiris=save(code=judges content=data); run;
Top of Page
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.