Hi Tom, Thanks for helping!! These codes are working absolutely fine. I have few questions and asked below:   %macro month; %local mindate maxdate i date month ; proc sql noprint; select min(date),max(date) into :mindate , :maxdate from sashelp.stocks ; quit; %do i=0 %to %sysfunc(intck(month,&mindate,&maxdate)); %let date=%sysfunc(intnx(month,&mindate,&i)); %let month=%sysfunc(putn(&date,monyy7.)); *Why did we use here PUTN instead of PUT; data &month ; set sashelp.stocks; if intnx('month',date,0)=&date then output ; run; %end; %mend; %month;     /*If you want to run one data step and write out all of the datasets at once you need two %DO loops.*/ %macro month; %local mindate maxdate i date month ; proc sql noprint; select min(date),max(date) into :mindate , :maxdate from sashelp.stocks ; quit; data %do i=0 %to %sysfunc(intck(month,&mindate,&maxdate)); %let date=%sysfunc(intnx(month,&mindate,&i)); %let month=%sysfunc(putn(&date,monyy7.)); &month %end; ; set sashelp.stocks; %do i=0 %to %sysfunc(intck(month,&mindate,&maxdate)); %let date=%sysfunc(intnx(month,&mindate,&i)); %let month=%sysfunc(putn(&date,monyy7.)); *Why do we need these repeated looping statements and how its working; if intnx('month',date,0)=&date then output &month ; %end; run; %mend; ... View more

I modified the code but still getting error. Please help.   %macro month; proc sql; select min(distinct(year(date))) into: minyear from sashelp.stocks; quit; proc sql; select max(distinct(year(date))) into: maxyear from sashelp.stocks; quit; %do i = 1 %to 12; %do j = &minyear %to &maxyear; /*data month&i.&j.;*/ data put(&i,monname3.)&j; set stocks; by date; month=month(date); where year(date) > 2002; if month=&i and years=&j then output month&i&j; run; %end; %end; %mend; %month; ... View more

Hi Jagadishkatam, Thanks for helping.    I have data for multiple years and want to include year value also. Exa: Jan2014, Fab2014....Dec2014....Jan2015, Feb2015....Dec2015, Jan2016, Feb2016,...Dec2016 and so on...   Tried adding year like below but its not working.. %macro month; %do i = 1 %to 12; data month&i..sysfunc(year(date)); set stocks; by date; month=month(date); if month=&i then output month&i; run; %end; %mend;   ... View more