topic Re: Creating a new variable sum the percentage of total group in SAS Procedures

Creating a new variable sum the percentage of total group

weixxx — Tue, 02 Oct 2018 02:21:09 GMT

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

Re: Creating a new variable sum the percentage of total group

Astounding — Tue, 02 Oct 2018 02:56:43 GMT

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.

Re: Creating a new variable sum the percentage of total group

weixxx — Thu, 04 Oct 2018 03:48:45 GMT

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.

Re: Creating a new variable sum the percentage of total group

Astounding — Thu, 04 Oct 2018 13:00:23 GMT

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?

Re: Creating a new variable sum the percentage of total group

weixxx — Thu, 04 Oct 2018 14:19:02 GMT

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?

Re: Creating a new variable sum the percentage of total group

Astounding — Thu, 04 Oct 2018 14:32:07 GMT

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.