Date: Thu, 22 Sep 2005 09:01:33 -0400
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: John Painter <firstname.lastname@example.org>
Subject: Re: SAS 9.1 data to SPSS 13.0
Content-Type: text/plain; charset=us-ascii; format=flowed
The best solution I found for the issue of SPSS v13 not reading SAS data
files correctly is to save the SAS file as a transport file.
Here is an example of the SAS code for creating SAS transport file:
options validvarname=v6; /* to account for long variable names since the
xport feature was not upgraded beyond v6 */
LIBNAME D1 'C:\MyDocuments\d1' ;
LIBNAME D2 XPORT 'C:\MyDocuments\d2\TRAINER.XPT' ;
PROC COPY IN = D1 OUT = D2 ;
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
> John Painter Sent: Monday, September 19, 2005 12:08 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: [SPSSX-L] SAS 9.1 data to SPSS 13.0
> I have a SAS data file that is migrated into SPSS on a routine basis.
> There are 809 variables and 1+ million records in the data set.
> The problem is I have found two SAS text variables (SAS format$2.) that
> become numeric variables in SPSS.
> Apparently the variable types are changed upon import. To top it off,
> there is no apparent relationship between the values of the SPSS
> variables and those same variables in original SAS data. The SPSS values
> are enumerated sequentially from 0 to 21; the original SAS variables
> consist of about 60 two digit or two letter abbreviations. The SAS data
> appear to be correct; the SPSS data are clearly not correct.
> Unfortunately, I upgraded to SAS 9.1 and SPSS 13.0 at the same time, so I
> can't tell with any degree of certainty whether this is a SPSS or SAS
> Nonetheless, any suggestions for how to fix this?