Make new file based on a Text string

[hhchenfx]

Hi,

I want to take all records from the below file out where name variable as a certain phrase like "abc1". 

In the file the new file will contain record 2 and 3 in the file below.

Thank you so much.

HHC

Data have;
input name $ 20.;
datalines;
cost_ab
value_abc1
textabc12_x
testabc
; run;

[nehalsanghvi · Accepted solution]

You can use 'contains' in a where statement:

data have2;

set have;

where name contains 'abc1';

run;

[Shmuel]

You can use either function contains, as proposed by @nehalsanghvi

or if index(name,'abc1') > 0

in case you are looking for digits in name you can use:

if indexc(name,'012345678') > 0

[hhchenfx]

Thanks a lot for your suggestions.
HHC