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.
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;
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.