topic Extracting text with scan function in SAS Data Management

Extracting text with scan function

mlogan — Wed, 07 Aug 2019 20:00:33 GMT

Hi there,

I am trying to extract 'brown_fox' from the whole observation 'A_quick_brown_fox_01' with scan function. Can someone please help. The whole idea is to extract 3rd and 4th word separated by underscores.

Thanks,

Re: Extracting text with scan function

PaigeMiller — Wed, 07 Aug 2019 20:16:30 GMT

@mlogan wrote:

Hi there,

I am trying to extract 'brown_fox' from the whole observation 'A_quick_brown_fox_01' with scan function. Can someone please help. The whole idea is to extract 3rd and 4th word separated by underscores.

data abc;
string='A_quick_brown_fox_01_etc_etc_etc';
third=scan(string,3,'_');
fourth=scan(string,4,'_');
want = cats(third,'_',fourth);
run;

Re: Extracting text with scan function

novinosrin — Wed, 07 Aug 2019 20:17:21 GMT

data want;
str='A_quick_brown_fox_01' ;
length want $30;
do _i=3,4;
want=catx('_',want,scan(str,_i,'_'));
end;
drop _:;
run;