I have file analyst.main that list down the recommendations given by financial analyst during each year, thus there would be several recommendation (var=numrec) thru out the whole year given by date variable statpers. However I only need to select the recommendation that is given towards the end of the financial year. The enddate of the financial year is given by variable enddate, or we should select the final observation for each financial year.
for example for gvkey 001004 (first company), the fyear is 2000, thus the observation to be selected should be the 5th observation, as that is the last one in fy2000. The numrec=6.
So how do i output one dataset with each company with just one observation for each fyear?
Thanks, with data attached.
Looking at the data, you're right in thinking that you just need to output the last observation per gvkey and enddate group.
data want;
set analyst.main;
by gvkey enddate;
if last.enddate;
run;
Looking at the data, you're right in thinking that you just need to output the last observation per gvkey and enddate group.
data want;
set analyst.main;
by gvkey enddate;
if last.enddate;
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.