Date:         Tue, 29 Jul 2008 18:05:57 +0200
Reply-To:     Andre Wielki <wielki@INED.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Andre Wielki <wielki@INED.FR>
Subject:      Re: export an SPSS .sav file with labels and missings
Comments: To: Alex <alexander.konn@IEA-DPC.DE>
In-Reply-To:  <5dffb10a-5459-409d-a1c8-66ff34a798d9@26g2000hsk.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Alex,
Is  proc export so difficult? or do you lack of sas access to pc file
formats? or are you not yet in 9.1.3 v4 ?
Now Spss has its proper limits and rules and returning to sas may be
with reduced length and so on
The missing values in spss are 9999 if i remember well! Name of variable
are limited to 8.Too!
Outside sas; the solution is Stattranfer v9  but not free.

If with the correct Sas try
proc export  data=my.enrichedtable dbms=sav outfile="d:\spsstable.sav";run;

from a native complete spss table
use to import it

proc import datafile="d:\nativespss.sav" dbms=sav out=b;run;

when i was testing it, i found in the work
a table b.sas7bdat and a sas7bcat file!

note the same apply to Stata with other limits
you have to change dbms=sav to dta!

HTH
Andre

Alex a écrit :
> On Jul 29, 4:44 pm, Alex <alexander.k...@iea-dpc.de> wrote:
>
>> 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,
>> alex
>>
>
> just to state this clear: i have data in sas7bdat format which i want
> to export TO SPSS (16) using SAS 9. thanks randy for pointing to this.
>
>

--
   André WIELKI
   INED (Institut National d'Etudes Démographiques)
   Service Informatique
   133 Boulevard Davout      75980 Paris Cedex 20
   mél : wielki@ined.fr      tél :  33 (0) 1 56 06 21 54