Help using Base SAS procedures

Create a datetime variable in a datastep

Accepted Solution Solved
Reply
Regular Contributor
Posts: 186
Accepted Solution

Create a datetime variable in a datastep

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.


Accepted Solutions
Solution
‎09-09-2013 06:40 PM
Super User
Super User
Posts: 6,500

Re: Create a datetime variable in a datastep

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

View solution in original post


All Replies
Solution
‎09-09-2013 06:40 PM
Super User
Super User
Posts: 6,500

Re: Create a datetime variable in a datastep

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

Regular Contributor
Posts: 186

Re: Create a datetime variable in a datastep

Thank you very much for your quick reply.

Works like a charm.

Best regards,

nicnad

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 173 views
  • 0 likes
  • 2 in conversation