09-21-2016 05:10 PM
i'm trying to merge two databases that do not have a unique linking variable between the two of them.
My first database consists of IDs, with only one ID for each obersvation.
My second database consists of a procedure ID, percents and other information. How I'd like the final data set to look is something like:
Thanks for the help!
09-21-2016 06:49 PM - last edited on 09-21-2016 11:12 PM by PGStats
Known as a Cartesian Join and in SQL is a cross join.
create table want as
select a.name, b.age
from sashelp.class as a
cross join sashelp.class as b;