topic Re: How do I set the value of column equal to macro variable contents in New SAS User

How do I set the value of column equal to macro variable contents

boyandhisrobot — Mon, 01 Oct 2018 19:36:42 GMT

Hi, All,

I have a macro variable (%let id = T1234;) and I would like the value of a variable to be equal to this macro variable. It should like like so:

col1 col2

1 T1234

2 T1234

...

I've tried the following: proc sql; select col1, "&id." as col2 from some_table.

And this doesn't work. I end up with:

col1 col2

1 &id.

2 &id.

I've also tried using a data step (col2 = '"&id.";). This doesn't work either - only the first character will print (I assume because the second character may be numeric?). The results look something like this:

col1 col2

1 T

2 T

Any advice or help would be greatly appreciated.

Thanks,

Re: How do I set the value of column equal to macro variable contents

novinosrin — Mon, 01 Oct 2018 19:39:42 GMT

Not sure what's the problem, here is my test

%let id=T1234;

data want;
do col1=1,2;
col2="&id";
output;
end;
run;

Re: How do I set the value of column equal to macro variable contents

Reeza — Mon, 01 Oct 2018 19:40:30 GMT

This should work, just make sure you declare the macro variable before you create the table AND that it's in double quotes not single quotes.

 proc sql; 
select col1, "&id." as col2 
from some_table;

Re: How do I set the value of column equal to macro variable contents

boyandhisrobot — Mon, 01 Oct 2018 19:46:19 GMT

That fixed it, thanks. The problem seemed to be that I wasn't declaring the value first. Thank you.