Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Forming Dummy Variable if Value of a Variable is in a Range

    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

  • #2
    Code:
    gen wanted = inrange(Suspect,0,0.005)

    Comment


    • #3
      Ali Atia Worked perfectly, thank you so much for your help

      Comment

      Working...
      X