Numeric to Date

Reply
New Contributor
Posts: 4

Numeric to Date


How can I convert a numeric variable to become a date variable. I have a year variable with values such as 2010, 2011, 2012 and when I try and convert from numeric to date it makes it 1965.

Super Contributor
Posts: 1,636

Re: Numeric to Date

example:

data year;

input year@@;

cards;

2000 2010 2013

;

data dates;

set year;

b_date=mdy(1,1,year);

m_date=mdy(6,15,year);

e_date=mdy(12,31,year);

format b_date m_date e_date mmddyy10.;

proc print;run;

New Contributor
Posts: 2

Re: Numeric to Date

Hi SMorrison07

A date variable in SAS is just another numeric variable. To be meaningful as a date the value is defined as the number of days between January 1st 1960 and the date the value is representing. Therefore is you take your existing numeric value of the year 2000 and try to use it as a date (e.g. in a date function or formatted for display) this will represent 2000 days from January 1st 1960, which is somewhere in 1965 :-)

To 'convert' it to a date you need to convert it to an appropriate number of days. This is what the function mdy is doing in Linlin's response. This function takes 3 arguments: months, days, years. As you only have the year, you need to decide at what point during that year you want to represent the date, e.g. beginning, middle, end, or any other point you choose.

You can then use your modified value with date formats or functions as you like.

Hope that helps

Ask a Question
Discussion stats
  • 2 replies
  • 234 views
  • 0 likes
  • 3 in conversation