topic Re: convert SAS file to SPSS in SAS Programming

convert SAS file to SPSS

dr2014 — Fri, 06 Nov 2015 20:07:10 GMT

Hi,

I have to convert a sas file to spss . The original sas dataset can only be opened after a proc format statement is run to account for the new formats. After that , I am able to open the sas dataset. Can this dataset then be converted to a spss file using the following program

get sas data='c:\sas\data\class.xpt'.
execute.

How can I ensure proper conversion. Please advice on the steps.

Thanks!

Re: convert SAS file to SPSS

Reeza — Fri, 06 Nov 2015 20:08:36 GMT

Are you working in SPSS or SAS?
If you want an SPSS file, export to SPSS and use the appropriate DBMS, either SAV or SPSS.

Re: convert SAS file to SPSS

dr2014 — Fri, 06 Nov 2015 20:16:08 GMT

@Reeza, I am working in sas.

Re: convert SAS file to SPSS

Reeza — Fri, 06 Nov 2015 20:22:05 GMT

Then try proc export.
To ensure formatted variables transfer properly I have a habit of including both the formatted and unformatted variable. Sometimes I also convert the formatted variable using a PUT() statement as well. It depends on the data.

Re: convert SAS file to SPSS

dr2014 — Fri, 06 Nov 2015 20:25:59 GMT

The unformatetd varibale is not present for this variable in the dataset. That's the reason for my concern. I will have to create a new one representing the unformatted one and then transfer. Would that be a good step?

Re: convert SAS file to SPSS

Reeza — Fri, 06 Nov 2015 20:35:18 GMT

I consider it best practice myself 🙂

Re: convert SAS file to SPSS

dr2014 — Fri, 06 Nov 2015 20:48:16 GMT

Thanks. Then I will make sure to have it. I have one more question. For the variable 'title' with the format...I have to run the proc format statement first. Say the format name for it is 'west'. After I run the proic format then only I am able to open the sas dataset in lib=work. If not it triggers a message saying

NOTE: Format WEST was not found or could not be loaded.
NOTE: There were 437 observations read from the data set WORK.ORIGINAL.
NOTE: The data set WORK.TEMP has 437 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

When I run a proc contents on work.temp I see the format 'west' listed against the vairiable 'title'. However, when I look at the column attributes of the variable in the dataset, the format is listed as BESTX12.

What is 'bestx12.' ? Please let me know.

Re: convert SAS file to SPSS

dr2014 — Fri, 06 Nov 2015 20:57:34 GMT

Please ignore my alst question. Thanks for your help.