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

[t75wez1]

Hi,

Thanks very much for your help in advance.
 Ethan

[ballardw]

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.

[t75wez1]

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,?);

[SASKiwi]

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;

[andreas_lds]

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.