topic Re: Datetime Format Help! in SAS Enterprise Guide

Datetime Format Help!

skidooman34 — Fri, 06 Dec 2013 17:40:52 GMT

Hello,

I am needing some help in changing a datetime format back to a date format. For example, I have a value of 28OCT2013:21:26:58.819000

How can I create another variable and keep only the first 9 characters, in this case 28OCT2013 ? Can I do a simple SUBSTR command?

Help would be much appreciated!

ChrisHemedinger — Fri, 06 Dec 2013 17:50:14 GMT

You could use the DATEPART function. Or, simply apply a DATE format and leave the original value as is! See:

Chris

skidooman34 — Mon, 09 Dec 2013 18:17:18 GMT

Thanks for the quick response.

I tried doing the simple date format, I used

28OCT2013:21:26:58.819000 (variable is called ofr_create_dt) and if I simply put

date(ofr_creat_dt) as date1

I got back a result of 19701?

Any ideas?

AncaTilea — Mon, 09 Dec 2013 18:19:07 GMT

...

you then can format the date1 variable with date9. format and you get the date in a more readable format.

date(ofr_creat_dt) as date1

format date1 date9.;

Good luck!

Anca.