SOLUTION:
As of Version 10.1, SPSS can now read SAS data sets directly,
whereas before this version a SAS Transport File was necessary.
Here is a summary of some of the current techniques.
SPSS Version 10.1 and above
*.sas7bdat extension.
These files can now be read directly into the SPSS Data Window.Click File>Open>Data, then choose 'SAS Long File Name' (or other choice appropriate for your SAS data set), then locate the folder and file you want to convert so that the name of that file appears in the 'File Name' field, then click 'Open'.
SAS Transport Files (see below) also can be converted into the SPSS Data Window (Active File) in Version 10.1 and above.
This type of conversion is available on all platforms running SPSS version 5 or higher. SPSS Inc. documentation (for Version 10.0) for this operation is at:
http://www.spss.com/tech/downloads/getsas.pdf
LIBNAME OUT1 XPORT 'sasfile.xpt';
PROC COPY IN=WORK OUT=OUT1; SELECT MYDATA5;
RUN;
To read in the SAS transport file created in the example above, and save it as an SPSS system (Save) file, use the following commands in your SPSS session:
get sas data='sasfile.xpt' dset(mydata5).
save outfile='newdata.sps'.
execute.
The subcommand DSET(MYDATA5) is not necessary, unless the transport file contains more than one SAS data set.
First, the formats must be converted to a SAS transport file, in a process analogous to the one outlined above for SAS data sets. First, the formats must be put into a SAS data set using PROC FORMAT with the CNTLOUT= option, as in this example:
LIBNAME SASDATA 'C:\SASDATA'; **(or '~/sasdata' ***;
LIBNAME LIBRARY 'C:\SASFMTS'; **(or '~/sasfmts' ***;
PROC FORMAT LIBRARY=LIBRARY CNTLOUT=SASDATA.FMTXPORT;
RUN;
(NOTE: It is advisable NOT to use the name FORMATS as in
SASDATA.FORMATS when using the CNTLOUT= option of PROC FORMAT. This
is to avoid confusion with the SAS format catalog, which is called
FORMATS.SCT01)Next, you create another SAS transport file as you did for the data:
LIBNAME OUT2 XPORT 'sasfmts.xpt;'
PROC COPY IN=SASDATA OUT=OUT2; SELECT FMTXPORT;
RUN;
Then, your SPSS program would look like this:
get sas data='sasfile.xpt' dset(mydata5)
/ formats='sasfmts.xpt'.
save outfile='newdata.sps'.
execute.