Hi, I would like calculate a total sum for each student based on the program they are on by adding values from a second dataset. Here is the example: invoice.sas7bdat: Student Program Dave Plan1 Kate Plan2 Mary Plan3 Emma Plan4 Noah Plan5 James Plan6 (there are many students, have not listed them all) Contract.sas7bdat: Item Cost $ Bussing 100 Meals 150 Books 200 Clothes 250 Tutoring 300 Insurance 350 (there are 21 items, have not listed them all) I would like to program: If a student is on Plan1, then the TotalSum=Bussing+Tutoring If a student is on Plan2, then the TotalSum=Clothes+Books+Meals If a studen is on Plan3, then the TotalSum=Insurance etc...... I would like to create this output: Student TotalSum Dave $400 Kate $600 Mary $350 etc...for all students I hope this clear, if not please let me know.
... View more