Hey guys.
I have a created a program that is going to grab data from one excel spreadsheet and chuck it into another one weekly. It is going to import the data into a specific named range for that week.
My question - Is there any code that I can use that changings the name in my code to the date 7 days ago?
For example, this is part of my current code -
libname xls excel 'H:\TEST.xlsm';
proc datasets lib = xls nolist ;
delete Q20160210 ;
quit ;
data xls.Q20160210 ;
set THISMONTH ;
run ;
libname xls clear;
Is there any way to get the progame to automatically change Q(Date) to Q(Todays Date - 7)?
Hopefully this makes sense and thanks in advance.
Josh
... View more