topic Re: Keep Observations with either criteria in SAS Procedures

Keep Observations with either criteria

Benn — Sun, 25 Nov 2012 06:12:57 GMT

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.

Re: Keep Observations with either criteria

Linlin — Sun, 25 Nov 2012 13:03:48 GMT

changing

IF R_RET=0 or 9;

IF R_RET in (0 ,9);

Re: Keep Observations with either criteria

Ksharp — Mon, 26 Nov 2012 05:34:36 GMT

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