topic How do I Update a date field with today's in datetime format in SAS Programming

How do I Update a date field with today's in datetime format

mmohotsi — Mon, 31 Jan 2022 12:26:11 GMT

Greetings

I have a table that has a datetime field and would like to update the field with today's date using the datetime format.

I have seen a way of updating a number field by doing this in the attached dataset:

Proc sql;

update test2

set hour = 50;

quit;

The code updates all values of the field "Hour"

I would like to update the field Date with today's date.

Furthermore, it might be required to update only a specific record say where name = 'John'. will there also be a way of updating specific record?

Thanks in advance

Re: How do I Update a date field with today's in datetime format

PeterClemmensen — Mon, 31 Jan 2022 12:28:11 GMT

Proc sql;
   update test2
   set hour = datetime
   where name = 'John';
quit;

Re: How do I Update a date field with today's in datetime format

PaigeMiller — Mon, 31 Jan 2022 12:39:04 GMT

Proc sql;
    update test2 set date = datetime();
    alter table test2 modify date integer format=datetime16.;
quit;

Now test2 is a datetime value. NOTE: in some places you ask for a datetime value, and in other places you ask for a date value, which is it?

Re: How do I Update a date field with today's in datetime format

mmohotsi — Mon, 21 Feb 2022 12:10:26 GMT

Greetings

The solution worked perfectly. The customer request that I format today's date as a datetime field to a format 2022-02-21 13:56:45. This format starts with a year as it will suits his database field

The datetime in the accepted solution provides a datetime format that starts with the day and not the year.

Is there a way to update the field with this format?