topic proc freq export n and colpct only in SAS Programming

proc freq export n and colpct only

pacman94 — Sun, 21 Feb 2021 19:00:50 GMT

I have the following dataset: What I would like to do is create treatment*type and have frequency (percent)

ID	Type	treatment
123	1	1
343	2	2
354	1	3
656	2	3
446	2	2
665	2	1
444	2	1
665	1	1
656	1	2

proc sort data = test; by treatment type; run;

Here is the code I have:

proc freq data = test;

tables treatment*type / out = test2 ;

run;

When I run it i get the output correctly but when i export to another table it doesn't retain important characteristics such as 'Frequency' and 'Col Percent'

Re: proc freq export n and colpct only

ChrisNZ — Sun, 21 Feb 2021 20:38:35 GMT

> it doesn't retain important characteristics such as 'Frequency' and 'Col Percent'

It sure does.

proc freq data=SASHELP.CLASS; tables SEX*AGE /out=T; run;

Re: proc freq export n and colpct only

ChrisNZ — Sun, 21 Feb 2021 20:40:10 GMT

oops COLPCT. Sorry. Let me look.

Re: proc freq export n and colpct only

ChrisNZ — Sun, 21 Feb 2021 20:45:53 GMT

After spending 2 minutes reading the documentation, I now know that adding option OUTPCT to the OUTPUT statement does what you want.

Why come here and open a question without reading the documentation first?