topic Re: Setting a specific NLDATM21. date value? in SAS Data Management

Setting a specific NLDATM21. date value?

EinarRoed — Thu, 04 Oct 2012 08:42:01 GMT

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 .

LinusH — Thu, 04 Oct 2012 08:57:13 GMT

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.)

EinarRoed — Thu, 04 Oct 2012 10:38:25 GMT

Perfect, thank you. For this, and for your countless other good advice.