Announcement

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

  • Filtering in Stata

    I have been trying to look for Stata equivalent of this SPSS filter creation
    " USE ALL.
    COMPUTE filter_$=(PT = 0 & impval > 0 & PRICE >= 10000 & VI = "I" & AYB < 2020 & AR="A" &
    ANY(IMP,1,3,4,5,8,9,50,51) & XDATE.YEAR(SALEDT)=2019 & INSTR = "WD").
    VARIABLE LABELS filter_$ 'PT = 0 & impval > 0 & PRICE >= 10000 & VI = "I" & AYB < 2020 & AR="A" '+
    '& ANY(IMP,1,3,4,5,8,9,50,51) & XDATE.YEAR(SALEDT)=2019 & INSTR = "WD" (FILTER)'.
    VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
    FORMATS filter_$ (f1.0).
    FILTER BY filter_$.
    EXECUTE." Any help would be appreciated

  • #2
    You can easily generate a binary flag var like this to select only some cases:

    Code:
    gen use = 0
    replace use = 1 if age < 50 & health == 1 & sex == 2 & inrange(income, 2000, 3000)
    tab use
    regress y x if use == 1
    Best wishes

    (Stata 16.1 MP)

    Comment

    Working...
    X