Help using Base SAS procedures

want to import spss data into sas without sas/access

Reply
Contributor
Posts: 43

want to import spss data into sas without sas/access

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
Super Contributor
Super Contributor
Posts: 3,174

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

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
Regular Contributor
Posts: 165

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

Look up proc import. It should be able to handle .sav files.
Contributor
Posts: 43

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

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!!
Respected Advisor
Posts: 4,005

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

"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
Ask a Question
Discussion stats
  • 4 replies
  • 287 views
  • 0 likes
  • 4 in conversation