Thank you so much. Your code helps reduce the size of my data by 80% (based on the 10,000 obs). However, to run this, I need some space to create a new compressed dataset, and then delete the original dataset, such as:
data NEW(compress=yes);set OLD;run;
*and then delete the OLD dataset;
Previously, I wanted to do something like this:
data new(drop=varA varB varC varD);
set old;
format varA2 $30.; *currently, these variables have length of 128, but their values are not that long;
format varB2 $3.;
format varC2 $70.;
format varD2 $30.;
varA2 = varA;
varB2 = varB;
varC2 = varC;
varD2 = varD;
run;
By the way, would the new compressed dataset behave normally as a normal dataset? or do I have to declare every time I use it such as"
options compress=yes;
data DOSOMETHING; set NEW;run;
?
... View more