data lab_valid (where=(troponin=1 & result_conv ne .& year>=2011));
set clean.lab_troponin
Specifically, I'm not sure what the "ne .&" means?
Thank you!
Hi:
That WHERE option is a test for 3 things to be true in order for the observation to be selected. So separate out the & first, and replace it with the logical AND, then the option becomes:
where=( troponin=1 AND result_conv ne . AND year >= 2011)
So, an observation will only be selected if these 3 conditions are all true:
the variable TROPONIN must have a value equal to 1
the variable RESULT_CONV must have a value NOT equal to . (. means a MISSING value for a numeric variable)
the variable YEAR must have a value that is greated than or equal to 2011
With a SAS numeric variable a . is used to represent a missing value. For a character variable a space or blank is used to represent a missing value.
Hope this helps,
Cynthia
The period is the most common type of missing value. Quite independently, ampersand means AND. The code would be clearer if there were a space between the two.
Hi:
That WHERE option is a test for 3 things to be true in order for the observation to be selected. So separate out the & first, and replace it with the logical AND, then the option becomes:
where=( troponin=1 AND result_conv ne . AND year >= 2011)
So, an observation will only be selected if these 3 conditions are all true:
the variable TROPONIN must have a value equal to 1
the variable RESULT_CONV must have a value NOT equal to . (. means a MISSING value for a numeric variable)
the variable YEAR must have a value that is greated than or equal to 2011
With a SAS numeric variable a . is used to represent a missing value. For a character variable a space or blank is used to represent a missing value.
Hope this helps,
Cynthia
Thank you so much!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.