topic Re: Adding conditions within proc tabulate in SAS Programming

Adding conditions within proc tabulate

peter_sjogarde — Thu, 23 Oct 2014 15:42:38 GMT

Hi,

I am wondering if it is possible to add conditions within proc tabulate. I would like to be able to set a variable in the beginning of the script that includes or excludes a variable from proc tabulate.

E.g. Is it be possible to set a condition for the calculation of test2 below. If a variable is set to ‘yes’ it will be calculated but it is set to ‘no’ it will not.

Any help would be appreciated!

/Peter

TITLE1 "Test";

PROC TABULATE

DATA=WORK.T_PUBL_CIT;

WHERE( unit = "&Unit");

VAR test1 test2;

CLASS type/ ORDER=UNFORMATTED MISSING;

TABLE /* Row Dimension */

type

ALL={LABEL="Total"},

/* Column Dimension */

test1={LABEL="test1"}*

Mean={LABEL="" STYLE={JUST=RIGHT VJUST=BOTTOM NOBREAKSPACE=ON}}*F=PERCENTN6.

test2={LABEL="test2" STYLE={JUST=RIGHT VJUST=BOTTOM}}*

Mean={LABEL="" STYLE={JUST=RIGHT VJUST=BOTTOM NOBREAKSPACE=ON}}*F=6.1

;;run;

Re: Adding conditions within proc tabulate

ballardw — Thu, 23 Oct 2014 16:59:09 GMT

Basic approach would be macro code. I

%macro includeflag (flag = YES); /* this defaults to including the variable*/

"Test";