Date code rtrn exp new 2011 20 0.0098 0.0092   2012 20 0.0257 0.1235   2012 31 13.2087 0.000087   2013 31 0.00987 -0.0005479   2011 35 0.12458 -0.215   2012 35 1.205789 0.2258974   2013 87 0.1259     2014 87 -0.25874     2013 99 -0.12589     2014 99 0.0365       I have to select rtrn in new columns within a range of 70% to 140% of first exp value by code. If rtrn is within a value of 70% to 140% then we say yes otherwise no. And the I have to maintain the result by code. So, in the new column I will get either "yes" or "No/blank if it is not within the range" ... View more

code date Rtr exp new 20 2011 0.115225 0.114746   20 2012 0.101424 0.11639 0.231615 20 2013 0.114746 0.055248 0.156672 23 2011 0.11639 0.094931   23 2012 0.055248 0.173508 0.289898 23 2013 0.094931 0.190566 0.245813 55 2011 0.029143 0.073573   55 2012 0.060995 0.085915 0.115057 55 2013 0.069918 0.075433 0.136429   I want to add rtr in 2011 with exp in 2012. So my result will be equal to as shown in New column. It is adding the lag value of rtr with the current value of exp. The result should be grouped by code. Please help.  ... View more

Set A Set A Set A   Set B Set B   Set C Set C Set C Set C Permno Date Rtrn   Permno date   Permno Date Rtrn event_date 11061 20110531 0.115225   10909 20120701   11061 20110531 0.115225 -2 11061 20120531 0.101424   11061 20130820   11061 20120531 0.101424 -1 11061 20130531 0.114746   11264 20130402   11061 20130531 0.114746 0 11061 20140531 0.11639   11308 20120813   11061 20140531 0.11639 1 11061 20150531 0.055248   12054 20130701   11061 20150531 0.055248 2 11061 20160531 0.094931   12149 20130809   11061 20160531 0.094931 3 12169 20111231 0.029143   12169 20130701   12169 20111231 0.029143 -2 12169 20121231 0.060995   12357 20120201   12169 20121231 0.060995 -1 12169 20131231 0.069918   12370 20120516   12169 20131231 0.069918 0 12169 20141231 0.150442         12169 20141231 0.150442 1 12169 20151231 0.183641         12169 20151231 0.183641 2 12169 20161231 0.152767         12169 20161231 0.152767 3 12370 20111231 0.173508         12370 20111231 0.173508 -1 12370 20121231 0.190566         12370 20121231 0.190566 0 12370 20131231 0.073573         12370 20131231 0.073573 1 12370 20141231 0.085915         12370 20141231 0.085915 2 12370 20151231 0.075433         12370 20151231 0.075433 3 12370 20161231 0.112746         12370 20161231 0.112746 4   I need help with the above data. I have two different files, Set A and Set B.  I want to merge these two files as in Set C.  Set B shows some event dates. In Set C, those years will be zero and after the event year there will be positive serial numbers and before that negative serial numbers.  The files need to be merged based on permno and date. If you need you can only keep year(not month and day) in date variables.  ... View more

Hi,  I know that the following is applicable for equal variance levene's test.    Proc glm data=want;    class age;    model y=age;    means age / hovtest; run;   But if I have two variables with interaction term, what will be the code for levene's test? I tried the following but it didn't work.   Proc glm data=want;    class age sex;    model y=age sex age*sex;    means age sex age*sex/ hovtest; run;   Please help ... View more