Hi boas3ad, If the date has been entered on the Excel spreadsheet as a character string, you need to specify in the input statement as a character string, then convert to date as follows: labdt = input(lab_date,date9.); format labdt date9.; Also note that Excel and SAS having different reference dates (i.e. Day 0 in SAS is 1 January 1960 and Day 0 in Excel is 1 January 1900), Use below formulaes to get the date time correct. SAS_date = Excel_date - 21916; SAS_time = Excel_time * 86400; SAS_date_time = (Excel_date_time - 21916) * 86400; Thanks, Daman
... View more