proc freq to proc print ods

[Q1983]

proc freq data=mytable; tables PROD_KEY_2/missing; run;

produces this in the Results section

PROD_KEY_2
PROD_KEY_2	Frequency	Percent	Cumulative Frequency	Cumulative Percent
3112	1	0.14	1	0.14
3501	3	0.42	4	0.56
4101	2	0.28	6	0.83
5112	315	43.75	321	44.58
5122	337	46.81	658	91.39
5300	7	0.97	665	92.36
5400	55	7.64	720	100.00

When I use proc print mytable it produces the detail dataset.  I want to reproduce the above table output for ODS output

[Reeza · Accepted solution]

To output to ODS either wrap the PROC FREQ in ODS statements 

OR

Capture the table using an OUTPUT statement and then PROC PRINT on that. 

See the answer here, which is what you're trying to do. 

https://communities.sas.com/t5/SAS-Procedures/Count-by-Variable-Groups/m-p/493096#M72254

And in general, you can always use the ODS tables.

https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html

---

@Q1983 wrote:

proc freq data=mytable; tables PROD_KEY_2/missing; run;

produces this in the Results section

PROD_KEY_2
PROD_KEY_2	Frequency	Percent	Cumulative Frequency	Cumulative Percent
3112	1	0.14	1	0.14
3501	3	0.42	4	0.56
4101	2	0.28	6	0.83
5112	315	43.75	321	44.58
5122	337	46.81	658	91.39
5300	7	0.97	665	92.36
5400	55	7.64	720	100.00

When I use proc print mytable it produces the detail dataset.  I want to reproduce the above table output for ODS output

---