topic Re: PROC TABULATE in SAS Procedures

PROC TABULATE

Pinky9 — Wed, 11 Sep 2013 13:02:35 GMT

Hi ALL

Could some one explain what does "table" keyword do in "PROC TABULATE".

Re: PROC TABULATE

data_null__ — Wed, 11 Sep 2013 13:08:58 GMT

From the online doc. "Describes a table to be printed.".

Re: PROC TABULATE

reneeharper — Wed, 11 Sep 2013 13:28:47 GMT

Here's a link to the Base SAS(R) 9.4 Procedures Guide of the Language and Reference Guide. You might also find the Syntax Index a useful tool. To use the Syntax Index, just start typing in the language element for which you want more information.

Good luck!

Re: PROC TABULATE

Pinky9 — Mon, 16 Sep 2013 13:06:37 GMT

Thanks for the information....

Re: PROC TABULATE

Pinky9 — Mon, 16 Sep 2013 13:27:25 GMT

Thanks for exhaustive information .

Could you u help me on understanding "classdata" option in proc tabulate , preferably with an executed example.

Thanks for help.

Re: PROC TABULATE

Cynthia_sas — Mon, 16 Sep 2013 20:43:12 GMT

Hi,

I would suggest that you look at the PROC TABULATE documentation or for user group papers like this one: http://www.lexjansen.com/pharmasug/2010/hw/hw03.pdf . Using the CLASSDATA option is one way to limit or filter the number of rows that get passed to PROC TABULATE for building a report table.

cynthia

ods listing close;

** these are the ONLY product/year rows we want in the TABULATE;

data wantdata;

length PRODUCT $10 year 8;

infile datalines;

input PRODUCT $ YEAR;

format product $char10. year 4.;

return;

datalines;

SOFA 1993

SOFA 1994

TABLE 1994

CHAIR 1993

BED 1993

DESK 1994

;

run;

options missing=0;

ods html file='c:\temp\example_ClassData.html' style=sasweb;

** See all years, all products in sashelp.prdsale;

proc freq data=sashelp.prdsale;

title 'Values in SASHELP.PRDSALE';

tables Product Year;

run;

** what is in wantdata?;

proc print data=work.wantdata;

title 'Values in Work.wantdata';

run;

** Use WANTDATA dataset with SASHELP.PRDSALE to limit analysis to ONLY;

** the rows in the WANTDATA dataset. Note that the variables must have the SAME;

** type and format in the WANTDATA dataset as in the SASHELP.PRDSALE dataset.;

proc tabulate data=sashelp.prdsale f=comma8.

classdata=work.wantdata exclusive;

title 'ClassData and Exclusive for Data Subset';

class product year;

var actual;

table product,

(year)*actual*(n sum mean)

/box="ClassData and Exclusive";

label Year = 'Year'

Product = 'Product';

run;

ods html close;

ods listing;

Re: PROC TABULATE

Pinky9 — Tue, 17 Sep 2013 10:28:04 GMT

Hi Cynthia,

This is great and helpful.