I have two SAS data sets A and B. Data set A has about 20000 rows and data set B has about 30000 rows. I want to process each row in data set A against all rows in data set B. I know this can be done using Merge statement but the cartesian product results in 600 million rows in the final data set. This is blowing up my memory. Is there any way of doing this in a single data step without using the merge statement. I pretty sure there is one, but couldn't remember what I did several years ago.
... View more