DATA Step, Macro, Functions and more

Variables list used in macro

Accepted Solution Solved
Reply
Regular Contributor
Posts: 181
Accepted Solution

Variables list used in macro

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

ClusterVariablesR Square
1ABCD0.5
2DEFG0.7
3ASSD0.04
4ADFG0.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;


Accepted Solutions
Solution
‎04-30-2015 10:55 AM
Super User
Posts: 10,487

Re: Variables list used in macro

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.

View solution in original post


All Replies
Solution
‎04-30-2015 10:55 AM
Super User
Posts: 10,487

Re: Variables list used in macro

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 205 views
  • 0 likes
  • 2 in conversation