Hi all, I have a question about merging datasets. I'll try to state my problem as clearly as possible. Dataset #1: Fund Target Permno Fund_A ABC 10101 Fund_B ABC 10101 Fund_C ABC 10101 Dataset #2 Target Permno Return Date ABC 10101 0.01 1 ABC 10101 0.02 2 ... ... ... ... ABC 10101 0.00 1000 If I do a simple merge by Permno, I only get the match for one Fund, while the other disappear. I would like to merge by Permno (only shared variable), but by having every fund treated as an independent observations in the merging: Desired merged dataset Fund Target Permno Return Date Fund_A ABC 10101 0.01 1 ... ... ... ... ... Fund_A ABC 10101 0.00 1000 Fund_B ABC 10101 0.01 1 ... ... ... ... ... Fund_B ABC 10101 0.00 1000 Fund_C ABC 10101 0.01 1 ... ... ... ... ... Fund_C ABC 10101 0.00 1000 Hopefully my explanations are clear. The answer may be easy but my limited vocabulary about SAS limits my "googling" abilities. Thank you,
... View more