I just attended the WUSS 2023 conference and heard about a macro called %squeeze that can potentially save you space in my file sizes. Can I save the code as a "global" macro or is easier to just run the macro and then the code to call the macro? It seems like it would be a useful tool for large permanent datasets...
You should also consider the SAS COMPRESS option if it is datasets you wish to remove blank space from. In my experience this can reduce sizes by up to 90% or so for large datasets containing many long character variables.
You could store it in your autoexec. I'd probably just save it somewhere (not sure what platform you're using) and use the %INCLUDE statement in your autoexec.
Look up AUTOCALL in the documentation. That would specify file locations for SAS to search for macros that have not been compiled yet in the current session. If you then use that macro and the file is in the Autocall library then SAS compiles it as needed.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.