Hi Guys, Is it possible to batch rename files in a windows directory using SAS? Example: Directory : C:\Test\ Files: January_Test1.sas | January_Test2.sas | January_Test3.sas Basically I need to rename the month name for each file manually every month...wondering if there is some way to run a sas command that goes to that directory...renames anything January to February. Updating these values once monthly in a sas command mght make this easier than doing it manually.. Please provide sample code if possible, Thanks. ... View more

Hi There, I have the following code : data _null_;   rootdir='C:\temp\';   today=today();   lastmonth=intnx('month',today,-1);   dir1=catx(' ','DE',year(lastmonth),put(month(lastmonth),z2.)); /*Previous Month*/   newdir1=dcreate(dir1,rootdir);   put (rootdir dir1 newdir1) (=/); run; this generates a directory which is named : DE 2012 01 I would like this to appear as : DE 201201 (notice no gap after year) How would I modify the query to achieve this? Thanks! ... View more

Hi Guys, I have been trying to get this code to work...but no luck so far: %let drive=I:; %let dir1=%nrbquote("AB&C\Reports & Tests\ABC\My Codes\01Jan12"); %let dir2=%nrbquote("AB&C\Reports & Tests\Test ABC\01 - Jan 2012\Test Code"); %sysExec &drive move "&dir1\Code_to_Move.sas" "&dir2" /y ; I get the error message "system cannot find the path specified" in the command prompt. I think it is due to the spaces and the "&" in the folder names but I cannot seem to fix it. Basically trying to copy over a file from one folder to another. Please advise. ... View more