identifying a record which has 2 or more words

r3570 — Thu, 28 Oct 2021 06:08:14 GMT

Dear All,

I have below dataset where few records in TERM column have more than 1 word. I need to identify such records and flag them

ID TERM

101 VOMITING

101 HEADACHE and NAUSEA

102 FATIGUE

102 PYREXIA/COLD

My output should be as below:

ID TERM FLAG

101 VOMITING

101 HEADACHE and NAUSEA Y

102 FATIGUE

102 PYREXIA/COLD Y

Please help.

Re: identifying a record which has 2 or more words

PeterClemmensen — Thu, 28 Oct 2021 06:17:24 GMT

Try this

data have;
input ID TERM $ 5 - 25; 
datalines;
101 VOMITING
101 HEADACHE and NAUSEA
102 FATIGUE
102 PYREXIA/COLD
;

data want;
   set have;
   flag = ifc(countw(term, ' /') > 1, 'Y', '');
run;

topic identifying a record which has 2 or more words in SAS Programming

identifying a record which has 2 or more words

Re: identifying a record which has 2 or more words