topic want to import spss data into sas without sas/access in SAS Procedures

want to import spss data into sas without sas/access

ssas — Thu, 11 Mar 2010 14:23:48 GMT

Hi I would like to import spss data into sas.
unfortunatly I have only sas anlytics pro ( and also sas enterprise guide), i don't have SAS/Access.
Is there any way that i can import spss data into sas.
Thanks in advance Message was edited by: ssas

Re: want to import spss data into sas without sas/access

sbb — Thu, 11 Mar 2010 14:27:25 GMT

There are references in the SAS support http://support.sas.com/ website and also in the forum archives.

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic/post:

import spss data site:sas.com

Re: want to import spss data into sas without sas/access

RickM — Thu, 11 Mar 2010 14:27:56 GMT

Look up proc import. It should be able to handle .sav files.

Re: want to import spss data into sas without sas/access

ssas — Wed, 17 Mar 2010 15:17:44 GMT

when i contacted sas technical team, they advised me to save the spss file as .por
and import into the sas. it's working well to some extent.
but some of the variables are unable to read( with some wild chars.) I contacted them again and will see what they say!!

Re: want to import spss data into sas without sas/access

Patrick — Thu, 18 Mar 2010 11:14:36 GMT

"but some of the variables are unable to read( with some wild chars.) "

The variable name or the variable values? If it's the name then use in step 2 of the import wizard this option "....comply with SAS naming standards...".

You could also try to export your SPSS data to Excel and import this - but according to the docu a .por file is the best way to go.

Cheers
Patrick