Hello, I need someone to help me with recoding my data. I have 4 variables (MAT, BIO, PHY, CHE). Each of the variable has students scores from 1 - 9, with 9 being the worst score. For example a student in my dataset has a score of 2 in MAT, 3 in BIO, 4 in PHY and 1 in CHE. What I want to do is create an aggregate variable from the four subjects using the three best grades. In this example, the three best scores are MAT (2), BIO (3) and CHE (1). Thus, the new variable, which will be called Aggregate Varaible will AGGREG_VAR = (2+3+1) = 6. So the score for this student for AGGREG_VAR = 6. PLEASE I NEED HELP IMPLEMENTING THIS IS SAS. THANK YOU. FRANCIS
... View more