Thank you! ... View more

Thank you for your help. Is there a way to keep track of dates that have been adjusted? ... View more

Please see the example below. Thank you.   data TEST; input oldvar $; if substr(oldvar, 7, 2) = ".." then do; newvar = input(trim(oldvar) !! '01',yymmdd8.); newvar = intnx('month',newvar,0,'end'); end; else newvar = input(oldvar,yymmdd8.); format newvar yymmdd8.; datalines; 20160520 201505.. 19970116 199901.. ; run; ... View more

Thank you. What if I wanted to replace with the last day of given month? ... View more

Thank you. I still get errors thougth.  The missing dates look like that 201605.. ... View more

Thank you. What if the last 2 digits for a day had the following ".." instead of nothing? How can I make this work? I also wanted to name the complete dates another name to be able to keep track of what is the real input, and what is corrected. Thank you again! ... View more