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

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

kc_sas — Thu, 09 Feb 2023 21:53:46 GMT

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 — Thu, 09 Feb 2023 22:05:24 GMT

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 — Thu, 09 Feb 2023 22:11:00 GMT

it works, thanks a lot!