Hello all,
I am new to the Stata. Can anyone provide any assistance as I need to drop the first twelve month of fund returns in long format where the months that contain no returns data do not count. There are lots of funds in my data set. Below is the example of fund 2 from June 2004 to May 2006. Therefore, following the example in fund 2, I would like to remove the returns from May 2005 to April 2006 (12 month returns). Thank you for any help you can provide.
ic_fund year returns Date
2 174 01jun2004
2 175 01jul2004
2 176 01aug2004
2 177 01sep2004
2 178 01oct2004
2 179 01nov2004
2 180 01dec2004
2 181 01jan2005
2 182 01feb2005
2 183 01mar2005
2 184 01apr2005
2 185 -.6 01may2005
2 186 4.5 01jun2005
2 187 -.2 01jul2005
2 188 3.3 01aug2005
2 189 -.1 01sep2005
2 190 -2.7 01oct2005
2 191 -2.1 01nov2005
2 192 2.3 01dec2005
2 193 1.4 01jan2006
2 194 .6 01feb2006
2 195 4.3 01mar2006
2 196 2.9 01apr2006
2 197 -.4 01may2006
Related Posts with How to drop the first twelve month of fund returns
Probit model constant termHey I have a sample with different start ups, the funding amount, and three different investor type…
Data managementHello, I have Data like this input double id str6 V1 long V2 long V3 1 "A" 20180103 20180830 2 "B" …
Advice on which model to use with binary dependent variable and endogenous ordinal independent variableHello, I have come to a roadblock in my research. I am trying to figure out what type of model to us…
Margins after -gsem-Dear all, I am having some trouble with my margins command after -gsem-. Here below my data looks l…
Generating Variable Based On Several ConditionsDear board members, the simplified structure of my data is as follows: i have a panel data set on t…
Subscribe to:
Post Comments (Atom)
0 Response to How to drop the first twelve month of fund returns
Post a Comment