topic Re: Filter the underscores values using WHERE in SAS Programming

Filter the underscores values using WHERE

David_Billa — Thu, 21 Nov 2019 06:05:50 GMT

In the following list of values, I have to display the values in the Output only if the value has two underscores. I would like to tackle the condition using WHERE clause.

TBL

INS_CON_GRP

INS_GRT

INS

H_EAL_YE_A

INS_CON_GROUP

Desired Output is,

TBL

INS_CON_GRP

INS_CON_GROUP

Re: Filter the underscores values using WHERE

PeterClemmensen — Thu, 21 Nov 2019 06:08:59 GMT

Use the Countc Function like this

data have;
input TBL $20.;
datalines;
INS_CON_GRP
INS_GRT
INS
H_EAL_YE_A
INS_CON_GROUP
;

data want;
   set have;
   where countc(TBL, '_') = 2;
run;

Result:

TBL 
INS_CON_GRP 
INS_CON_GROUP