topic Re: Proc freq equivalent in Proc report in SAS Procedures

Proc freq equivalent in Proc report

sebster24 — Fri, 09 Aug 2019 13:00:56 GMT

Hello,

I am currently trying to create a proc freq equivalent in proc report.

For example:: the proc freq version is as follows::


proc freq data=sashelp.shoes ;
tables region * product/ nocol nocum nopercent;
run;

i wrote the following proc report version, but it does not look like the cross table created by proc freq.

For example:: the row percentages are missing.

proc report data=sashelp.shoes;
column region product n pctn;
define region /group order=internal;
define product /group ;
define n / 'Frequency';
define pctn / 'Percent' across f=percent9.2;
rbreak after/ summarize style=Header;
compute after;
region="Total";
endcomp;
run;

Any help?

Thank you.

Re: Proc freq equivalent in Proc report

Jagadishkatam — Fri, 09 Aug 2019 13:48:08 GMT

please do not mention the across in define PCTN

proc report data=sashelp.shoes;
column region product n pctn;
define region /group order=internal;
define product /group ;
define n / 'Frequency';
define pctn / 'Percent'  f=percent9.2;
rbreak after/ summarize style=Header;
compute after;
region="Total";
endcomp;
run;

Re: Proc freq equivalent in Proc report

ballardw — Fri, 09 Aug 2019 15:58:05 GMT

If you want it to look exactly like Proc Freq then use proc freq.

Or maybe a different procedure.

proc tabulate data=sashelp.shoes;
   class region product;
   table region ,
         (product  all='Region Total')*(n pctn rowpctn colpctn)
   ;
run;

Re: Proc freq equivalent in Proc report

Cynthia_sas — Fri, 09 Aug 2019 19:36:13 GMT

Hi:

I agree -- if you need the cross-tab table to look like PROC FREQ, it is the only procedure that will stack the values in cells as you show.

Neither PROC TABULATE nor PROC REPORT will stack the values, although you could get a cross-tab from either procedure, as shown below:

Each of those procedures will want the N and the Row Percent to have a separate column.

Cynthia