No offense taken. Although I have programmed in many other languages, I am new to SAS. This is a typical clinial trial lab value program, but the number and names of tests varies per subject, as does the number of visits, so the data is not predicable. Tests B and GLUC have multiple values for the same visit - not sure why, but the program has to work with it. Sample Data (all for the same subject): TEST VALUE VISIT A 16 1.00 A 20 2.00 A 25 3.00 B 8 1.00 B NEGATIVE 1.00 B 7 2.00 B NEGATIVE 2.00 B 6 3.00 B NEGATIVE 3.00 C 6 1.00 C 5 2.00 C 4.5 3.00 Test2 0 1.00 Test2 4.6 3.00 Test5 1+ 3.00 GLUC 6 1.00 GLUC NEGATIVE 1.00 GLUC 4 2.00 GLUC NEGATIVE 2.00 GLUC 3.2 3.00 GLUC NEGATIVE 3.00 My desired result TEST VISIT 1 2 3 A 16 20 25 B 8 7 6 B Neg Neg Neg C 6 5 4.5 test2 0 Missing 4.6 GLUC 6 4 3.2 GLUC Neg Neg Neg test5 Missing Missing 1+
... View more