topic Re: SPSS variable and value labels to SAS dataset in SAS Procedures

SPSS variable and value labels to SAS dataset

deleted_user — Mon, 25 Oct 2010 02:13:52 GMT

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.

Re: SPSS variable and value labels to SAS dataset

sbb — Mon, 25 Oct 2010 02:19:24 GMT

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

Re: SPSS variable and value labels to SAS dataset

Ksharp — Mon, 25 Oct 2010 03:39:35 GMT

I am not test it.
Try to use :

[pre]
options label;
[/pre]

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

Ksharp

Re: SPSS variable and value labels to SAS dataset

Reeza — Mon, 25 Oct 2010 23:14:59 GMT

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.

Re: SPSS variable and value labels to SAS dataset

ballardw — Fri, 05 Nov 2010 22:58:51 GMT

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.

Re: SPSS variable and value labels to SAS dataset

Emma_at_SAS — Thu, 14 Jul 2022 15:42:59 GMT

Thank you @Reeza for sharing your approach. I want to use your method to read an SPSS dataset into SAS and bring with it the value and variable labels (It looks like when I export from SPSS to SAS, I can only bring the value labels and not the variable labels).

1- May you please edit my code to include the value and variable labels?

2- Also, how may I restrict my SAS data to a subsample. for example, WHERE agegroup = 2;

PROC IMPORT
DATAFILE= "C:\SPSSdata.sav"
OUT=SASdata
DBMS=sav REPLACE;
RUN;

Thanks

Re: SPSS variable and value labels to SAS dataset

Reeza — Thu, 14 Jul 2022 15:56:12 GMT

@Emma_at_SAS unfortunately I no longer have SPSS to test anything out.

For filtering that's fairly easy.

You've named your output data SASdata and can use a WHERE statement to filter it. See two examples below, one to create a new data set and one to filter a data set in a procedure.

data sasData_Group2;
set SASdata;
where agegroup=2;
run;

proc means data=sasdata;
where agegroup=2;
run;

Re: SPSS variable and value labels to SAS dataset

Emma_at_SAS — Thu, 14 Jul 2022 16:00:37 GMT

Thank you @Reeza for your response. I was wondering how to use a WHERE statement in the PROC IMPORT to only import part of a dataset. Maybe that will reduce the time to read a subsample from a larger dataset. Thanks

Re: SPSS variable and value labels to SAS dataset

Reeza — Thu, 14 Jul 2022 16:14:28 GMT

Most likely not reduce the time but you can try.

PROC IMPORT
DATAFILE= "C:\SPSSdata.sav"
OUT=SASdata (where=(agegroup=2))
DBMS=sav REPLACE;
RUN;

Re: SPSS variable and value labels to SAS dataset

Emma_at_SAS — Thu, 14 Jul 2022 16:18:31 GMT

Thank you for your suggestion @Reeza

I will try it. the WHERE statement does not turn blue and my SPSS data is password protected. I cannot check this code now but will check it later. Thanks