From: Aj on
I have a dataset with 3 columns with values

Variable Value1 Value2
AGE 2 7
PLACE 6 10
....
...
TERM 1 9


Another dataset with Column wherein the Column Name are same as the
values of "varibale " from the table above:

AGE PLACE TERM ......
1 10 9
2 6 32
8 09 20

Now I want to create a relation between the above two tables . how to
go about this?
From: Jan Selchau-Hansen on


"Aj" <ajeetsubramanian(a)gmail.com> skrev i meddelelsen
news:6ed9febb-0478-4a4c-964b-7cf7f568cd60(a)d37g2000yqm.googlegroups.com...
> I have a dataset with 3 columns with values
>
> Variable Value1 Value2
> AGE 2 7
> PLACE 6 10
> ...
> ..
> TERM 1 9
>
>
> Another dataset with Column wherein the Column Name are same as the
> values of "varibale " from the table above:
>
> AGE PLACE TERM ......
> 1 10 9
> 2 6 32
> 8 09 20
>
> Now I want to create a relation between the above two tables . how to
> go about this?

Proc Transpose is your friend !

Jan