topic Re: Create a datetime variable in a datastep in SAS Procedures

Create a datetime variable in a datastep

nicnad — Mon, 09 Sep 2013 22:18:46 GMT

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.

Re: Create a datetime variable in a datastep

Tom — Mon, 09 Sep 2013 22:40:57 GMT

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

Re: Create a datetime variable in a datastep

nicnad — Tue, 10 Sep 2013 12:53:15 GMT

Thank you very much for your quick reply.

Works like a charm.

Best regards,

nicnad