I originally wrote a macro, %SQUEEZE (http://support.sas.com/kb/24/804.html) to compute the optimal length of every variable in a SAS dataset and thereby reduce the disk space required for a specified dataset. No information is lost in the process, e.g., numerical accuracy is not reduced, and long character variables that contain mostly trailing blanks are redefined in length to contain the longest string of nonblank characters.
Then I created another macro, %SQZ_LIBRARY, that invokes the %SQUEEZE macro on all of the SAS datasets contained in a SAS data library. It is available at https://www.lexjansen.com/wuss/2011/posters/Papers_Bettinger_R_74821.pdf.
Significant reductions in disk space may be achieved by applying the %SQZ_LIBRARY macro to SAS data libraries as a data management tool.
I have attached the PDF document describing the %SQUEEZE and %SQZ_LIBRARY macros. The SQZ_LIBRARY.sas file contains the %SQUEEZE and %SQZ_LIBRARY programs.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.