topic Re: Make new file based on a Text string in SAS Programming

Make new file based on a Text string

hhchenfx — Thu, 16 Feb 2017 20:29:23 GMT

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 — Thu, 16 Feb 2017 20:46:30 GMT

You can use 'contains' in a where statement:

data have2;

set have;

where name contains 'abc1';

run;

Shmuel — Thu, 16 Feb 2017 20:57:10 GMT

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 — Thu, 16 Feb 2017 22:02:41 GMT

Thanks a lot for your suggestions.
HHC