How to use a macro variable in proc sql select into: ?

[kc_sas]

I am trying to use proc sql select into to create some macro variables as follows.

%macro sql(var);

proc sql noprint;

select A into: &var. separated by ' ' from in_ds;

quit;

%mend;

%sql(B);

%sql(C);

......

Seems it is not working, tried "&var.", didn't work either. Just wonder how to fix this, thanks.

[SASKiwi · Accepted solution]

Unless you use a %GLOBAL statement your macro variables will only be defined within your macro and not available outside of it. Try this:

%macro sql(var);
%global &var.;

proc sql noprint;
select A into: &var. separated by ' ' from in_ds;
quit;
%mend;

%sql(B);
%sql(C);

[kc_sas]

it works, thanks a lot!