topic Re: format issue with different operating system at sav file import in SAS Programming

format issue with different operating system at sav file import

bouz22 — Mon, 09 Nov 2020 12:55:15 GMT

Hello all,

Importing sav files is giving me some issues, I think it might have to do with a recent upgrade to 64-bit Sas but I'm not sure. I tried finding a solution but only came across old posts and I haven't been able to solve it.

This is how I used to import the sav file in this program (upper import statement). Trying without the format specification (lowe import statement) gives me the same error. Any help would be great!

LIBNAME sps '.';

proc import
	file = "path_to_file"
	out = all_dr
	dbms = sav
	replace;
	FMTLIB=sps.FORMATS_SPSS;
run;

proc import 
    file = "path_to_file" 
    out = all_dr 
    dbms = sav 
    replace; 
run;

This gives me the following error:

ERROR: File SPS.FORMATS_SPSS.CATALOG was created for a different operating system.

Re: format issue with different operating system at sav file import

Kurt_Bremser — Mon, 09 Nov 2020 13:04:07 GMT

In your current working directory of the SAS process, there is a formats_spss.sas7bcat file created with the earlier SAS version. Move it away, so that a new catalog file can be created.

Re: format issue with different operating system at sav file import

bouz22 — Mon, 09 Nov 2020 13:11:26 GMT

Thank you so much for your very quick reply, this worked!

I had tried changing

LIBNAME sps '.';

LIBNAME sps_new '.';

as a possible solution but that didn't work, I guess that's not how it works...