Can anyone help me with the following?    proc export data=have outfile="&output.want.dat" dbms=DLM replace; run;   I have my libname created. But this one is not working ... View more

Table X gvkey fyear Name 1004 1994 a 1004 1995 a 1004 1996 b 1004 1997 b Table Y gvkey fyear Name 1004 1992 a 1004 1993 a 1004 1996 e 1004 1997 f   I want to merge the above two tables in the following way gvkey fyear Name 1004 1992 a 1004 1993 a 1004 1994 a 1004 1995 a 1004 1996 b 1004 1997 b You can see that I want every observation from table X but from table Y I want only those observations that matches GVKEY but don't match fyear. From table Y if gvkey and year matches, I don't want those observations to be included in my result. Can anyone help me with how I can do this by using proc SQL? I tried to do that using left join but I don't get the desired result.    ... View more

gvkey fyear rd Desired values (KC) 1001 1980 2.5 2.50 1001 1981 3.1 5.10 1001 1982 0.7 4.78 1002 1980 1.2 1.20 1002 1981 5.5 6.46 1002 1982 12.4 17.57 1003 1980 4.6 4.60 1003 1981 2.9 6.58 1003 1982 1.8 7.06 1003 1983 12.45 18.10 1003 1984 15.55 30.03 1003 1985 16.87 40.89       Hi, From the above data, I want to calculate values in the "Desired Value" column.  Desired value = 0.8*lag(kc)+rd.  Here, for each of the first observation according to gvkey, there is no kc. So, for the first gvkey the equation will be  Desired value = 0.8*0+rd. That means, the first gvkey kc is zero. I used the following code   Data want; set have; by gvkey fyear; retain kc; if first.gvkey then kc=rd; else kc = 0.8* lag(kc) +rd; run;   Problem is that I am not getting the desired result. Could you please help me? What mistakes am I making?  ... View more

gvkey year RET 1004 1992 -0.04762 1004 1993 0.0138 1004 1994 -0.00429 1004 1995 -0.14493 1004 1996 0.067797 1004 1997 0.107302 1004 1998 0.072464 1004 1999 0.057027  1331 1992 0.038333 1331 1993 -0.05405 1331 1994 -0.04286 1331 1995 -0.03343 1331 1996 -0.03125 24456 1992 -0.02621 24456 1993 0.006377 24456 1994 0 24456 1995 0.05 24456 1996 0.060317   I have the above data and aI want the following result   gvkey year RET ret_cut_dummy 1004 1992 -0.04762 0 1004 1993 0.0138 0 1004 1994 -0.00429 1 1004 1995 -0.14493 1 1004 1996 0.067797 0 1004 1997 0.107302 0 1004 1998 0.072464 1 1004 1999 0.057027 1 1331 1992 0.038333 0 1331 1993 -0.05405 1 1331 1994 -0.04286 0 1331 1995 -0.03343 0 1331 1996 -0.03125 0 24456 1992 -0.02621 0 24456 1993 0.006377 0 24456 1994 0 1 24456 1995 0.05 0 24456 1996 0.060317 0   So, I want  dummy variable equals one if there is a reduction in annual ret, and zero otherwise. I use the following code but I am not getting 0 for the first gvkey. Though my data are sorted by gvkey and year, the result I am getting is not by year.  Data want; set have; by gvkey year; if first.gvkey then ret_cut_dummy=0; if ret < lag(ret) then ret_cut_dummy=1; else ret_cut_dummy=0; run; ... View more

Hi, My data are sorted by gvkey and year. I ran the following code.  Data want; set have; if first.gvkey then sales_growth=0; else sales_growth=log((1+sale)/lag((1+sale))); run; I get sales growth number as expected for the whole data set except the following.  Gvkey   year     sale    sales_growth 1004    2000    28796        0      1004    2001    34697          . 1004    2002    36784      0.0601   My question is why I am getting missing value in the 2nd year? In my data set 1004 is the first gvkey. The problem is happening only for the first gvkey. For other gvkey I am not having this problem. Can anyone help me please?     ... View more