Hi,   I have a panel dataset like below.   data have; input Firm1 $ Firm2 $ Year flag ratio; datalines; AA1 BB 1995 0 0 AA1 BB 1996 0 0 AA1 BB 1997 0 0.5 AA1 BB 1998 1 0.6 AA1 BB 1999 0 0.5 AA1 CC 1995 0 0.4 AA1 CC 1996 0 0.3 AA1 CC 1997 0 0.2 AA1 CC 1998 1 0.1 AA1 CC 1999 0 0 AA2 DD 1995 0 0.9 AA2 DD 1996 1 0.5 AA2 DD 1997 0 0.4 AA2 DD 1998 1 0.6 AA2 DD 1999 0 0 AA2 EE 1995 1 0.3 AA2 EE 1996 1 0.4 AA2 EE 1997 0 0.9 AA2 EE 1998 0 0 AA2 EE 1999 0 0 ; run; I would like to calculate the average where flag = 1 for each firm in Firm1 in each year. If there is no flag=1 in a year, the average is 0. The expected output is below. Firm1 Year average AA1 1995 0 AA1 1996 0 AA1 1997 0 AA1 1998 0.35 AA1 1999 0 AA2 1995 0.3 AA2 1996 0.45 AA2 1997 0 AA2 1998 0.6 AA2 1999 0   what program do I need to use? Thanks. ... View more

Hi,   I have two datasets as below. data have1; input ID $ Var1; datalines; AA 0 AA 0 BB 0 run; data have2; input ID $ Var1; datalines; AA 1 run; I would like to replace all id=AA in have1 with the value of id=AA in have2. The expected results are below.     ID       Var1 AA        1 AA        1 BB        0   I used the following program but it can only replace the value of first AA with 1 and that of the second one is still 0 proc sort data=have1 out=have11; by classD; run; proc sort data=have2 out=have21; by classD; run; data merged; merge have11 (in=q) have21; by id; if q; run; How can I get the expected results? Thanks. ... View more

Hi,   I have a dataset with 288 variables whose name is col2 to col289. I want to replace all values with zeros and the code I used is as below. data want; set have; array n{*} Col2-Col289; do i=1 to dim(n); if n{i}=1 then n{i}=0; end; run; After I used this program, all values are replaced with zeros but there is one more variable called i. All the values in this column are 288. Can anyone tell me why this variable exists and how can I avoid it? Thanks. ... View more

Hi,   I have two datasets below. In Have1, it lists all products for one industry. Pid is the product ID. Year is the year that the product was introduced. Components are the components of each product. data have1; input PID $ Year Components $; datalines; AA 1995 A15 AA 1995 B15 AA 1995 C36 AA 1995 F25 BB 1996 D14 BB 1996 E41 CC 2005 U14 CC 2005 T11 CC 2005 K14 GG 2005 A15 GG 2005 B15 run;   In have2, Pid is the product ID, Fid is the firm that produces the product. Year is the year that this product was introduced and Components are the components in this product. data have2; input PID $ Fid $ Year Components $; datalines; DD 10001 1997 A15 DD 10001 1997 B15 DD 10001 1997 C36 EE 10002 1999 D14 EE 10002 1999 H67 FF 10003 2007 U14 FF 10003 2007 T11 FF 10003 2007 K14 HH 10003 2008 D14 HH 10003 2008 E41 run; I would like to know whether the component combination exists or not compared with its prvious products in the industry.   If the component combinations exist in the products that were introduced in the preceding 5 years, the flag is 0. Otherwise, the flag is 1. For example, the component combination of DD (A15, B15, C36) has been presented in previous product AA (A15, B15, C36, F25). So the flag is 0. The component combination of EE (D14, H67) has not shown in previous products, so the flag is 1. The data I want is below.   Fid          Year       Pid     Flag 10001     1997      DD       0 10002     1999      EE       1 10003     2007      FF        0 10003     2008      HH       1     What program do I need to use? Thanks. ... View more

Hi,   I have a dataset as below.     data have; input name $ Var1 Var2 Var3 Var4; datalines; AA 0 0 0 1 AA 0 1 0 0 BB 0 0 1 0 BB 1 0 0 0 run;     I want the dataset as below.   ID          Var_Con AA             0101 BB             1010     what program do I need to use? Thanks. ... View more

Hello,   I have a list of product name like below. data have; input name $; cards; A1 A2 A5 B9 C2 C8; run;         I would like to create dummies for each of them. The data I want is as below.   Name I1 I2 I3 I4 I5 I6 A1 1 0 0 0 0 0 A2 0 1 0 0 0 0 A5 0 0 1 0 0 0 B9 0 0 0 1 0 0 C2 0 0 0 0 1 0 C8 0 0 0 0 0 1   what code do I need to use? ... View more