Variables list used in macro

[Ujjawal]

I have a macro that returns important variables. The demo output file from the macro looks like below :

Cluster	Variables	R Square
1	ABCD	0.5
2	DEFG	0.7
3	ASSD	0.04
4	ADFG	0.0555

On average, the macro returns 200-300 variables from 1.2k variables. I want spearman correlation to be run on only on these returning 200 variables. I have a macro for spearman correlation. I want to merge both these two macros.

ods select none;

ods output spearmancorr=sp hoeffdingcorr=hoef;

proc corr data=&dataset spearman hoeffding rank;

var &vars;

with attrition;

run;

[ballardw · Accepted solution]

If the output you show is in a dataset then:

proc sql noprint;

     select variables into : vars separated by ' '

     from <your dataset with the variables>;

quit;

Will create a space separated list suitable for use in a VAR statement.