Save values from a Proc Freq

[SasStatistics]

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. 

[PaigeMiller]

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;

[Reeza]

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-...

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

[ballardw]

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.