Hi all, I have the code below DATA want; SET have; If cvt_yr=-4 then dkt_4=1; else if cvt_yr=-3 then dkt_3=1; else if cvt_yr=-2 then dkt_2=1; else if cvt_yr=-1 then dkt_1=1; else if cvt_yr=0 then dkt=1; else if cvt_yr=1 then dkt1=1; else if cvt_yr=2 then dkt2=1; else if cvt_yr=3 then dkt3=1; else if cvt_yr>=4 then dkt4=1; run; I am wondering what is the difference between this code with DATA want; SET have; If cvt_yr=-4 then dkt_4=1; if cvt_yr=-3 then dkt_3=1; if cvt_yr=-2 then dkt_2=1; if cvt_yr=-1 then dkt_1=1; if cvt_yr=0 then dkt=1; if cvt_yr=1 then dkt1=1; if cvt_yr=2 then dkt2=1; if cvt_yr=3 then dkt3=1; if cvt_yr>=4 then dkt4=1; run;   ... View more

Hi all SAS experts,   I have a code as below if geogn="UNITEDS" & yr=1989 then cvt_yr=-4; else if geogn="UNITEDS" & yr=1990 then cvt_yr=-3; else if geogn="UNITEDS" & yr=1991 then cvt_yr=-2; else if geogn="UNITEDS" & yr=1992 then cvt_yr=-1; else if geogn="UNITEDS" & yr=1993 then cvt_yr=0; else if geogn="UNITEDS" & yr=1994 then cvt_yr=1; else if geogn="UNITEDS" & yr=1995 then cvt_yr=2; else if geogn="UNITEDS" & yr=1996 then cvt_yr=3; else if geogn="UNITEDS" & yr=1997 then cvt_yr=4; else if geogn="UNITEDS" & yr=1998 then cvt_yr=5; I am wondering how to shorten the code (because I need to do the same thing for 64 countries). And the time series is from 1990 to 2020, but I just want to focus on 9 years around 1993 as above (I mean, a condition for  -4 <= cvt_yr <= 5) Thank you in advance. Have a good weekend, Phil. ... View more

Hi all, Have a fabulous weekend, I have a conditional code below The idea is that: my dataset for these countries is from 1989 to 2020 (yr from 1989 to 2020). But I just want to keep the sample from 1990 to 2020   Afterward, I want to create a variable called pt. The pt variable receive the value of 0 if geogn="UNITEDS" and the year is from 1990 to 1992 (one year before 1993) and receiving the value of 1 if geogn="UNITEDS" and the year is from 1993 to 2020. Similarly,  the pt variable receiving the value of 1 if geogn=" SOUTHKOREA " and the year is from 1997 to 2020 and receive the value of 0 from 1990 to 1996(one year before 1997). A similar creation for other countries, where 1993, 1997, 2000,2001, 2004, 2018 are law implementation years of the countries. My novice code is as below data gen_post_treat; set matching; yr=input(year, ?? 32.);/*year is a character variable, so I convert to numeric variable*/ if geogn="UNITEDS" & yr in (1993:2020) | geogn="SOUTHKOREA" & yr in (1997:2020) | geogn="BRAZIL" & yr in (2000:2020) | geogn="CANADA" & yr in (2000:2020) | geogn="CZECH" & yr in (2001:2020) | geogn="LATVIA" & yr in (2004:2020) | geogn="VIETNAM" & yr in (2018:2020) then pt=1; else if yr ne 1989 then pt=0; run;   And last but not least, I want to create a variable called the converted year (named cvt_yr) that focuses on 9 years surrounding the law implementation years. For example, in  SOUTHKOREA case:   cvt_yr= -4 if geogn="SOUTHKOREA" & yr=1993 cvt_yr= -3 if geogn="SOUTHKOREA" & yr=1994 cvt_yr= -2 if geogn="SOUTHKOREA" & yr=1995 cvt_yr= -1 if geogn="SOUTHKOREA" & yr=1996 cvt_yr= 0 if geogn="SOUTHKOREA" & yr=1997 cvt_yr= 1 if geogn="SOUTHKOREA" & yr=1998 .... cvt_yr= 5 if geogn="SOUTHKOREA" & yr=2002 Similarly cvt_yr= -4 if geogn="CZECH" & yr=1997 ... cvt_yr= 0 if geogn="CZECH" & yr=2001 ... cvt_yr= 5 if geogn="CZECH" & yr=2006   Similarly applied for other countries. For UNITEDS , we only trace back to 1990 due to data limitation cvt_yr= -3 if geogn="UNITEDS" & yr=1990 and for Vietnam, we only trace forward to 2020 due to data limitation cvt_yr= 2 if geogn="VIETNAM" & yr=2020 Please let me know if my explanation is not clear.   Thank you so much and warm regards. Phil.     ... View more

Hi all, I want to ask how to control firm and industry*year fixed effects in proc glm? My regression when regressing controlling for firm and year fixed effect is as below: proc glm data=merge_treat_con_6th_may; ABSORB TYPE; class yr / truncate; model y= x1 x2 x3 yr/solution ss3; run; quit; While TYPE and yr are firms and years accordingly. Now I want to control for firm and industry*year fixed effect while INDC3 is industry indicator and character variable. Could you please let me know how to adjust the code above to do so?   Thank you and warm regards. ... View more

Hi all,    I send a request to SAS Tech support, they asked me to send over the log of some code. However, I do not know how to extract the log? The easiest way I can think of is to copy all the log to a Microsoft Word file, but it seems not really professional. My interface is I am using SAS EG 8.3   Can you please hint me out?   Thank you and have a good weekend. ... View more