Date:         Wed, 16 Feb 2000 21:36:49 GMT
Reply-To:     lars.ladfors@TELIA.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         lars.ladfors@TELIA.COM
Organization: Telia Internet
Subject:      WILDCARD AGAIN
Content-Type: text/plain; charset=us-ascii

Subject:
             WILDCARDS, AGAIN
        Date:
             Wed, 16 Feb 2000 21:34:55 GMT
       From:
             lars.ladfors@telia.com
 Organization:
             Telia Internet
 Newsgroups:
             comp.soft-sys




Thanks for Your help, if You have time to help me!

I tried this script, it did not work:
I am looking for the text 767G, P140, P141, P142, P143 ANYWHERE IN
VARIABLE BDIAG1-BDIAG7

SCRIPT:
data TEST;
SET TEST;
IF(
BDIAG1 = '%767G%' OR
BDIAG2 = '%767G%' OR
BDIAG3 = '%767G%' OR
BDIAG4 = '%767G%' OR
BDIAG5 = '%767G%' OR
BDIAG6 = '%767G%' OR
BDIAG7 = '%767G%' OR


BDIAG1 = '%P140%' OR
BDIAG2 = '%P140%' OR
BDIAG3 = '%P140%' OR
BDIAG4 = '%P140%' OR
BDIAG5 = '%P140%' OR
BDIAG6 = '%P140%' OR
BDIAG7 = '%P140%' OR


BDIAG1 = '%P141%' OR
BDIAG2 = '%P141%' OR
BDIAG3 = '%P141%' OR
BDIAG4 = '%P141%' OR
BDIAG5 = '%P141%' OR
BDIAG6 = '%P141%' OR
BDIAG7 = '%P141%' OR


BDIAG1 = '%P142%' OR
BDIAG2 = '%P142%' OR
BDIAG3 = '%P142%' OR
BDIAG4 = '%P142%' OR
BDIAG5 = '%P142%' OR
BDIAG6 = '%P142%' OR
BDIAG7 = '%P142%' OR


BDIAG1 = '%P143%' OR
BDIAG2 = '%P143%' OR
BDIAG3 = '%P143%' OR
BDIAG4 = '%P143%' OR
BDIAG5 = '%P143%' OR
BDIAG6 = '%P143%' OR
BDIAG7 = '%P143%')
THEN   plexus=1;
run;




DATA:

DATA TEST;
INPUT BDIAG1 $ 1-6  BDIAG2 $ 7-11   BDIAG3 $ 12-17  BDIAG4 $ 20-25
BDIAG5 $ 30-35 BDIAG6 $ 39-45 BDIAG7 $ 46-52;
DATALINES;

V39A  767G
V39A
V39A
V39A  767GH
V39A
V39A
V39A
V39A
V39A
V39A
V39A  P143
V39A
V39A  P141
Y39V
77700
V30
V30
V30
7215  767GG
775A
V30
V30
770G  P140
764B
V30
752F  764B  764E     P142
V30   P143                      P140    P123    P232
768G  776F

V30
V30
V30
V30
V30

          ;
RUN;