=========================================================================
Date: Sat, 15 Jul 2006 09:46:28 +1000
Reply-To: Jason Burke <burke.jasonm@gmail.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Jason Burke <burke.jasonm@gmail.com>
Subject: Re: SV: For those in need of running SAS using an SPSS file
In-Reply-To: <E0428445172CB7469BF187FF4D0051490352F8E9@CHIEMAIL1.spss.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
If your employer forces you to use SPSS, who pays the SAS license fees
every year?
On 7/15/06, Oliver, Richard <roliver@spss.com> wrote:
> The SPSS facility for writing SAS-format data files includes the ability to write value labels to a SAS formats file. This has been true for quite a few years (it's not new in SPSS 14).
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Staffan Lindberg
> Sent: Friday, July 14, 2006 12:44 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: SV: For those in need of running SAS using an SPSS file
>
> Hi!
>
> Being in a somewhat similar situation (although a SPSS user) I often find myself having to convert SPSS-files to SAS datasets for SAS-people. The easiest solution (at least for me) is to use a conversion program. I use DBMSCOPY but there are others (StatTransfer among others). With DMBSCOPY I can even convert SPSS Value Labels to SAS Formats. This is accomplished by DMBSCOPY generating a SAS program that you can run in SAS thus getting the Formats.
>
> An even faster way is to to use the ability of SPSS 14 (and perhaps earlier) to write SAS files in different formats (although I don't know if the Value labels are converted).
>
> best
>
> Staffan Lindberg
> National Institute of Public Health
> Sweden
>
> -----Ursprungligt meddelande-----
> Från: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] För Joseph Teitelman temp2
> Skickat: den 14 juli 2006 18:19
> Till: SPSSX-L@LISTSERV.UGA.EDU
> Ämne: For those in need of running SAS using an SPSS file
>
>
> For the past 2 months, I've been forced to learn how to use SPSS, since my employer uses SPSS solely.
>
> For those interested in analyzing data in SAS created as an SPSS *.sav file, the following steps are required.
>
> Note that I discovered this information from the very popular "Little SAS Book."
>
> 1) first save your spss file as a portable file * it has the extension por.
> 2) use the following SAS syntax:
> a) LIBNAME myspss SPSS 'c:\Myspsslib\spss.por';
> b) to use the print procedure in SAS type
> PROC PRINT DATA = myspss._FIRST_;
> c) to list the contents of the spss file (the variables and their attributes
> type: PROC CONTENTS DATA = myspss._FIRST_;
>
> d) to convert the spss portable file to a SAS data set, type the following:
>
> DATA 'c:\MySASlib\spsspor';
> SET myspss._FIRST_;
>
>
> e) the output will contain a list of observations/ records grouped by each variable in the data set.
>
> The next procedure * Proc contents will produce the variable #, the variable name, the type of variable (num or char, e.g.), Length of each variable, position of each variable, format of each variable. and label for each variable.
>
> Obviously, the information I provided is not intended for those who prefer to use SPSS rather than SAS. It's for those like me, who were forced to learn SPSS for some reason, such as a job, but would like to analyze the data using SAS.
>
> I hope this proves helpful for those of you in the same shoes as myself.
>
> I am not advocating the use of SAS over SPSS; rather I am merely showing that for those who prefer SAS over SPSS, it's easy to read an SPSS file using SAS, after saving the SPSS file as a portable document.
>
> The portable file will have the extension "por".
| 
