topic Re: Datetime format which excludes seconds in SAS Programming

Datetime format which excludes seconds

shantanupl1 — Tue, 21 Sep 2021 13:45:55 GMT

Hi All,

I have a date variable which I want to display like this YYYYMMDD:HH:MM. I don't want to display the seconds value. I am not able to find any date time format which will help me in the above scenario.

Can anyone tell me how to do this. Do we have any format available to do this?

id date

101 2021-01-21:15:25

102 2021-02-15:08:30

...

Shantanu

Re: Datetime format which excludes seconds

PaigeMiller — Tue, 21 Sep 2021 13:52:34 GMT

Format datetime14. will not display seconds.

Format e8601dt16. will not display seconds.

And probably many others...

Re: Datetime format which excludes seconds

shantanupl1 — Tue, 21 Sep 2021 13:54:12 GMT

Thank you.

But if I want the complete year then what should we do. Because using datetime14. will give the year values in 2 digit.

Thanks & Regards

Shantanu

Re: Datetime format which excludes seconds

PaigeMiller — Tue, 21 Sep 2021 14:08:26 GMT

e8601dt16.

Or, create your own custom format using the PICTURE statement

Re: Datetime format which excludes seconds

shantanupl1 — Tue, 21 Sep 2021 14:34:53 GMT

Thank you.

It worked using picture statement.

Re: Datetime format which excludes seconds

PaigeMiller — Tue, 21 Sep 2021 14:38:25 GMT

Yes, that's good to hear.

I never realized this particular deficiency of the DATETIME. format: you can't chop off the seconds and get 4 digits years.

Re: Datetime format which excludes seconds

shantanupl1 — Tue, 21 Sep 2021 15:10:06 GMT

But if we create a picture format apply the format it converts the variable into a numeric variable not a date variable. Do you have any way to overcome this so that the variable should remain a Date variable after we apply the user defined format.