How to select variable using macro in sql

[novinosrin]

---

@xyxu wrote:

How can this work?

---

What do you mean that?

[andreas_lds]

---

@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.

[Tom]

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