https://communities.sas.com/t5/SAS-Programming/Calculation-and-Joining-Tables/m-p/619290#M181781 <P>Hello,</P><P>&nbsp;</P><P>I am trying to prepare a data set that includes the population of students in my file Data.master_After2001:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="data.master_after2001.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/35560i19870AD6D2B3DF4E/image-size/large?v=v2&amp;px=999" role="button" title="data.master_after2001.PNG" alt="data.master_after2001.PNG" /></span></P><P>&nbsp;</P><P>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?</P><P>&nbsp;</P><P>Data set Data.grades:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Data.grades.PNG" style="width: 573px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/35561i0C2D24442190144F/image-size/large?v=v2&amp;px=999" role="button" title="Data.grades.PNG" alt="Data.grades.PNG" /></span></P><P>&nbsp;</P><P>Thanks!</P> Wed, 22 Jan 2020 19:41:39 GMT cneed 2020-01-22T19:41:39Z https://communities.sas.com/t5/SAS-Programming/Calculation-and-Joining-Tables/m-p/619290#M181781 <P>Hello,</P><P>&nbsp;</P><P>I am trying to prepare a data set that includes the population of students in my file Data.master_After2001:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="data.master_after2001.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/35560i19870AD6D2B3DF4E/image-size/large?v=v2&amp;px=999" role="button" title="data.master_after2001.PNG" alt="data.master_after2001.PNG" /></span></P><P>&nbsp;</P><P>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?</P><P>&nbsp;</P><P>Data set Data.grades:</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Data.grades.PNG" style="width: 573px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/35561i0C2D24442190144F/image-size/large?v=v2&amp;px=999" role="button" title="Data.grades.PNG" alt="Data.grades.PNG" /></span></P><P>&nbsp;</P><P>Thanks!</P> Wed, 22 Jan 2020 19:41:39 GMT https://communities.sas.com/t5/SAS-Programming/Calculation-and-Joining-Tables/m-p/619290#M181781 cneed 2020-01-22T19:41:39Z https://communities.sas.com/t5/SAS-Programming/Calculation-and-Joining-Tables/m-p/619292#M181782 <P>I answered your identical question here yesterday. Is there something wrong with that solution?</P> <P><A href="https://communities.sas.com/t5/SAS-Programming/Calculations/m-p/619021" target="_blank">https://communities.sas.com/t5/SAS-Programming/Calculations/m-p/619021</A></P> Wed, 22 Jan 2020 19:45:32 GMT https://communities.sas.com/t5/SAS-Programming/Calculation-and-Joining-Tables/m-p/619292#M181782 Reeza 2020-01-22T19:45:32Z