topic Re: Can't load data using the %Squeeze Macro (simple question) in SAS Programming

Can't load data using the %Squeeze Macro (simple question)

Top_Rankin — Sat, 22 Jun 2019 14:41:31 GMT

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!

Re: Can't load data using the %Squeeze Macro (simple question)

Kurt_Bremser — Sat, 22 Jun 2019 16:00:44 GMT

Please post your code as you tried.

Use the "little running man" icon for posting code.

Re: Can't load data using the %Squeeze Macro (simple question)

Top_Rankin — Sat, 22 Jun 2019 18:28:58 GMT

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!

Re: Can't load data using the %Squeeze Macro (simple question)

Reeza — Sat, 22 Jun 2019 18:46:08 GMT

You can't possibly be on SAS 8 still.....

Re: Can't load data using the %Squeeze Macro (simple question)

Top_Rankin — Sat, 22 Jun 2019 19:00:38 GMT

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