topic Reformating of Date (DDMMMYYYY HH:MM:SS) in SAS Programming

Reformating of Date (DDMMMYYYY HH:MM:SS)

deengyn — Tue, 12 May 2020 14:53:34 GMT

Hi all,

I currently have the date (varname: serv_date) presented in the format of (DDMMMYYYY HH:MM:SS). Currently, I'm trying to reformat it so that the table would only contain ddmmmyyyy.

I've tried some solutions such as ...

proc sql; 
create table test as 
select serv_date format = date9.
from plastics_fnl; 
quit;

But the output is quite odd and unexpected.

May someone help identify a solution as well as explain what went wrong in the code I provided?

Re: Reformating of Date (DDMMMYYYY HH:MM:SS)

novinosrin — Tue, 12 May 2020 14:57:17 GMT

How about

proc sql; 
create table test as 
select datepart(serv_date) as serv_date format = date9.
from plastics_fnl; 
quit;

Re: Reformating of Date (DDMMMYYYY HH:MM:SS)

ballardw — Tue, 12 May 2020 15:00:55 GMT

If a value is a SAS datetime value then the units are SECONDS, if a date then the units are DAYS. So you cannot use a date9 format to display datetime. If you assign a datetime9. format then that will appear similar to a date9 format.

OR use the datepart(dtvariable) function to create date value.

Re: Reformating of Date (DDMMMYYYY HH:MM:SS)

deengyn — Tue, 12 May 2020 15:07:11 GMT

Amazing! Thank you for the quick response and help!

Re: Reformating of Date (DDMMMYYYY HH:MM:SS)

PaigeMiller — Tue, 12 May 2020 15:07:36 GMT

You don't need to create a new date variable. All you need to do is assign the DTDATE format.

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=leforinforref&docsetTarget=n1wi7cnt9ozjwan1gl0397h6b0n1.htm&locale=en