Dears: Some macro functions(e.g: %left() function) are not parsed in SAS Studio, but they are effective in SAS EG. And base SAS of both of them are 9.4_M6. And I wonder if I missed any global Settings in SAS Studio env? Please find my code in below. proc product_status;run;
data test1;
i=1;
run;
data test2;
i=2;
run;
data test3;
i=3;
run;
proc sql ;
create table t_test as
select * from dictionary.tables where libname='WORK';
select count(*) into:num from t_test where prxmatch('/^test/io',strip(memname));
;quit;
%macro test();
data all;
set test1 - test%left(&num.);
run;
%mend;
%test;
... View more