Hello! I am relatively new to SAS programming, and need help cleaning up a data set. Here is what my data looks like. PARTICIPANT 1 Var_1 Var_2 Var_3 Var_4 Visit 1 32423.2 23432.4 8345.3 10203.76 Visit 2 23498.9 86872.3 23443.5 872491.2 Visit 3 . . . . PARTICIPANT 2 Visit 1 32423.2 23432.4 8345.3 10203.76 Visit 2 23498.9 86872.3 23443.5 872491.2 Visit 3 34232.3 23423.1 32432.9 234343.4 PARTICIPANT 3 Visit 1 32423.2 23432.4 8345.3 10203.76 Visit 2 23498.9 86872.3 23443.5 872491.2 Visit 3 . . . . PARTICIPANT 4 Visit 1 32423.2 23432.4 8345.3 10203.76 Visit 2 23498.9 86872.3 23443.5 872491.2 Visit 3 . . . . If a participant returned for visit 3, it means that something was wrong with their numbers for visit 2 and we needed to retest. How do I get SAS to drop all of the values for var1-var4 associated with visit 2 and replace them with the values for visit 3? I have many more variables but used var1-var4 to illustrate my point. Data is grouped by the study visits. Any help would be very appreciated. Thank you!
... View more