hi,   The step ,  year(today())-2 will delete all the datasets of 2015, but i need to do it month wise, ex, after starting  april 2017, the code should delete march2015 dataset.   ... View more

hi Reeza, thank you for your reply. I have a doubt in the 3rd step you mentioned. I cannot filter by date as this process needs to be automated, so I cannot manually keyin the date in the filter, would you please share someother way ... View more

Thanks for the code,   I want the files to be month wise, let me check and let u know   ... View more

Hello All,   Finally i have developed a macro that helps me to append daily datasets  to monthly datasets.   thanks to Shmuel...   %macro combine; data eag_rep.AB003_2015dec; set %do i=1 %to 31; %if %length(&i) = 1 %then %let i=0&i; eag_rep.AB003_201512&i %end; ; run;  %mend;  %combine; ... View more

hi Shmuel,   i tried the following code.     GOPTIONS ACCESSIBLE; 24 %macro cre_monthly(prefix,yyyymm); 25 proc datasets lib=eag_rep nolist; &prefix.&yymm; run; 26 27 %do i=1 %to 31; 28 %if %length(&i) = 1 %then %let i=0&i; 29 %let dsn = &prefix.&yyyymm.&i; 30 %if %sysfunc(exist(&dsn)) %then %do; 31 proc append base=eag_rep.et002_2017FEB data=&dsn; 32 run; 33 %end; 34 %end; 35 %mend cre_monthly; 36 %cre_monthly(et002_,201702); /* usage example */ WARNING: Apparent symbolic reference YYMM not resolved. NOTE: Enter RUN; to continue or QUIT; to end the procedure. NOTE: Line generated by the macro variable "YYMM". 36 et002_& ______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Statements not processed because of errors noted above.   but the output dataset appended only till 20170209 , not after that also i got the above error. ... View more

Hi Shmuel,   i get flat files, every day, and by excuting my code i generate sas datasets as below   ab002_20170207 ab003_20170207 . . . . ab013_20170207 I get 13 files every day , now , i have 2 things to do 1.I need to append it monthl wise , for the past 24 months 2. I need to write code that does this for the ongoing( for ongoing i guessthe following code works) proc append base=ab002_2017JAN data=ab002_&tdate; run;  &tdate is the macro that has everydays date.   Plz correct me if am wrong ... View more

hi Shmuel,   THank you for the reply and the code.   i dont want to dlete the previuos monthly data, but i want to develope dataset for each month.   EX: ab002_2017JAN, ab002_2017FEB, like wise for the past 24 months Please suggest ... View more

the name convention are as follows ab002_20170303 ab002_20170304 ab002_20170305   and i want teh monthly dataset as AB002_17JAN,AB002_17FEB etc.,   AB002_17JAN should have all the daily datasets appended   ... View more