From: William Krause on
--- On Mon, 12/28/09, William Krause <wkrause2003(a)YAHOO.COM> wrote:


From: William Krause <wkrause2003(a)YAHOO.COM>
Subject: extracting numbers from a string
To: SAS-L(a)LISTSERV.UGA.EDU
Cc: "William Krause" <wkrause2003(a)YAHOO.COM>
Date: Monday, December 28, 2009, 1:45 PM


I have a metadata table (tab1)that contains a field(infmt) which is the
informat of a another field(response).=A0 The response field contains the
response number and its assigned description.

tab1
question=A0=A0=A0infmt response
question1=A0 1.=A0 =A0 1=3D"test1"2=3D"test2"3=3D"test3"
question2=A0 2.=A0 =A0 1=3D"test1"2=3D"test2"3=3D"test3"11=3D"test11"13=3D"=
test13"
question3=A0 2.=A0 =A0 1=3D"test1"2=3D"test2"3=3D"test3"11=3D"test11"13=3D"=
test13"

Then I have a second table (tab2) which contains the actual response values
in a field (resp_results)

tab2
question=A0=A0=A0resp_results
question1=A0=A0=A01
question2=A0=A0=A013
question3=A0=A0=A05

How do I insure that the resp_results in tab2 matches the informat of the
infmt field and matches a valid response number from the response field in
tab1?

Thanks for you assistance.

Bill K.
wkrause2003(a)yahoo.com
=0A=0A=0A