topic Re: How to convert the variable named Time='11:51:25 AM' into internal SAS date? in SAS Programming

How to convert the variable named Time='11:51:25 AM' into internal SAS date?

t75wez1 — Thu, 26 May 2022 22:13:47 GMT

Hi,

Thanks very much for your help in advance.
Ethan

Re: How to convert the variable named Time='11:51:25 AM' into internal SAS date?

ballardw — Thu, 26 May 2022 22:24:27 GMT

Since you don't show any DATE information, i.e. year, month or day of the month. Where would date information come from?

To create a TIME value:

data example;
   x='11:51:25 AM' ;
   timevariable = input(x,time11.);
   format timevariable timeampm.;
run;

You could assign any of the time formats for display purposes.

Re: How to convert the variable named Time='11:51:25 AM' into internal SAS date?

andreas_lds — Fri, 27 May 2022 05:17:44 GMT

A date requires year, month and day and has no time information, so it is not possible at all. You could convert the string value to a sas time value, as @ballardw has already shown, or to a datetime with any date you want, but that seems pretty pointless.

Re: How to convert the variable named Time='11:51:25 AM' into internal SAS date?

t75wez1 — Mon, 30 May 2022 23:18:04 GMT

Thanks for the solution.

I got time= substr(date,12,11) from date='05/25/2022 11:51:25 AM'

so the question become how to convert the variable named date='05/25/2022 11:51:25 AM' into internal SAS date.

 timevariable = input(date,?);

Re: How to convert the variable named Time='11:51:25 AM' into internal SAS date?

SASKiwi — Tue, 31 May 2022 00:05:17 GMT

data want;
  date = '05/25/2022 11:51:25 AM';
  SAS_Date = input(substr(date, 1, 10), mmddyy10.);
  format SAS_Date date9.;
  put _all_;
run;