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.
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;
or
proc freq data=MyData;
ods output onewayfreqs=counts;
table MyVar;
run;
Before you start building from scratch I recommend checking out JeffMyers macros in the SAS Community Library.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.