Hello Everyone, I am really stuck on this homework problem about merges. So I have three data sets, these are all the partial listings of these data sets: orion.organization_dim: Partial orion.Organization_Dim Manager_ Manager_ Manager_ Manager_ Manager_ Manager_ ObsEmployee_ID Level1 Level2 Level3 Level4 Level5 Level6 1 120101 120261 120259 . . . . 2 120102 120101 120261 120259 . . . 3 120103 120101 120261 120259 . . . 4 120104 120101 120261 120259 . . . 5 120105 120101 120261 120259 . . orion.employee_addresses: Partial orion.employee_addresses Employee_ Obs ID Employee_Name 1 121044 Abbott, Ray 2 120145 Aisbitt, Sandy 3 120761 Akinfolarin, Tameaka 4 120656 Amos, Salley 5 121107 Anger, Rose So what I am supposed to do is to merge these together to get manager names for each level of manager to output it to a new data set manager_names. Example: Partial manager_names Data Manager_ Manager_ Manager_ Manager_ Manager_ Manager_ Obs Employee_ID Level1 Level2 Level3 Level4 Level5 Level6 Manager1_Name 420 121144 121142 121141 120261 120259 . . Steiber, Reginald 421 121145 121142 121141 120261 120259 . . Steiber, Reginald 422 121146 121141 120261 120259 . . . Bleu, Henri Le 423 121147 121142 121141 120261 120259 . . Steiber, Reginald 424 121148 121141 120261 120259 . . . Bleu, Henri Le Manager5_ Manager6_ Obs Manager2_Name Manager3_Name Manager4_Name Name Name 420 Bleu, Henri Le Highpoint, Harry Miller, Anthony 421 Bleu, Henri Le Highpoint, Harry Miller, Anthony 422 Highpoint, Harry Miller, Anthony 423 Bleu, Henri Le Highpoint, Harry Miller, Anthony 424 Highpoint, Harry Miller, Anthony Right now, I am completely clueless as to how to begin this. This is my code so far: proc sort data=orion.organization_dim out=organization_dim; by Employee_ID; run; data tempt(keep=Manager_Level1 Manager_Level2 Manager_Level3 Manager_Level4 Manager_Level5 Manager_Level6); set organization_dim; set orion.employee_addresses; run; proc sort data=tempt out=mngr1; by Manager_Level1; run; data manager1; set mngr1; set orion.employee_addresses (rename=(Employee_Name=Manager1_Name)); run; I am just playing around right now, but if anyone could give me any pointers as to how I could gather this information it would be greatly appreciated. Thanks, Alisa
... View more