Variables list used in macro

Ujjawal — Thu, 30 Apr 2015 14:43:17 GMT

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;

Re: Variables list used in macro

ballardw — Thu, 30 Apr 2015 14:55:52 GMT

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.

topic Re: Variables list used in macro in SAS Programming

Variables list used in macro

Re: Variables list used in macro