BookmarkSubscribeRSS Feed
Calcite | Level 5

Hello guys! I just start teaching myself to use SAS and sinceI have very little experience with programming languages. I would be very appreciative of any help with this problem! like how to set the variable with percentage of total observations.


DATA school;

            INPUT age quiz : $1. midterm final;

            /* Add your code here */


12 A 92 95

12 B 88 88

13 C 78 75

13 A 92 93

12 F 55 62

13 B 88 82



The quiz grades have numerical equivalents as follows: A = 95, B = 85, C = 75, D = 70, and F = 65. Using this information, compute a new variable called course that represents the final grade for each student.  The final grade is a weighted average of all grades where quiz grades are worth 30%, midterm grades are worth 30%, and final grades are worth 40%.


Here's a nudge in the right direction.


Add as many statements as you need, not just one.  (Some posters may show you how to do this in one statement, but that's not the right way to learn until you have more experience.)


Start by creating a new variable, holding the numeric equivalent of the letter grade.  Then calculate the final grade using three numeric variables in your formula.


Show what you have tried, if you need a further nudge.

Calcite | Level 5

Thanks for that! But i totally have no idea about how to set up those quiz and midterm with percentages. I know the sum statement tho.


You haven't shown what you tried already.  Where is your code that creates a numeric variable based on the letter grade?  Have you tested it and found it to be working?

Calcite | Level 5

A=95 B=85 C=75 D=70 F=65;
Finalgrades= 0.3*quiz+0.3*midterm+0.3*final;

Am i in the right track?


You are further along than before.  But you need working code, and you need to be able to test that code. At this point, I see no evidence of any code that you could actually test.


Start by creating a new variable named QUIZ_NUMERIC that takes on numeric values instead of "A", "B", "C", "D" and "F".  Whatever statements you use to do that, make them part of a DATA step that you can then run and see whether the results are coming out correctly.



Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.


Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 


Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2 in conversation