Help using Base SAS procedures

Keep Observations with either criteria

Reply
Contributor
Posts: 35

Keep Observations with either criteria

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.

Super Contributor
Posts: 1,636

Re: Keep Observations with either criteria

changing

IF R_RET=0 or 9;

to

IF R_RET in (0 ,9);

Super User
Posts: 10,035

Re: Keep Observations with either criteria

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

Ask a Question
Discussion stats
  • 2 replies
  • 176 views
  • 0 likes
  • 3 in conversation