Hello, I have a doubt in the number of observations .
question : create a temporary data set, cleandata36. In this data set, convert all group values to upper case. Then keep only observations with group equal to 'A' or 'B'.
when I run below code
data cleandata36; set cert.input36 ; if upcase(group) in ('A','B'); run;
then number of observations are different
but when I run
data cleandata36; set cert.input36 ; group=upcase(group);
where group in ('A','B'); run;
the number of observations are different.
but the logic I want to implement is maybe same. Can please anyone tell me that why there is mismatch of observations 🙂
... View more