topic Re: selecting certain observations using the where or if statement in SAS Procedures

selecting certain variables using the where or if statement

marleeakerson — Tue, 11 Feb 2020 20:09:52 GMT

Hello,

I am wondering if it is possible to use the where or if statements to select certain observations that have a lot of text in them. For instance consider the following example table:

Description Count

17-Hydroxypregnenolone (Hormone) Level 11

3d Radiographic Procedure 62

3d Radiographic Procedure With Computerized Image Postprocessing 31

Abdominal Removal Of Uterus Cervix And Lymph Nodes 28

Procedure for Abdominal Pain 57

And if I only wanted to keep the observations that contained "procedure" somewhere in the title, how would I do that?

Thank you.

Re: selecting certain variables using the where or if statement

PeterClemmensen — Tue, 11 Feb 2020 20:14:10 GMT

Like this?

data have;
input Description $ 1-66 Count;
datalines;
17-Hydroxypregnenolone (Hormone) Level                            11
3d Radiographic Procedure                                         62
3d Radiographic Procedure With Computerized Image Postprocessing  31
Abdominal Removal Of Uterus Cervix And Lymph Nodes                28
Procedure for Abdominal Pain                                      57
;

data want;
   set have;
   where find(Description, 'procedure', 'i');
run;

Re: selecting certain observations using the where or if statement

PaigeMiller — Tue, 11 Feb 2020 20:15:38 GMT

if find(description,'procedure','i')>0 then output;

Would you please be kind enough to help us out and fix the Subject line of your original post to say "observations" instead of "variables"?

Re: selecting certain variables using the where or if statement

ballardw — Tue, 11 Feb 2020 21:20:41 GMT

And for "Lots of text" if defined as "more than 30 characters":

data want2;
   set have;
   where length(Description) > 30;
run;