data new; comm_time = '13:08:09'; numeric_comm_time = input(comm_time, ???.); run;
The actual dataset shows the comm-time as a char variable. Since I will need to use the comm_time in a calculation with a date
IE if date1 < date2 and com_time1 < comm_time 2 then do something......
I will need to display/convert the char variable to a numeric variable. I just do not know what to insert in the input value where I am showing ??? Notice it shows as 13:08:09. Is there an informat to address this???
Quite obvious: you want to read a time, and the length of the string is 8, so try TIME8.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.