date/time parsing

aishajennifer1 — Thu, 26 Dec 2019 18:37:02 GMT

I currently have the date/time format in this: "Thurs Dec 19 12:30:31 2019"

I would like to create a new variable so that I am just shown date/time: 19DEC19 12:30:31"

How do I do this?

I am using this as my guide but there is no format that falls in the category above: https://v8doc.sas.com/sashtml/lrcon/zenid-63.htm

Re: date/time parsing

Kurt_Bremser — Thu, 26 Dec 2019 19:22:32 GMT

Use the scan() function to extract the 3rd, 2nd and 5th "word", concatenate and use the date9. informat to convert to a date. Use the time8. informat on the 4th "word", and then you can build the datetime from the date and time.

@aishajennifer1 wrote:

I currently have the date/time format in this: "Thurs Dec 19 12:30:31 2019"

I would like to create a new variable so that I am just shown date/time: 19DEC19 12:30:31"

How do I do this?

I am using this as my guide but there is no format that falls in the category above: https://v8doc.sas.com/sashtml/lrcon/zenid-63.htm

topic date/time parsing in SAS Programming

date/time parsing

Re: date/time parsing