This was very helpful information, Ivm, especially the part about stacking the data and adding a variable to identify the group(s); I never thought about doing this! Thank you! 😄 ... View more

Do you need to loop or just read all of the datasets in one step? So lets get a string that looks like a date in YYYYMMDD style. %let date=20200210 ; Then to get year and month we just need the first 6 characters. No need to for any knowledge of actual dates.  So you can use the colon wildcard to tell SAS to read all datasets that start with BALANCE_202002.  You might need include a %UNQUOTE() function call to make sure the parse doesn't treat %substr() function call as breaking the dataset name into three tokens instead of one. data example; set %unquote(balance_%scan(&date,1,6):) ; run; ... View more

Perfect; this gets the job done. Thank you!!! ... View more

It is doing what you asked it to do. Since you did not attach any format to the new variable DATE2 it is just showing you the raw number of days since 1960. 21,564 is the value for the 15th date of January in the year 2019. 1119 data _null_; 1120 date='15JAN2019'd ; 1121 put date= comma10.; 1122 run; date=21,564 Tell SAS how you want the number of days displayed by attaching a format. proc sql; create table example2 as select put(&YYMM.,Z4.) as YYMM , Acct_No , sum(Balance) as BalAmt , avg(Balance) as Avg_Bal_Amt , avg(Mon_Var) as Month , catx('/',calculated Month,15,substr(calculated YYMM,1,2)) as Date , input(catx('/',calculated Month,15,substr(calculated YYMM,1,2)),mmddyy10.) as Date2 format=date9. from example1 ; quit; PS DO NOT USE ONLY TWO DIGITS FOR YEAR!!!! ... View more

Straight forward and to the point; thanks, KurtBremser. ... View more

Thank you draycut; this is just what I was looking for! ... View more

Hi Supp,   This works!  I forgot about the width and this does the trick - thank you! ... View more

You could use another INTNX() to move the start of the day. intnx('dtday',intnx('dtmonth',XXX,-1,'e'),0,'b') Or if you are just generating strings you could just generate the date part and add the zero time part as constant text. %let end=%sysfunc(intnx(month,%sysfunc(today()),-1,e),date9.):00:00:00; ... View more