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
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?
Proc sql;
update test2
set hour = datetime
where name = 'John';
quit;
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?
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?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: