I need to insert a specific value into a date variable, but am having a hard time figuring out how to handle it.
The VALID_TO date needs to be set to "06.mar.12 03:33:38", which uses the format NLDATM21.
proc sql;
update testdata
set VALID_TO = XXXXXXX
where insured_id = 123456;
quit;
Please advise me on this. Thanks for your time .
Is the format important?
The easiest way to insert datetime values is to use the dt literal, which has the argument formatted as DATETIME
valid_to = '06Mar2012:03:33:38'dt
You can convert your datetime constant using the input function:
valid_to = input('06mar.12 03:33:38',nldatm.)
Is the format important?
The easiest way to insert datetime values is to use the dt literal, which has the argument formatted as DATETIME
valid_to = '06Mar2012:03:33:38'dt
You can convert your datetime constant using the input function:
valid_to = input('06mar.12 03:33:38',nldatm.)
Perfect, thank you. For this, and for your countless other good advice.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.