topic Re: How do I format a date in the form 2022-02-22 14:34:16 in SAS Programming

How do I format a date in the form 2022-02-22 14:34:16

mmohotsi — Tue, 22 Feb 2022 12:36:44 GMT

Greetings

I have a table as attached

I have used the following code to update the field processed_on with today's date as a datetime

proc sql;
Update table1Set PROCESSED_ON = datetime();
alter table table1 modify PROCESSED_ON integer
format = datetime16.;quit;

The format on the resultant table is of the form 22Feb2022 14:34:16

How do I format the date field to start with the year like 2022-02-22 14:34:16

Thanks

Re: How do I format a date in the form 2022-02-22 14:34:16

Kurt_Bremser — Tue, 22 Feb 2022 12:39:43 GMT

SAS provides a family of formats compliant with the ISO 8601 standard for dates and times.

If the E8601DT19. format does not suit you because of the "T", roll your own picture format with PROC FORMAT.

Re: How do I format a date in the form 2022-02-22 14:34:16

yabwon — Tue, 22 Feb 2022 15:29:42 GMT

Use (almost 1-to-1) example from the doc:

proc format;
  picture myDateTime (default=19) 
    other = '%Y-%0m-%0d %0H:%0M:%0S' (datatype=datetime);
  ;
run;

data _null_;
  x = '22Feb2022 14:34:16'dt;
  put x myDateTime.;
run;

(example 7) https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n01lvjtpz3ewuhn1cvj3x4yhzyul.htm

Bart

Re: How do I format a date in the form 2022-02-22 14:34:16

ballardw — Tue, 22 Feb 2022 15:44:44 GMT

You do want to be very careful in SAS thinking "date" when the value is actually a "datetime". The units are not the same and when you apply "date" functions to datetime values you may get very unexpected and often unusable results.

Re: How do I format a date in the form 2022-02-22 14:34:16

mmohotsi — Tue, 08 Mar 2022 11:57:42 GMT

The solution worked well