topic Re: Proc Tabulate table? in SAS Programming

Proc Tabulate table?

ybz12003 — Fri, 16 Dec 2022 22:38:11 GMT

Hello,

Could anyone explain the code below? Thanks much.

proc tabulate data=have;
  class form site;
  table form all, site*n='No. of flags'*f=5. all*f=5.;
run;

Re: Proc Tabulate table?

ybz12003 — Fri, 16 Dec 2022 22:39:14 GMT

Mainly, I don't understand is table command part.

table form all, site*n='No. of flags'*f=5. all*f=5.;

Re: Proc Tabulate table?

Tom — Fri, 16 Dec 2022 22:54:15 GMT

There is one comma there. So the first part is the rows definition and the second part the columns definition.

For the rows you are saying make a row for each distinct value of FORM and a separate row for all of the data.

For the columns part you are saying make a column for each value of SITE and a separate column for all of the data.

Under the site columns you want to show the number of observations, you want the column header to be the given string and you want the counts to be displayed using the 5. format.

For the ALL column you also want the count (the default statistic) and you also want it displayed using 5 places.

It might just be easier to use PROC FREQ instead. You can add the options the remove the percentages and end you with the same thing.

proc tabulate data=sashelp.class;
  class sex age;
  table age all,sex all;
run;

proc freq data=sashelp.class;
  tables age*sex /nopercent norow nocol ;
run;

Re: Proc Tabulate table?

ybz12003 — Mon, 19 Dec 2022 17:56:05 GMT

what's 5. format?

Re: Proc Tabulate table?

Tom — Mon, 19 Dec 2022 17:57:44 GMT

@ybz12003 wrote:
what's 5. format?

That is the normal numeric format with a width of 5 characters.

Re: Proc Tabulate table?

ybz12003 — Mon, 19 Dec 2022 17:59:14 GMT

Make sense, thanks much!

Re: Proc Tabulate table?

data_null__ — Mon, 19 Dec 2022 18:02:33 GMT

TABLE <<page-expression,> row-expression,>
column-expression </ table-option(s)>;