sas >> Can I convert SPSS .sav file(NOT .por file) to SAS dataset.

by » Thu, 26 Apr 2007 16:03:20 GMT


Would you reply the question of subject?

If yes, would you explain the method for convert?



sas >> Can I convert SPSS .sav file(NOT .por file) to SAS dataset.

by edwardsm » Thu, 26 Apr 2007 19:29:22 GMT

Good morning all!

We've tried to tackle this problem in a number of ways as well. We could
not use DBMS engines (on our SOLARIS box) and as all my data resided on in
UNIX - moving files back and forth to a Windows machine to use STATTransfer
was not feasible. So what we did was to create a script that would create a
.sas program from the .sps syntax file. This way we could also ensure that
we had the proper SAS formats.

Not exactly what you're looking for .sav -> .sas7bdat - but a different
approach that does indeed work.

Have a great day!

A. Michelle Edwards, Ph.D.
DRC Coordinator and Senior Analyst
University of Guelph
Guelph, Ontario N1G 2W1

Ph: 519.824.4120 Ext 54539
FAX: 519.767.1620

Similar Threads

1. Help in SAS code- convert to .sav file

2. How to extract value labels from spss sav data file


I have a spss data (.sav) file and want to extract value labels from
it. Does anybody know how to do it in an easier way?

Thanks a lot.


3. Exporting to SPSS SAV file in 9.2

4. export an SPSS .sav file with labels and missings

hi everyone,

i'm sorry to come up with yet another SPSS export post. but i read
several of the existing ones and couldn't really figure out whether it
would be possible (and how) to export an SPSS .sav file with correct
variable labels, value labels, and missing values.

i know of the possibility to create a portable file. but i'm facing
the requirement to create a *.sav file (complete with labels and user
defined missings) without using the SPSS engine.

can anybody help me on this one? even a clear 'NO! Not possible!' by
somebody who knows it for sure will be greatly appreciated.

all the best,

5. OT: Extract metadata from SPSS SAV files using Perl

6. Export to spss sav file


I'm responding to the question by Richard Hockey about exporting a sas dataset
to spss.

I have used proc export several times to create a .sav file from sas (9.3.1,
unix and Windows, haven't tried 9.2 yet). But, generally, the spss command get
sas works better. It does not truncate all the variable names to 8 characters --
a noticeable advantage in many instances.  -- Larry


Date:    Sun, 17 May 2009 21:01:17 -0700
From:    Richard < XXXX@XXXXX.COM >
Subject: Exporting to SPSS SAV file in 9.2

Has anyone got the export to SPSS SAV file in 9.2 to work?  I've found
a few items in the SAS KB which gives some pointers such as having
your formats in the WORK library and only having 8 Char variable and
format names. I can get a simple example to work, but when I try real
data I get a floating point error!


Larry Hotchkiss
University of Delaware
IT User Services -- Smith Hall
Newark, DE 19716
302-831-1989   XXXX@XXXXX.COM 

7. Problems converting spss file to sas

8. Converting a SPSS file to SAS with Value and Variable labels


I have a huge SPSS file which I need to read in to SAS. I have saved
the SPSS file as .POR format and subsequently read it in to SAS.

Issue is Iam not able to read in the value labels from SPSS to SAS.
Whats the best approach for the same. I have more than 1000 variables
and many such files.

I have tried using the trial version of SPSS 14 and saving it as
.Sas7bdat and using the option of "Save value labels in to a SAS file"
but this way for many variables the variable labels dont come up.

I thought that probably saving from SPSS as a SAS Transport file
mightdo the trick and in SAS when I wrote the following syntax to read
in the newly created transport file "Reading Xpt.xpt"

filename xpthand "C:\Documents and Settings\prasadhh\Local
Settings\Temp\Temp\Reading Xpt";

proc cimport library=work.try infile=xpthand;

I get the following error
5347  proc cimport library=work.try infile=xpthand;
                           -------- ------
                           22       202
WARNING: The Base Product product with which CIMPORT is associated will
expire within 30 days.
         Please contact your SAS installation representative to have it
ERROR 22-322: Expecting a name.
ERROR 202-322: The option or parameter is not recognized and will be
5348  run;

What method should I use so that both value labels and variable lables
are being able to read in to SAS.

Please guide me