I am trying to create a table with all the possible intersections of 4 tables in the same table with for example a colum that indicates the reference tables. A with B A with C ... A with B with C with D I can easily achive this but i dont want to create 15 tables and append in the end i would prefere to do this with a macro. Is it possible? Thanks for the help i will leave the proc sql that i use to create one of the intersects. proc sql; create table A as select A.*,CAT(A.ID,' ',B.ID)AS MASTER_ID from work1 as A inner join work2 as B on ... run;
... View more
