topic The size of files after Proc append in SAS Procedures

The size of files after Proc append

CC13 — Sat, 14 Jul 2018 17:02:45 GMT

Hi all,

I used proc append to add observations from one sas data set to the end of another sas data set. However, I noticed the size of new dataset is much bigger than the sum of three adding data sets. I thought the size should be around the sum of three. Is there something wrong with the code?

data d.rat15to17; set d.rat15; run;
proc append base=d.rat15to17 data=d.rat16; run;
proc append base=d.srat15to17 data=d.rat17; run;

Thanks,

Chloe

Re: The size of files after Proc append

PeterClemmensen — Sat, 14 Jul 2018 17:16:21 GMT

A difficult question to answer without knowing the data.

Are the variable lengths equal? Are any of the data sets compressed?

Re: The size of files after Proc append

CC13 — Sat, 14 Jul 2018 17:30:47 GMT

Thank you for the answers!

The variable lengths are different and I checked I didn't compress the data in the new files which caused the size difference.