topic proc freq, ods output and _TABLE_ variable in SAS Programming

proc freq, ods output and _TABLE_ variable

xxformat_com — Wed, 15 Jun 2022 16:10:51 GMT

When using ods output, a _TABLE_ variable is generated. However, I cannot figure out when the value is different from 1.

I was thinking that there could be a link with the TABLE variable but it does not seem the case.

Here is an example :

data abcd;
   a=1; b=1; c=1; d=1; output;
   a=2; b=1; c=0; d=4; output;
   a=2; b=1; c=0; d=4; output;
   a=1; b=1; c=1; d=1; output;
   a=1; b=1; c=1; d=1; output;

ods output CrossTabFreqs=demo;

proc freq data=abcd ; 
	table a*b a*c; 
run;

proc print data=demo noobs;
run;

Re: proc freq, ods output and _TABLE_ variable

Reeza — Wed, 15 Jun 2022 16:20:14 GMT


ods output CrossTabFreqs=demo;

proc freq data=abcd ; 
	table a*b*c; 
run;

proc print data=demo noobs;
run;

Re: proc freq, ods output and _TABLE_ variable

ballardw — Wed, 15 Jun 2022 16:56:59 GMT

To go along with @Reeza example, look in the results window.

Notice that for a*b and a*c there is only one table each but for a*b*c there are multiple tables?

If you look in the results window you will see in each table something like "Table 1 of b by c" and "Controlling for a=1".

So each of the tables in the gets a number greater than one when there are more levels of the "controlling for"

Consider:

data abcd;
   input a b c d;
datalines;
1 1 1 1
2 1 0 4
2 2 0 4
1 1 1 1
1 1 1 1
3 2 1 1
3 2 0 0
3 1 1 4
3 2 1 4
;
ods output CrossTabFreqs=demo;

proc freq data=abcd ; 
	table a*b*c; 
run;

There are 3 levels of variable A now, so there are 3 "controling for" of table for the b*c

Re: proc freq, ods output and _TABLE_ variable

xxformat_com — Wed, 15 Jun 2022 18:21:03 GMT

Thanks @Reeza