Help using Base SAS procedures

SPSS variable and value labels to SAS dataset

Reply
N/A
Posts: 0

SPSS variable and value labels to SAS dataset

I have converted the SPSS dataset into SAS dataset. However, the variable and value labels developed in SPSS could not be read in SAS. Please advise me how to maintain the conversion labels. Thank you.
Super Contributor
Super Contributor
Posts: 3,174

Re: SPSS variable and value labels to SAS dataset

Recommend you search the SAS support website http://support.sas.com -- there are DOC references on the topic with useful information on your query/post. In particular, the SAS system/architecture has "SAS variable labels" but SAS does not have a concept for "value labels", as I understand from reading support reference material found with a search.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

spss label sas conversion site:sas.com
Super User
Posts: 9,691

Re: SPSS variable and value labels to SAS dataset

I am not test it.
Try to use :

[pre]
options label;
[/pre]



or use proc report to test is.(I am not sure.)


Ksharp
Super User
Posts: 17,948

Re: SPSS variable and value labels to SAS dataset

How are you importing/exporting between packages?

I recently found for me that if I export the SPSS data to SAS, from SPSS then I lose my labels and formats. In my export there's also an option to save the formats to a file. This is converting a .sav file to .sas7bdat

If I read the SPSS .sav file from SAS then it reads the formats/labels.

I'm using SAS 9.2 and SPSS 14.
Super User
Posts: 10,549

Re: SPSS variable and value labels to SAS dataset

It has been awhile since I used SPSS but the option to export to SAS had a check box to export the formats and labels. This generated separate SAS code files with PROC FORMAT and LABEL statement syntax.

If you didn't check the box no joy for labels or fromats.
Ask a Question
Discussion stats
  • 4 replies
  • 219 views
  • 0 likes
  • 5 in conversation