02-12-2018 06:30 PM
We have some clients who still require SAV files for use in SPSS. When using PROC EXPORT and DBMS=SAV (or DBMS=SPSS), the files created are absolutely massive. A data file that would normally be about 200mb in SPSS is running ~ 880mb when exported. One easy example to replicate is a doing a PROC IMPORT followed immediately by a PROC EXPORT and the file goes from 10mb to 80mb.
In the PROC EXPORT documentation, it states that .SAV files can be: "SPSS files, compressed and uncompressed binary files". For the life of me I cannot find anywhere that references compressing a .SAV during the PROC EXPORT procedure. Is this possible in SAS?
And no, we cannot deliver as a .zip file.
Syntax is super basic, but if it helps:
proc export file="/my/path/to/testdataexportedfromsas.sav" dbms=sav replace data=sasdataset; run;