topic Re: Save values from a Proc Freq in SAS Programming

Save values from a Proc Freq

SasStatistics — Wed, 30 Jun 2021 13:29:20 GMT

I would need to create a custom report that I at the end will export into an excel file.

One thing I would like to do, is to use the numbers from a Proc freq report to save into a Macro Variable or into a data step:

proc freq data=MyData;
 table MyVar;
run; 

* The result from this, I would like to save into different macro variables or a data step;

Is this possible to do? Theoretically, I could calculate everything by hand or for instance write it down manually, but obviously I would like to do this automatically.

Re: Save values from a Proc Freq

PaigeMiller — Wed, 30 Jun 2021 13:35:11 GMT

proc freq data=MyData; 
    table MyVar/out=counts; /* Hint: check the documentation to see if there is an option that does what you want */
run;

proc freq data=MyData;
    ods output onewayfreqs=counts;
    table MyVar;
run;

Re: Save values from a Proc Freq

Reeza — Wed, 30 Jun 2021 14:24:24 GMT

Before you start building from scratch I recommend checking out JeffMyers macros in the SAS Community Library.

https://communities.sas.com/t5/SAS-Communities-Library/Demographic-Table-and-Subgroup-Summary-Macro-TABLEN/ta-p/634030

https://communities.sas.com/t5/SAS-Communities-Library/Library-Datasets-Summary-Macro-DATA-SPECS/ta-p/544757

Re: Save values from a Proc Freq

ballardw — Wed, 30 Jun 2021 14:47:28 GMT

Better: provide example data, rules and what the report should look like.

When I hear "save into a macro variable" for a report I see lots of extra work that often can be done by either Proc Report or Tabulate.