thanks, very useful shortcut!! ... View more

Always a 5* quick reply and an answer. Thank you! ... View more

Alright, that appears to explain it. When I change my VALIDVARNAME option to V7 then the variable names in the dataset I tested were the same case as in the code and not uppercase anymore. So, when and if I ever post to the forum again, I will have to think about changiing that option especially if I quote any variable strings. Rich ... View more

HI Arthur I tried but gave an error, if &obs is great than 100, then this does not work. ... View more

Mike018 use a format in the PUT statement in your data _null_ step. peterC ... View more

data convert;           charvar = '2011-01-01-08.35.26';           numdt = input(charvar,anydtdtm.);           date = datepart(numdt);           time = timepart(numdt);           put charvar= numdt= date= yymmddn8. time= time8.; run; charvar=2011-01-01-08.35.26 numdt=1609490126 date=20110101 time=8:35:26 ... View more