topic PROC EXPORT in SAS Procedures

PROC EXPORT

Hart — Wed, 15 Apr 2009 16:45:31 GMT

I am using the function which is converting my data well however the output is uncompressed. my input file is compressed & after exporting i noticed that my 2g file has ballooned to 10g. I have tried compress statements but they are ignored.

is there anyway I can compress this data when exporting it? The goal is to upload this data onto a flash drive.

options compress=binary;
proc export data=test.temp(compress=BINARY)
outfile='D:\XPORT\temp.dat'
dbms=sav;
run;

Re: PROC EXPORT

sbb — Wed, 15 Apr 2009 17:06:56 GMT

The SAS COMPRESS= option refers to compressing SAS members. Not sure if you can export to an SPSS-format and have it be compressed.

Scott Barry
SBBWorks, Inc.

Re: PROC EXPORT

Doc_Duke — Wed, 15 Apr 2009 17:52:40 GMT

Since you appear to be on a Windows platform, you can just use the OS to do the compression. Use Windows Explorer to navigate to the directory, right click on the directory name, select "properties", select "general", select "advanced", check the box to compress the directory contents. That compresses all files in, or newly created in, the directory.

You can also compress a single existing file the same way.

Once a file or directory is compressed, you can look at the properties again to see how much space is actually used on the disk for the file.

Doc Muhlbaier
Duke

Re: PROC EXPORT

Hart — Wed, 15 Apr 2009 18:01:10 GMT

yeah im thinking the same. Thanks