Support needed for converting date in text format to numeric

explorenowblog
Tera Contributor

"Dear fellow SAS users, firstly I hope to achieve the level to be able to help others but I am afraid that may take a while 🙂 I have a dataset with dates (Date_and_time_of_assessment) in Character format like this: 2023-01-26T07:00.

I want to convert these values into a numeric format so I can use them for calculation purposes.

I have tried SAMP_DT=INPUT(Date_and_time_of_assessment, anydtdtm16.); but that does not work. Could anyone help me, it is much appreciated. 

0 REPLIES 0