Hey SAS, I have 3 variable; Id = which is character has leading zeros ie: 0005 Name = character Reports_to = character has leading zeros ie: 0008 My sas dataset looks like this: Id Name Reports_to_id Reports_to_name 000006 Smith, John 000007 Phil, Elias 000007 Phil, Elias 000010 Santa, Clause 000008 Turner, Sandra 200000 Andrew, Skype 000010 Santa, Clause 200000 Andrew, Skype 200000 Andrew, Skype 000006 Smith, John 520001 Walker, Walker 000006 Smith, John 000006 In excel, I use a Vlookp to populate Reports_To_Name; it bassically shows the persons supervisor that he/she reports to bassed ont he reports_to_id; how would I go about doing that in SAS.....Any suggestions.. Thanks,
... View more