Hi,
Can someone tell me if there is a quick way to add an variable that take the value of the last month of each year and apply it for the next year, and the first year would have empty value. Thanks in advance!
Date ID Value WANT
example:
data have;
input date mmddyy10. v;
format date mmddyy10.;
cards;
10/31/2010 8
12/31/2010 9
10/31/2011 9
12/31/2011 10
01/31/2012 15
;
data want;
retain nv .;
set have;
if month(date)=12 then nv=v;
new=lag(nv);
proc print;run;
Thank you!
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.