topic Re: How to select variable using macro in sql in SAS Programming

How to select variable using macro in sql

xyxu — Tue, 04 Jun 2019 21:39:52 GMT

Re: How to select variable using macro in sql

novinosrin — Fri, 29 Mar 2019 15:34:50 GMT

@xyxu wrote:
How can this work?

What do you mean that?

Re: How to select variable using macro in sql

andreas_lds — Fri, 29 Mar 2019 15:34:54 GMT

@xyxu wrote:

I am trying to udo the following
%let var = x1;

proc sql;
create table new as 
select a.&var, b.x2
from data1 as a
left join data2 as b;
quit;
How can this work?

Please explain what is not working and what you try to achieve.

Re: How to select variable using macro in sql

Tom — Fri, 29 Mar 2019 16:01:12 GMT

Don't you have to have an ON clause if you are using LEFT JOIN?