Date:         Mon, 9 Jul 2001 07:13:38 -0700
Reply-To:     Christian Ribeaud <christian.ribeaud@PREDICT.CH>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Christian Ribeaud <christian.ribeaud@PREDICT.CH>
Organization: http://groups.google.com/
Subject:      proc sql join's question
Content-Type: text/plain; charset=ISO-8859-1

Hi,

How to get a inner join between metadata (column name) of one table
and column's value of another table? I should get something like that:

proc sql noprint;
   select dict.Variable !! ' ' !! dict.codeformat into :fmtname
separated by '#'
   from &dictionary as dict, &inLib..&inDs as set
   where "set's metadata (column's name)" = dict.Variable;
quit;

I would be very grateful if someone could help me. Thanks a lot and
have a nice day. Respects,

christian