converting datetime20. to a character.

[Citrine10]

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. 

[PeterClemmensen · Accepted solution]

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

[Tom]

---

@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.

[Kurt_Bremser]

Alternatively, use the VVALUE Function