Use variable values as the value for a macro variable

Question

I have one SAS dataset that has a column with values that I want to use as a macro variable. Say the SAS dataset looks like this with one column:

varname
34
367
399
87

What I want is for all of the values in the column to become a concatenated string in a macro variable (suitable for using in an if statement with the in operator). The result would be equivalent to this:

%let var = %str('34','367','399','87');

How would I accomplish this?

DomPazz · Accepted Answer · 2017-04-26 17:06:26Z

5

I would use PROC SQL, but there are other ways:

proc sql noprint;
select "'" || varname || "'"
   into :var separated by ','
   from have;
quit;

%put var: &var;

This will concatenate the variable values with a ' on either side. The separated by piece will put a , between all the values. :var tells SQL to save the results in a macro named var;

edited Apr 26, 2017 at 17:06

answered Apr 25, 2017 at 20:33

DomPazz

12.4k19 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use variable values as the value for a macro variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related