Hello experts,
Please, I want to use sas macro -program in proc sql to automate the treatement, but I still have the errors
%let var1= tab;
%let var2=VR2;
%let var3=ctr_1;
I will do;
%marco test;
proc sql;
create table county_%substr(&var1.,1,2)_&var2_&var3. as
select catx('-',&var1,&var2.) as Id,
catx('-',&var1,&var2., &var3.) as section,
v4,
v5,
v6
from toto;
quit;
is it possible to put the below party in sas macro-program %init
create table county_%substr(&var1.,1,2)_&var2_&var3. as
select catx('-',&var1,&var2.) as Id,
catx('-',&var1,&var2., &var3.) as section,
and do
%macro test;
%init;
v4,
v5,
v6
from toto;
quit;
%mend test;
%test;
... View more
