topic Re: Having a fixed set of variables in the column for proc tabulate in SAS Programming

Having a fixed set of variables in the column for proc tabulate

aalluru — Thu, 04 Feb 2021 19:31:31 GMT

I have a list of variables stored in the macro &relevant vars. I want to see the mean value of each of these variables (spread across the columns) grouped by a variable called cluster.

I ran a code as follows :

proc tabulate data = work.cluster_data_with_var_pred;
	var CLUSTER;
	table (CLUSTER)*(MEAN), &relevant_vars;
run;

It turns out that I cannot have the reference mentioned there. I tried a simple proc means but that creates a messy table where the relevant_vars just repeat rows for each cluster value instead of running across as columns Can anyone help me figure out another way to do this?

Re: Having a fixed set of variables in the column for proc tabulate

Reeza — Thu, 04 Feb 2021 19:33:56 GMT

Seems like a proc means would be enough?

proc means data=.... MEAN;
class cluster;
var &relevant_vars;
run;

Your mean belongs with the stats, not with the cluster. See if this gets you closer.

Proc tabulate data=....;
class CLUSTER;
var &relevant_vars;
table (CLUSTER), (&relevant_vars)*Mean;
run;

Re: Having a fixed set of variables in the column for proc tabulate

PeterClemmensen — Thu, 04 Feb 2021 19:38:50 GMT

I think what you want to do is this. I just replicated the problem using SASHELP.CLASS.

%let relevant_vars = height weight;

proc tabulate data = sashelp.class;
   class sex;
   var &relevant_vars;
   table sex, (&relevant_vars)*mean;
run;

Result:

Re: Having a fixed set of variables in the column for proc tabulate

aalluru — Thu, 04 Feb 2021 19:39:24 GMT

Oh yes! The proc tabulate you sent worked perfectly. I wanted the variable list to run along the columns, that's why I scrapped the proc means idea. Thank you so much!