Keep Observations with either criteria

[Benn]

Hey Guys,

I am trying to keep certain observations that satisfy either one of the criteria : Belonging to Group 0 or Belonging to Group 9. However my code does not seem to work.

DATA BW_RAW_RET_LONG_SHORT;

SET BW_RAW_RET;

IF R_RET=0 or 9;

RUN;

I am not sure what is wrong.

Thanks for the help.

[Linlin]

changing

IF R_RET=0 or 9;

to

IF R_RET in (0 ,9);

[Ksharp]

IF R_RET=0 or 9;

9 is always true in SAS(actually any number except zero or missing value is true ), therefore your condition will always be true ,which means you will copy a dataset from another dataset.

Make condition be yourself:

IF R_RET=0 or R_RET=9;

IF R_RET in (0 9);

Ksharp