topic Re: converting datetime20. to a character. in New SAS User

converting datetime20. to a character.

Citrine10 — Fri, 19 Aug 2022 11:43:33 GMT

I need help with converting datetime20. to a character.

The format of the data is as follows:

18AUG2022:13:41:10

I need to convert it to character because I am concatenating this field with another character field.

Re: converting datetime20. to a character.

PeterClemmensen — Fri, 19 Aug 2022 11:45:27 GMT

data test;
   dt  = '18AUG2022:13:41:10'dt;
   cdt = put(dt, datetime20.);
   format dt datetime20.;
run;

Re: converting datetime20. to a character.

Tom — Fri, 19 Aug 2022 12:55:35 GMT

@Citrine10 wrote:

Hi

I need help with converting datetime20. to a character.

The format of the data is as follows:

18AUG2022:13:41:10

I need to convert it to character because I am concatenating this field with another character field.

In that case you probably do not want to use DATETIME format. Instead use something like E8601DT19. that will generate a string that will sort in chronological order.

Re: converting datetime20. to a character.

Kurt_Bremser — Sun, 21 Aug 2022 07:02:21 GMT

Alternatively, use the VVALUE Function