topic Re: To select a few conditions in SAS Programming

To select a few conditions

nlpurumi — Fri, 29 Jun 2018 17:52:03 GMT

Hi.

I wonder how I can choose Phoneme_stress condition of 0 and 1 and drop 2, 3, 4, and 5.

Neither of below codes worked.

Could you please help me following codes?

data a1.prediss1;
set a1.prediss;
where Error=0 And [Phoneme_stress=0 or Phonem_stress=1];
run;

data a1.Prediss1;
set a1.Prediss;
if Phonem_stress in (2, 3, 4, 5) then delete;
where error=0;
run;

Thank you.

Re: To select a few conditions

Reeza — Fri, 29 Jun 2018 17:57:49 GMT

Either of these changes should work:

data a1.prediss1;
set a1.prediss;
where Error=0 And (Phoneme_stress in (0, 1));
run;


data a1.Prediss1;
set a1.Prediss;
if Phonem_stress in (2, 3, 4, 5)  and error ne 0 then delete;
run;

Re: To select a few conditions

nlpurumi — Fri, 29 Jun 2018 17:58:58 GMT

Thank you.

Re: To select a few conditions

Astounding — Fri, 29 Jun 2018 18:01:01 GMT

Your second program might be fine as is ... as long as you are spelling the variable name correctly. Is it Phoneme_stress, or is it Phonem_stress?

Also, you never explained ERROR and what that is about. So all we can do is assume you have used it correctly.

Re: To select a few conditions

nlpurumi — Fri, 29 Jun 2018 18:04:16 GMT

I wanted to included only error=0 values in all those conditions I wanted to include (phoneme_stress=0 or 1).

Does it change any of the codes I created or received from Reeza?

Re: To select a few conditions

Astounding — Fri, 29 Jun 2018 18:07:22 GMT

It doesn't change either of @Reeza's programs. You might want to select one or the other, based on how you want bad data to be handled. What should happen of Phoneme_stress is missing, or 8, for example?

Re: To select a few conditions

nlpurumi — Fri, 29 Jun 2018 18:14:12 GMT

After exploring a little bit, I found following two codes worked.

data a1.prediss1;
set a1.prediss;
where Error=0 And (Phoneme_stress in (0, 1));
run;

data a1.Prediss1;
set a1.Prediss;
where error=0;
if Phoneme_stress in (2, 3, 4, 5) then delete;
run;

I wanted to include only Error=0. Error is a dichotomous variable.