Hi,
I created two tables with identical columns table A has 1.5 million records and SAS table B has 6.5 million records, saved in same library, both are read from text files. (A from A.txt and B from B.txt)
The problem I have is , although A is 1/4 the size of B , A is shown 50GB(yes 50GB) in storage and B is shown only 5 GB.
I wonder what caused that? Apparently based on my experience B's size looks reasonable, but I could not identify any issues with A, so I have no idea why table A took 50 GB in storage. (they have identical columns)
Thanks!!
Run PROC CONTENTS on your data sets and check the lengths of the variables in them. Should give you the answer.
Thanks !
It's possible you created A using compress=no and B using compress=yes (or possibly compress=binary).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.