Hello,
I would like to create a lag variable for D based on qtr and mgrno. Obviously LAG doesn't work here because it doesn't recognize different mgrno.
Any ideas on this?
Many thanks in advance.
Sort the data in the right order then LAG() function will work.
data want ;
set have ;
by mgrno ticker qtr ;
lagd=lag(d);
if first.ticker then lagd=.;
run;
If you can, give an example of what you actually want with you data as an output. I am not worrking what you mean by lag of qrt and mgrno, and your statement about lag.
Example, your qtr of 1980-4 has the mgrno 260 40 times. Do you want the D field lagged by 1 onto each of the 260 fields (so row 1 gets lagged into row 2). Or did you want the data structured as is to be lagged, regardless of the order or MGRNO?
What I would like to do is to have the Lag Value of D for each mgrno for each stock separately.
Each stock has many investors. I want the lagged value for the particular investor.
So for example
1981-1 520 AA should have the value of 1980-4 520 AA
1981-1 835 AA should have the value of 1980-4 835 AA.
I hope you can understand what I mean.
Many thanks.
Sort the data in the right order then LAG() function will work.
data want ;
set have ;
by mgrno ticker qtr ;
lagd=lag(d);
if first.ticker then lagd=.;
run;
Many thanks Tom!
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.