Setting a specific NLDATM21. date value?

[EinarRoed]

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 · Accepted solution]

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]

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