Date:         Fri, 30 Mar 2012 21:01:13 +0000
Reply-To:     "Keintz, H. Mark" <mkeintz@WHARTON.UPENN.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Keintz, H. Mark" <mkeintz@WHARTON.UPENN.EDU>
Subject:      Re: Extracting a word that matches a patter in a macro var XXXX
Comments: To: Dan Abner <dan.abner99@gmail.com>
In-Reply-To:  <CAPRGo-mPt6_zn2pS-XvPQ4QjOx2wR-C6Hxqmdweiu1QyErjc7Q@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"

Dan:

Are you looking for the specific text E_N_OPERC*E_O_BILLGR?  If so, use the %INDEX function which will return the location in which the text is found, or a zero if not found, as in:

%let inter1=aaaaaaa bbbbbbbbbb ccccccccc E_N_OPERC*E_O_BILLGR ddddddddd eeeeeee;
%let inter2=aaaaaaa bbbbbbbbbb ccccccccc ddddddddd eeeeeee;

%let ix1=%index(&inter1,E_N_OPERC*E_O_BILLGR);
%let ix2=%index(&inter2,E_N_OPERC*E_O_BILLGR);

%put IX1=&ix1 IX2=&ix2;

If you want something more general, then give us something more to work with.

Regards,
Mark


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Dan Abner
Sent: Friday, March 30, 2012 4:47 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Extracting a word that matches a patter in a macro var XXXX

Hi everyone,

I have a macro var (&INTER) that resolves to a space delimited string of 1500 words. What is the best way to select any and all words that contain the following pattern:

E_N_OPERC*E_O_BILLGR


Thanks!

Dan