Date:         Thu, 22 Sep 2005 09:01:33 -0400
Reply-To:     painter@email.unc.edu
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         John Painter <painter@email.unc.edu>
Subject:      Re: SAS 9.1 data to SPSS 13.0
Comments: To: "Peck, Jon" <peck@spss.com>
In-Reply-To:  <5CFEFDB5226CB54CBB4328B9563A12EE02AEA719@hqemail2.spss.com>
Content-Type: text/plain; charset=us-ascii; format=flowed

Dear List,

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 ;
run ;


Sincerely,
John Painter


> -----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
>
> Hello,
>
> 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
> glitch.
>
> Nonetheless, any suggestions for how to fix this?
>
> Thanks,