BookmarkSubscribeRSS Feed
DragonLEG
Calcite | Level 5

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... 

3 REPLIES 3
SASKiwi
PROC Star

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.

maguiremq
SAS Super FREQ

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.

ballardw
Super User

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.

SAS Innovate 2025: Call for Content

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!

Submit your idea!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 793 views
  • 3 likes
  • 4 in conversation