I have a macro that looks into a daily file with yesterday date .I need to import it which works but if I need to bring last month data it keeps giving me july date here is macro Option symbolgen ; %let day2 =%sysfunc (day ( %sysfunc (intnx (day, "&sysdate"d,-3,b)))); Symbolgen: Macro variable sysdate resolves to 03jul17 %let month=.; %let month2=%sysfunc (month ("&sysdate"d)); Symbolgen : macro variable sysdate resolves to 03jul17 %let month=.; %let year=% sysfunc (year ("&sysdate"d)); Symbolgen: macro variable sysdate resolves to 03nul17 %let dash=_; %put &day2 &month2 &year2 ; Symbolgen: macro variable day2 resolves to 30 Symbolgen: Macro variable month2 resolves to 7 Symbolgen: macro variable year resolve to 2017 30 7 2017 % macro setdates; %if &day2 <10 %then %let day=0days2.; %else %let day=&day2.; %if &month2 <10 %then %let month=0&month2.; %else %let month=&month2.; %put &day &month &year ; %mend; I need it to pull data from June it keeps bringing july data ... View more

I have a libname test 'h:/report'; It brings 2 days input1 and input2 I need to append a daily file Proc append base=test.input1 Data=test.input2 force; Run; Which works I do a proc sort Nodup By date ticket; Run, The data appends and removes the dups. The issue is if I run script and it saves 5 days worth of data .the issue if I refer the library next day to pull the 5 days and it's blank data is not stored for future refer ... View more

Hi team, I have a table that uses today dste and I need to add 21 days to it here is what data looks and what I need Id freq dos lot total That's what I have i would need a col for today's date and based on that date i would need 21 days added as labels Today date id freq dos lot total 06/22/17 06/23/17 06/24/17 06/25/17..... ... View more