topic Delete a multiple values in a variable in SAS Programming

Delete a multiple values in a variable

cho16 — Wed, 12 May 2021 05:59:11 GMT

Hi,

I have multiple values on the column CODES and need to delete some of them which has 101,102,103,104,1110,

Prov Codes

101, 102,103,104,007
101, 102,103,104,1110 ,007,008
108,109,1110,1111

Want

Prov Codes

007
007,008
1111

Thanks in advance

Re: Delete a multiple values in a variable

japelin — Wed, 12 May 2021 06:23:09 GMT

How about this code?

BTW, you have removed 108,109,1110 from 108,109,1110,1111.

Isn't it correct that it should be 108,109,1111?

data want;
  set have;
  length char $200;
  cnt=countw(codes,',');
  char='';
  do i=1 to cnt ;
    x=scan(codes,i);
    if x not in ('101','102','103','104','1110') then char=catx(',',char,x);
  end;
  keep char;
run;

Re: Delete a multiple values in a variable

cho16 — Wed, 12 May 2021 06:34:31 GMT

Yes Kawakami , you are right !

The code works perfect.

btw, how to include all other columns in the below code ..got error when I tried it.

Re: Delete a multiple values in a variable

andreas_lds — Wed, 12 May 2021 06:40:03 GMT

Replace the keep statement with

drop cnt i codes;

Re: Delete a multiple values in a variable

japelin — Wed, 12 May 2021 06:51:09 GMT

@andreas_lds pointed out.
Just change the keep statement to a drop statement and specify the variable that was used temporarily.

Re: Delete a multiple values in a variable

andreas_lds — Wed, 12 May 2021 07:01:53 GMT

Alternative version, not fully tested:

data want2;
   set have;
   
   length reduced $ 100;
   
   codes = compress(codes);
   reduced = prxchange('s/(,?101)|(,?102)|(,?103)|(,?104)|(,?1110)//', -1, codes);
   reduced = substr(reduced, anydigit(reduced));
run;