topic Converting date time str character to numeric in SAS Programming

Converting date time str character to numeric

Scooby3g — Fri, 21 Apr 2023 13:13:31 GMT

Hi, how do I convert a date time value in this format (YYYY-MM-DD HH:MM:SS) into a numeric date?

When I run the below code want_str only has a "."

Thank you for your help in advance!

data have;
	str="2023-02-03 15:49:06";
	Want_str=input(str, mmddyy10.);
	format want_str mmddyy10.;
run;

FreelanceReinh — Fri, 21 Apr 2023 13:21:07 GMT

Use the proper informat:

Want_str=input(str, yymmdd10.);

(Why do you use the suffix "str" for a numeric variable?)

Scooby3g — Fri, 21 Apr 2023 13:25:43 GMT

Thank you @FreelanceReinh !!!!!!

The word/acronym "Str" was just on top of my head at the moment so I just used it as an example variable name.

Posting the data step for anyone who needs it in the future!

data have;
	str="2023-02-03 15:49:06";
	Want_str=input(str, yymmdd10.);
	format want_str mmddyy10.;
run;