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!
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!
Please post your code as you tried.
Use the "little running man" icon for posting code.
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!
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
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!
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.