i am trying to create folder dynamically for months like below and include the data exported file in the respective folder biweekly, "D:\Documents\May\test1.xlsx D:\Documents\May\tes2.xlsx" I have written the below code for creating the monthly folder in the respective directory, data _null_; rootdir='D:\Documents\'; today=today(); lastmonth=intnx('month',today,-1); dir1=catx(' ',put(today,monname3.),year(today)); /*dir2= catx(' ',put(day(today),z2.),'-',put(today,monname3.));*/ newdir1=dcreate(dir1,rootdir); /*newdir2=dcreate(dir2,newdir1);*/ put (rootdir dir1 newdir1) (=/); run; But I am stuck after this to export my data(excel file) in these folders dynamically. Can I get any help on this please on how should I go about it, to export my files for every month instead of manually updating the folder everytime?
... View more