Hi,
The following program might help u
%macro create(howmany);
%do i=1 %to &howmany;
data month&i;
----------------
--------------
-------------
run;
%end;
%mend create;
%create(3)
When you execute the macro CREATE, it generates these statements:
DATA MONTH1;
INFILE IN1;
INPUT PRODUCT COST DATE;
RUN;
DATA MONTH2;
INFILE IN2;
INPUT PRODUCT COST DATE;
RUN;
DATA MONTH3;
INFILE IN3;
INPUT PRODUCT COST DATE;
RUN;