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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: