Create a datetime variable in a datastep

[nicnad]

Hi,

I would like to add a date in datetime20. format to an existing table, but the format of my variable is converted to a numeric value. I use the following code :

%LET mydatepres = '09SEP2013:0:0:0'dt;

data icoplib.add_to_history;

set icoplib.final;

reportproductiondate = &mydatepres ;

run;

How do I make it so that the value in reportproductiondate column will be 09SEP2013:0:0:0 and that the format of this column will be datetime20.

Thank you for your help and time.

[Tom · Accepted solution]

You just forgot to attach the format to your new variable.  It is storing the number of seconds since 1/1/1960 and the format is what makes it human readable.

%LET mydatepres = '09SEP2013:0:0:0'dt;

data want ;

   reportproductiondate = &mydatepres ;

   format  reportproductiondate datetime20. ;

   put (_all_) (=);

run;

reportproductiondate=09SEP2013:00:00:00

[nicnad]

Thank you very much for your quick reply.

Works like a charm.

Best regards,

nicnad