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 🙂 ... View more

Hi, Maybe someone can help me with my case, I have one obs date '20APR2020'  in table week0 and i need to create one table with 7 obs, '20APR2020','21APR2020','22APR2020' etc. i try this but i doesn't work correctly %macro sqlloop(start,end); PROC SQL; %DO i=&start. %TO &end.; /* %let j=%eval(&i+1);*/ CREATE TABLE week%eval(&i+1) as SELECT intnx('day',day,&i.) as day format=date9. FROM week&i. ; /*union */ /*select * from ; */ %END; QUIT; %mend; %sqlloop(start=0, end=7)   I need one table with values (for start I have only one date '20APR2020'): '20APR2020' '21APR2020' '22APR2020' '23APR2020' ..... Thanks in advance ... View more