[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: how to delete unncecessary data points
From:       "Data _null_;" <iebupdte () GMAIL ! COM>
Date:       2009-10-31 1:06:45
Message-ID: ce1fb7450910301806v146fa342u6de88c400eb31cc5 () mail ! gmail ! com
[Download RAW message or body]

data test;
   input Id:$1. code1-code3 xcode1-xcode3;
   array _n[*] _numeric_;
   do _n_ = 1 to dim(_n);
      if _n[_n_] not in(33 35 38 153 113) then _n[_n_]=.;
      end;
   cards;
1     33       35       38      126     153     167
2     24       33       27      113     126     265
3    38        52       66      341     153     124
4    35        64       77      155     266     113
5     33       54       86      153     158     113
;;;;
   run;
proc print;
   run;


On 10/30/09, Annie Lee <hummingbird10111@hotmail.com> wrote:
> What is the best way to select certain codes only.
> Only valid codes I would like to keep are 33 35 38   153  113.
> Thank you.
>
> Data:
> Id    code1  code2  code3      xcode1 xcode2 xcode3
> 1     33       35       38      126     153     167
> 2     24       33       27      113     126     265
> 3    38        52       66      341     153     124
> 4    35        64       77      155     266     113
> 5     33       54       86      153     158     113
>
> Results I would like:
>
> Id    code1  code2 code 3      xcode1 xcode2 xcode3
> 1     33       35      38               153
> 2              33                113
> 3     38                                153
> 4     35                                       113
> 5     33                         153            113
>
[prev in list] [next in list] [prev in thread] [next in thread]