BookmarkSubscribeRSS Feed
Karo_22
Calcite | Level 5
In the macro of a loop code, I put symbolgen mlogic mprint and this code is printing the 17000+ members that I use as filter. This prints all the 17000+ memsysid's in the saslog each time it goes through the loop and at times this will make the PC SAS windows full and I have to terminate the session. Is there a way to not let the macro print the 17000+ indiv id in the saslog. I tried using options symbolgen mlogic nomprint but this still printed the memsysid's in the saslog. Any suggestions?
6 REPLIES 6
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Your OPTIONS statement controls SASLOG output generated by SAS - NOSOURCE NOSOURCE2 NOMACROGEN NOSYMBOLGEN NOMLOGIC NOMPRINT are possible solutions to reduce the SAS log generated. Otherwise, it's unclear what is generating the SAS log -- without sharing your SAS code. For example, you may have a DATA step that generates SAS log output using PUT or PUTLOG.

Scott Barry
SBBWorks, Inc.
Karo_22
Calcite | Level 5
It was a success. It gave me a saslog without printing all the 17000+ individual id's that I used as filter to pull in the claims.
Thanks so much.

The other thing now is for me to know how to run the program optimmally efficient....i have a loop for the 17000+ indiv id's but am not sure if that's optimal. In the past I ran into problem that macro can hold (I think) 2000 values. Any suggestions?
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Share your SAS code, in order to get some reasonable feedback.

Scott Barry
SBBWorks, Inc.
Karo_22
Calcite | Level 5
Sorry, for confusion. I think I got it to work on my end. Thanks for your help earlier in the original question. THANKS & have a great day.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Good to hear you were successful - it would be helpful to share your experience and results with the forum subscribers / viewers, for their interest and consideration. Also, for future reference, it is a more useful (and personal preferred approach) that you post code, SAS log and sample data (instream) to the forum in a post reply rather than limiting it to one individual -- since this is a general forum and not really a support help desk.

Scott Barry
SBBWorks, Inc.
Karo_22
Calcite | Level 5
would you please give me your email or different way of getting code to you. I don't want to just post it on the forum...hope you understand. Thanks.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1136 views
  • 0 likes
  • 2 in conversation