I'm trying to make YEAR (eg. 2007) as a year so I can use it in proc expand for interpolation. doing YEAR YEAR4.; just converts it to a sas date year.. I want it to be left as 2007 as a date.
Do you want something like this?
data have;
informat date mmddyy10.;
format date mmddyy10.;
input date;
year=year(date);
cards;
12/10/2011
12/11/2010
12/10/2009
;
proc print; run;
All I have in the cards is :
cards;
2011
2010
2009
;
Do I create a mock MONTH and mock DAY .. remember I need to intrapolate.
Thanks
Do you want something like this?
data have;
format date mmddyy10.;
input year;
date=mdy(1,1,year);
cards;
2011
2010
2009
;
proc print; run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.