try proc sql using a cross join

Andreas De Troy wrote:

> Hi, > > I have the following problem: > > I have 2 datasets, > > -one with (unique) ID's, like: > "A5001" > "A5003" > "A5114" > ... > -and one with a variable number of types, like: > "type 1" > "type 2" > "type 3" > (could be two different types, could be one, could be three or four... this > is variable) > > Now I want to combine them, so that every ID is merged with all of the types > available. The resulting dataset should look like: > "A5001" "type 1" > "A5001" "type 2" > "A5001" "type 3" > "A5003" "type 1" > "A5003" "type 2" > "A5003" "type 3" > "A5114" "type 1" > etc. > > Is there any general way to do this, considering that the number of types is > not fixed? I think this is a simple problem, yet I cannot find a solution - > I don't see how a merge could be performed here. Anyone able to help? > > Thanks in advance, > > Andreas.