Exclude outliers from base: nullif{comparisons}

0     5     Edited Sep 15, 2016 by robsmith

Our existing function nullifeq can be used to exclude single values from the base, For example nullifeq(Q1,99) excludes 99 from the base. But we need functions to exclude ranges from the base, e.g.:

nullifgt(nbchildren, 10) -- exclude records where nbchildren > 10
nullifgte(nbchildren, 10) -- exclude records where nbchildren >= 10
nulliflt(income, 3) -- exclude records where income < 3
nulliflt(income, 3) -- exclude records where income <= 3
nullifwithin(fred, 10, 20) -- exclude records where 10 <= fred <= 20

Comments

0

robsmith Dec 4, 2017

test

0

asdf โ€“ robsmith 12/4/2017 5:24:01 PM

0

Anonymous Dec 4, 2017

test

0

fdsa โ€“ robsmith 12/4/2017 5:24:05 PM

0

qwert โ€“ Anonymous 12/4/2017 5:25:45 PM

Leave a Comment

Please sign in to leave a comment.