hi, for oldest allowed, I just have used what chris has mentioned ... View more

hi Reeza, I made the change in oldest_allowed. but still its not deleteing satasets. Please Note, when I executed the code for the first time, it deleted the datasets. libname A '/data/test1/a1/DATASET'; libname B '/data/test2/a2/DATASET'; libname C '/data/test3/a3/DATASET'; libname CONCAT (A B C ); %let table=; data _null_; OLDEST_ALLOWED=put(intnx('month',today(),-25),yymmn6.); do until(symget('table')=' '); RC=dosubl( 'data _null_;' ||'call symputx("table"," ");' ||'set SASHELP.VSTABLE; ' ||'where LIBNAME="CONCAT" and ' ||'trim(MEMNAME) like "%20____" and ' ||'substr(MEMNAME, length(MEMNAME)-5,6) <' ||quote(OLDEST_ALLOWED) ||';call symputx("table",MEMNAME); stop; run;'); if lengthn(symget('table')) then CR=dosubl( 'proc delete data=CONCAT.'||symget('table')||';run;'); end; run; ... View more

Hi Reez,   I tried your code,used libname concat, but it deleted only the first libname, location file, and rest dint get deleted.   libname A '/data/test1/a1/DATASET'; libname B '/data/test2/a2/DATASET'; libname C '/data/test3/a3/DATASET'; libname CONCAT (A B C ); %let table=; data _null_; OLDEST_ALLOWED='catt(year(today())-2,"_",month(today())-2)'; do until(symget('table')=' '); RC=dosubl( 'data _null_;' ||'call symputx("table"," ");' ||'set SASHELP.VSTABLE; ' ||'where LIBNAME="CONCAT" and ' ||'trim(MEMNAME) like "%20____" and ' ||'substr(MEMNAME, length(MEMNAME)-5,6) <' ||quote(OLDEST_ALLOWED) ||';call symputx("table",MEMNAME); stop; run;'); if lengthn(symget('table')) then CR=dosubl( 'proc delete data=CONCAT.'||symget('table')||';run;'); end; run;   ... View more

nothing was incorrect in ur code, just a change I made ... View more

NOPE 😞 ... View more

currently I have files only from 2015march ... View more

Ideally the code needs to delete the file which is 24 months older and to be in safer side we are deleting any dataset older than 25 months. so the code runs every month and delete the files which are 25 months older. ... View more

Hi , Instead of passing the oldest allowed parameter , i have made a slight modification , as below.   Please correctme if am wrong.   Oldest_allowed=catt(year(today())-2,"_",month(today())-2); ... View more

Also my folder has the following files ab002_201501 ab003_201501 ab007_201501 3 different files with similar naming convention, so I need a code to delete the files older than 24 months from today irrespective of the prefix(ab002_or ab003_ or ab007) ... View more

hi,   Unfortunately i annot concatenate all paths in to one file name, as all the folders are different channels of business.   But i can cahange the naming convention of the datasets, to ab002_201501 instead of ab002_2015jan ... View more

its a new request added to my previous question.   waht i asked was to delete datasets within a library whose name is older than 24 months, now i need to do the same across 13 folders for ex: this is my folder structure: /data/DEV/&iterm/DATASET   the &iterm should get replaced with 13 folder names, like crc,dbt,mer,online,tbt,yrc,lop,kyt,ded,fsw,fgt,kjh,mnb   i am trying to create the macro variable using iterative do loop :   %let name_list= crc,dbt,mer,online,tbt,yrc,lop,kyt,ded,fsw,fgt,kjh,mnb; %macro aruna; %local i next_name; %let i=1; %do %while (%scan(&name_list, &i) ne ); %let next_name = %scan(&name_list, &i); %let i = %eval(&i + 1); %end; %mend aruna;   but the code is not working.   Once this is resolved, i need to develop another code which should be able to delete all datasets which name is 24 months old   ... View more

Hi all,   i need to develop a  global macro that checks nearly 12 libraries under the development folder and if it finds any dataset name older than 24 months (note: not create date, but the name of the dataset eg: ab002_2015apr, gh005_2015mar) it should delete   folder: develoment       chq           1 abc           2 vbg          3 dataset          4 jil       mer          1 abc           2 vbg          3 dataset          4 jil      crc            1 abc           2 vbg          3 dataset          4 jil under Development i have 13 folders and under each folder there are 4 sub folders , and i need to serch and delete datasets only the Dataset folder .   the code should delete all the datasets whose name is 24 months older   ... View more

yes, my datasets are named in such a way.   the code should delete the datset which are 24 months older(by name) ... View more