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?
... View more
