Hi I'm trying to merge two datasets together, one contains a unique key (person number) and 3 referencial fields labelled 1 to 3, this has been transposed from a previous proc contents. I need to match / merge the data from this one to another one (also has person number), and also has the true variable values for the referenced fields in the other datasets. I'm not sure how to do this at all, I've looked at vvaluex, but the data can be of varying formats and it threw up an error. Person number reference one reference 2 1 date of birth employment 2 school attended sex 3 sex date of birth Person number Sex Date of Birth School Attended Employment 1 F 01/01/2001 st johns none 2 M 01/01/1990 box street army 3 F 01/01/1970 young school retired I need to return the below Person Number Reference One Reference 2 1 01/01/2001 none 2 box street M 3 F 01/01/1970 Using sas 9.1 Thanks for help in advance
... View more