enterprise guide - Size of a SAS dataset is increasing on using a where clause -

enterprise guide - Size of a SAS dataset is increasing on using a where clause -

i have sas dataset sized close 20 gb, trying utilize clause unable size of dataset swelling , getting error stating: sas file full. when lastly looked @ dataset beingness created in library size close 45gb. code is:

data fin2; set fin; segment = "a"; run;

segment has 2 possible values , b (a close 50% of rows)

can tell me happening , why size of dataset increasing. tried doing if command no avail.

the code provide creates new dataset fin2 keeping existing dataset fin untouched. assume you're not happy fin has 20gb , fin2 has 45gb.

i expect fin created earlier, not stored in work library , has compression alternative enabled. verify, check output from:

proc contents data=fin;run;

contrary, expect compression fin2 not enabled.

to decrease size of fin2 table seek doing char or binary compression option:

data fin_segment_a (compress=char); set fin; segment = "a"; drop segment; run;

sas enterprise-guide