Calculation and Joining Tables

[cneed]

Hello,

I am trying to prepare a data set that includes the population of students in my file Data.master_After2001:

I am looking to calculate each students GPA. GPA is calculated as the sum of grades/number of courses and grades can be summed by assigning A=4, B=3, C=2, D=1, and F=0. Each student can have more then one grade. How can I calculate the GPA for each student then join it into the table above?

Data set Data.grades:

Thanks!

[Reeza]

I answered your identical question here yesterday. Is there something wrong with that solution?

https://communities.sas.com/t5/SAS-Programming/Calculations/m-p/619021