BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Top_Rankin
Fluorite | Level 6

Hey Everyone,

 

For whatever reason I'm having an issue with putting my data into the %Squeeze macro (http://support.sas.com/kb/24/addl/fusion24805_1_squeeze2.html)<--actual code and (http://support.sas.com/kb/24/805.html)<--explanation of the code. I'm a huge novice when it comes to using these so please bear with me.

 

Wherever it says "DSNIN", it says put input sas dataset here. I do that and i replace DSNIN with my own "brickscon" and then change the DSNOUT to "brickscon2" and when I hit run, absolutely nothing happens and my log just shows the whole log as black. I feel like this is an incredibly basic task yet I don't know why I'm of having a hard time. Please help. Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Top_Rankin
Fluorite | Level 6

Thanks for your response. I actually ended up figuring it out after messing around with it. For those of you who are interested (it may have been obvious the whole time), here's what I did. To use the %squeeze macro code,  you first run as is (copy and paste the code as given by sas WITHOUT any modification). So don't insert your data input or anything and let it run. Should be all black in the logs. Then afterwards use this code 

libname sample
'C:\Program Files\SAS Institute\SAS\V8\dmine\sample' ;
proc contents data=sample.dmdcens ; run ;
%SQUEEZE( sample.dmdcens, squozen )
proc contents data=squozen ; run ;

 Here is where you would insert your own data. The purpose of this code is to reduce number and character bytes to reduce the memory file of your data. Great for big data sets. Thanks!

View solution in original post

4 REPLIES 4
Top_Rankin
Fluorite | Level 6

Thanks for your response. I actually ended up figuring it out after messing around with it. For those of you who are interested (it may have been obvious the whole time), here's what I did. To use the %squeeze macro code,  you first run as is (copy and paste the code as given by sas WITHOUT any modification). So don't insert your data input or anything and let it run. Should be all black in the logs. Then afterwards use this code 

libname sample
'C:\Program Files\SAS Institute\SAS\V8\dmine\sample' ;
proc contents data=sample.dmdcens ; run ;
%SQUEEZE( sample.dmdcens, squozen )
proc contents data=squozen ; run ;

 Here is where you would insert your own data. The purpose of this code is to reduce number and character bytes to reduce the memory file of your data. Great for big data sets. Thanks!

Reeza
Super User
You can't possibly be on SAS 8 still.....
Top_Rankin
Fluorite | Level 6

Smiley LOL no I'm not using SAS 8, that was code SAS had provided in one of their manuals. It's from a long time ago. I just had an issue with running the macro I wanted to use but I solved it. That would be insane if I was still using SAS 8 lol

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 4 replies
  • 1505 views
  • 0 likes
  • 3 in conversation