BookmarkSubscribeRSS Feed
weixxx
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 */

            DATALINES;

12 A 92 95

12 B 88 88

13 C 78 75

13 A 92 93

12 F 55 62

13 B 88 82

;

RUN;

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%.

5 REPLIES 5
Astounding
PROC Star

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.

weixxx
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.

Astounding
PROC Star

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?

weixxx
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?

Astounding
PROC Star

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.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1716 views
  • 0 likes
  • 2 in conversation