experts,   here is my time variable looks like   8:42:00 13:07:00 12:30:00 i am importing the excel file and converting to sas datasets using proc import and some how sas is displaying as 30DEC1899 in most of the observations and few other dates.    here is my code   proc import datafile="location." out=outlocation dbms=excel replace; getnames=yes; mixed=no; scantext=yes; usedate=yes; scantime=yes; quit;   i want to read the excel file time variable into sas exactly as i pasted above and the file is .xls format (2016 excel).   thank you sunny ... View more

experts,   i am sas programmer with 5 years of programming experience and i am interested in learning the sas admin skills..   any books you guys could recommend  ..appreciate your response..   thanks sunny ... View more