Date:         Wed, 15 Jul 2009 12:07:34 -0400
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Re: proc sql and ARRAYS
Comments: To: Kathleen Askland <k.askland@GMAIL.COM>

A sample data and expected result would be more helpful.
My hunch is that you can transpose table 2 to vertical structure,
so that instead of 14 vars, you have two vars, one to carry the
original var name, the other to carry the original var's value.
This way, you can join table 1 x and new table 2 x (original var1-var14).

On Wed, 15 Jul 2009 11:50:11 -0400, Kathleen Askland <k.askland@GMAIL.COM>
wrote:

>Hello.
>Is there any way to invoke an array (or something akin to it) in PROC SQL?
>I'd like to do a two-table join where the value of variable X in table 1 is
>equal to the value of any of 14 variables, X1-X14, in table 2.
>Any suggestions would be greatly appreciated.
>Kathleen