| 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
| 
