I want to form a dummy variable where if the value of the variable Suspect_firms is between 0 - 0.005 then its 1 otherwise 0. Could anyone please help with the function/code. My data is as below
[CODE]
* Example generated by -dataex-. For more info, type help dataex
clear
input str9 Ticker int Year float Suspect_firms
"TH:2S" 1995 .
"TH:2S" 1996 .
"TH:2S" 1997 .
"TH:2S" 1998 .
"TH:2S" 1999 .
"TH:2S" 2000 .
"TH:2S" 2001 .
"TH:2S" 2002 .
"TH:2S" 2003 .
"TH:A" 1995 .
"TH:A" 1996 .
"TH:A" 1997 .
"TH:A" 1998 .
"TH:A" 1999 .
"TH:A" 2000 .
"TH:A" 2001 .
"TH:A" 2002 .
"TH:A" 2003 .025012556
"TH:AA" 1995 -.006353655
"TH:AA" 1996 -.0462963
"TH:AA" 1997 -.17009
"TH:AA" 1998 .11416897
"TH:AA" 1999 -.11794188
"TH:AA" 2000 .019639796
"TH:AA" 2001 .006626872
"TH:AA" 2002 .04131401
"TH:AA" 2003 .05050331
"TH:AAV" 1995 .
"TH:AAV" 1996 .
"TH:AAV" 1997 .
"TH:AAV" 1998 .
"TH:AAV" 1999 .
"TH:AAV" 2000 .
"TH:AAV" 2001 .
"TH:AAV" 2002 .
"TH:AAV" 2003 .
"TH:ABICO" 1995 .
"TH:ABICO" 1996 .
"TH:ABICO" 1997 .
"TH:ABICO" 1998 .
"TH:ABICO" 1999 .
"TH:ABICO" 2000 -.4316369
"TH:ABICO" 2001 .2456064
"TH:ABICO" 2002 -.13187617
"TH:ABICO" 2003 -.20122433
"TH:ACC" 1995 .
"TH:ACC" 1996 .
"TH:ACC" 1997 .07681426
"TH:ACC" 1998 .19004516
"TH:ACC" 1999 .2351474
"TH:ACC" 2000 .24723296
"TH:ACC" 2001 .3328163
"TH:ACC" 2002 .3133073
"TH:ACC" 2003 .17368893
"TH:ADVANC" 1995 .14890559
"TH:ADVANC" 1996 .16347024
"TH:ADVANC" 1997 .07141768
"TH:ADVANC" 1998 .07141935
"TH:ADVANC" 1999 .06898582
"TH:ADVANC" 2000 .11152533
"TH:ADVANC" 2001 .033920832
"TH:ADVANC" 2002 .09065522
"TH:ADVANC" 2003 .14829227
"TH:AFC" 1995 .016185127
"TH:AFC" 1996 -.032302696
"TH:AFC" 1997 -.09619764
"TH:AFC" 1998 -.14677796
"TH:AFC" 1999 -.06968713
"TH:AFC" 2000 .06990572
"TH:AFC" 2001 .027645
"TH:AFC" 2002 .04215815
"TH:AFC" 2003 .08594187
"TH:AGE" 1995 .
"TH:AGE" 1996 .
"TH:AGE" 1997 .
"TH:AGE" 1998 .
"TH:AGE" 1999 .
"TH:AGE" 2000 .
"TH:AGE" 2001 .
"TH:AGE" 2002 .
"TH:AGE" 2003 .
"TH:AH" 1995 .
"TH:AH" 1996 .
"TH:AH" 1997 .
"TH:AH" 1998 .
"TH:AH" 1999 .
"TH:AH" 2000 .04220357
"TH:AH" 2001 .032877684
"TH:AH" 2002 .12074438
"TH:AH" 2003 .07780618
"TH:AHC" 1995 .016732903
"TH:AHC" 1996 .04452096
"TH:AHC" 1997 -.04487522
"TH:AHC" 1998 .11150096
"TH:AHC" 1999 .05298609
"TH:AHC" 2000 .06468911
"TH:AHC" 2001 .11001626
"TH:AHC" 2002 .15875253
"TH:AHC" 2003 .15551433
"TH:AI" 1995 .
end
[CODE]
* Example generated by -dataex-. For more info, type help dataex
clear
input str9 Ticker int Year float Suspect_firms
"TH:2S" 1995 .
"TH:2S" 1996 .
"TH:2S" 1997 .
"TH:2S" 1998 .
"TH:2S" 1999 .
"TH:2S" 2000 .
"TH:2S" 2001 .
"TH:2S" 2002 .
"TH:2S" 2003 .
"TH:A" 1995 .
"TH:A" 1996 .
"TH:A" 1997 .
"TH:A" 1998 .
"TH:A" 1999 .
"TH:A" 2000 .
"TH:A" 2001 .
"TH:A" 2002 .
"TH:A" 2003 .025012556
"TH:AA" 1995 -.006353655
"TH:AA" 1996 -.0462963
"TH:AA" 1997 -.17009
"TH:AA" 1998 .11416897
"TH:AA" 1999 -.11794188
"TH:AA" 2000 .019639796
"TH:AA" 2001 .006626872
"TH:AA" 2002 .04131401
"TH:AA" 2003 .05050331
"TH:AAV" 1995 .
"TH:AAV" 1996 .
"TH:AAV" 1997 .
"TH:AAV" 1998 .
"TH:AAV" 1999 .
"TH:AAV" 2000 .
"TH:AAV" 2001 .
"TH:AAV" 2002 .
"TH:AAV" 2003 .
"TH:ABICO" 1995 .
"TH:ABICO" 1996 .
"TH:ABICO" 1997 .
"TH:ABICO" 1998 .
"TH:ABICO" 1999 .
"TH:ABICO" 2000 -.4316369
"TH:ABICO" 2001 .2456064
"TH:ABICO" 2002 -.13187617
"TH:ABICO" 2003 -.20122433
"TH:ACC" 1995 .
"TH:ACC" 1996 .
"TH:ACC" 1997 .07681426
"TH:ACC" 1998 .19004516
"TH:ACC" 1999 .2351474
"TH:ACC" 2000 .24723296
"TH:ACC" 2001 .3328163
"TH:ACC" 2002 .3133073
"TH:ACC" 2003 .17368893
"TH:ADVANC" 1995 .14890559
"TH:ADVANC" 1996 .16347024
"TH:ADVANC" 1997 .07141768
"TH:ADVANC" 1998 .07141935
"TH:ADVANC" 1999 .06898582
"TH:ADVANC" 2000 .11152533
"TH:ADVANC" 2001 .033920832
"TH:ADVANC" 2002 .09065522
"TH:ADVANC" 2003 .14829227
"TH:AFC" 1995 .016185127
"TH:AFC" 1996 -.032302696
"TH:AFC" 1997 -.09619764
"TH:AFC" 1998 -.14677796
"TH:AFC" 1999 -.06968713
"TH:AFC" 2000 .06990572
"TH:AFC" 2001 .027645
"TH:AFC" 2002 .04215815
"TH:AFC" 2003 .08594187
"TH:AGE" 1995 .
"TH:AGE" 1996 .
"TH:AGE" 1997 .
"TH:AGE" 1998 .
"TH:AGE" 1999 .
"TH:AGE" 2000 .
"TH:AGE" 2001 .
"TH:AGE" 2002 .
"TH:AGE" 2003 .
"TH:AH" 1995 .
"TH:AH" 1996 .
"TH:AH" 1997 .
"TH:AH" 1998 .
"TH:AH" 1999 .
"TH:AH" 2000 .04220357
"TH:AH" 2001 .032877684
"TH:AH" 2002 .12074438
"TH:AH" 2003 .07780618
"TH:AHC" 1995 .016732903
"TH:AHC" 1996 .04452096
"TH:AHC" 1997 -.04487522
"TH:AHC" 1998 .11150096
"TH:AHC" 1999 .05298609
"TH:AHC" 2000 .06468911
"TH:AHC" 2001 .11001626
"TH:AHC" 2002 .15875253
"TH:AHC" 2003 .15551433
"TH:AI" 1995 .
end

Comment