cannot open data imported from SPSS

Fred_Gavin — Fri, 19 Aug 2011 00:51:18 GMT

LIBNAME library 'c:\MySASLib';

PROC IMPORT DATAFILE = 'c:\MySPSSDir\survey.sav'

OUT = library.sassurvey

DBMS = SAV

REPLACE;

FMTLIB = library.formats;

RUN;

I am experiencing SAS 9.3 at the moment. This is the example I used to import SPSS (.sav) file to SAS.

However when I did this way, the error message appears that:

" ERROR: Unable to open the table library.sassurvey. library.sassurvey cannot be opened.

Do you want to select a different table to open ?"

The error in the log is :

"ERROR: Format Q9_ not found or couldn't be loaded for variable Q9_."

This happened only when I specified the formats in "FMTLIB", which put SPSS formatted value in the personal library.

However without "FMTLIB", the formats would be put in "work" directory, and then I can open the data in the personal library. It seems weird.

I want to create formats in different library, because there are several SPSS files I have to import. If the formats file in the same "work" directory, when a new SPSS file imported, its format will overwrite the existing one.

Does anyone know about this, and How can I fix this problem?

Thanks and Regards

cannot open data imported from SPSS

Ksharp — Fri, 19 Aug 2011 08:03:38 GMT

I don't have experience about importing SPSS file.

But do you try to use wizard of import . File -> Import Data-> .....

Ksharp

topic cannot open data imported from SPSS in SAS Procedures

cannot open data imported from SPSS

cannot open data imported from SPSS