topic Re: spss to sas in SAS Programming

spss to sas

individual — Thu, 23 Oct 2014 16:12:45 GMT

Hi,

I am trying to import a spss data set into sas, but it seems that I loose some content on the way, meaning that my 1100 - long string is truncated to just 225.

I know that it is possible to extent the lenght of the variables, but so far I was not able to understand how to do it.

The sintax that I have used is:

PROC IMPORT

DATAFILE=''

OUT=

DBMS=SAV replace;

run;

RUN;

Thank you

Re: spss to sas

SUDOKU — Thu, 23 Oct 2014 16:26:22 GMT

Hi There:

Check out the LRECL system option at

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Syntax

LRECL=n | nK | nM | nG | nT | hexX | MIN | MAX

Syntax Description

n
specifies the logical record length in multiples of 1 (bytes); 1,024 (kilobytes); 1,048,576 (megabytes); 1,073,741,824 (gigabytes); or 1,099,511,627,776 (terabytes). For example, a value of 32 specifies 32 bytes, and a value of 32k specifies 32,767 bytes.

Re: spss to sas

ballardw — Thu, 23 Oct 2014 16:49:51 GMT

Another option if you have access to SPSS is to try exporting from SPSS to SAS. One additional advantage of this approach is the option to create a SAS Format program file that will mimic SPSS value displays.

Re: spss to sas

Reeza — Thu, 23 Oct 2014 17:13:24 GMT

Try DBMS=SPSS instead of SAV

PROC IMPORT

DATAFILE=''

OUT=

DBMS=SPSS replace;

run;