topic Re: Macro in title in SAS Procedures

Macro in title

Irena_ik — Mon, 11 May 2020 09:25:00 GMT

Hello,

Maybe someone can help me with macro

I need to get macro like this: from egtask.report_(&(PLIK&NUM.)) //* it consists with &NUM. - from %do statement (1,3) and &plik(1,3)

proc sql; select nr_pliku into:plik1 from pliki_1 where poreczenia=1 ;quit; //* here I have into:plik1 =3
proc sql; select nr_pliku into:plik2 from pliki_1 where poreczenia=2 ;quit; //* here I have into:plik2 =1
proc sql; select nr_pliku into:plik3 from pliki_1 where poreczenia=3 ;quit; //* here I have into:plik3 =2

///*parametrs plik1/2/3 in this macro will change therefore I need this macro in loop

%macro sqlloop(start,end);
%DO NUM=&start. %TO &end.;
PROC SQL;
create table title&NUM. as select *
FROM egtask.report_(&(PLIK&NUM.).) ///* when &NUM.=1 then &plik1, when &NUM.=2 then &plik2.
;QUIT;
%END;
%mend;

%sqlloop(start=1, end=3)

Thank You in advance 🙂

Re: Macro in title

Jagadishkatam — Mon, 11 May 2020 09:35:30 GMT

please try (&&PLIK&NUM.)

%macro sqlloop(start,end);
%DO NUM=&start. %TO &end.;
PROC SQL;
create table title&NUM. as select *  
FROM egtask.report_(&&PLIK&NUM.)      ///* when &NUM.=1 then &plik1, when &NUM.=2 then &plik2.
;QUIT;
%END;
%mend;

%sqlloop(start=1, end=3)

Re: Macro in title

ed_sas_member — Mon, 11 May 2020 09:51:35 GMT

Hi @Irena_ik

I believe that the parenthesis prevents the macro resolution: &(PLIK&NUM.).)

Please try &&PLIK.&NUM. instead.

Best,

Re: Macro in title

Irena_ik — Tue, 12 May 2020 07:34:29 GMT

Thank You very much!

Re: Macro in title

Irena_ik — Tue, 12 May 2020 07:35:03 GMT

Thank You for help!