Find a string and number from a list stored in 2 macro variables

SIgnificatif — Thu, 06 Jun 2019 16:04:37 GMT

Hi all,

I'm looking to perform a search for a string and a number based on a template ( variations) this way :

%let quant=[quantity0,quantity1,quantity2,quantity3,quantity4,quantity5,quantity6,quantity7,quantity8];

%let fruits=[apples, pears];

%let fruit=[apple, pear];

%let variations=[red &fruits big &quant,red &fruits &quant, blue &fruit &quant, blue &fruits &quant ]; ( and so on... there are many variations, the most imp

data have;
mytext ="somedays I'll collect red apples quantity5 and blue pear quantity3 and will eat them " ;
run;

the output is extracting the quantity based on the template variations, in the case of data have:

RA = quantity5 ( for 'red apples quantity 5)

BP = quantity3 ( for 'blue pear quantity 3)

the standard search function is below, anyone knows how to perform a search with sas code ( not regex) with hprovided templates ?

if index(mytext,"red apples quantity 5")^=0 then RA=quantity5

Thanks.

Re: Find a string and number from a list stored in 2 macro variables

andreas_lds — Wed, 12 Jun 2019 06:16:25 GMT

Why do you exclude regex?

After a quick look at your problem, i can't see any better way to solve this, than by using regex.

topic Find a string and number from a list stored in 2 macro variables in SAS Programming

Find a string and number from a list stored in 2 macro variables

Re: Find a string and number from a list stored in 2 macro variables