/*Question 1*/ Hi, I dont need the SAS output what i need is the codes to come u
ID: 2908628 • Letter: #
Question
/*Question 1*/
Hi,
I dont need the SAS output what i need is the codes to come up with the solution and an explanation for the steps. your help will be appreciated.
/* The data file stdtgrd.dat is described as follows,
- the fields corresponding to 'S' are name (combining first and last names as one field) and id of a student;
- the fields corresponding to 'C' are course name and letter grade of the student from the preceding 'S' record.
Please create a SAS data set using ONE data step to report the number of courses each student took and the grade point average (GPA) of each student.
To calculate GPA, assign 4 to grade A, 3 to B, and 2 to C, and then simply calculate an arithmetic average.
The SAS data set to be created include four variables: name, id, count(i.e. number of courses), and gpa.
*/
Explanation / Answer
1
2
3
S
B C
First Name
Last Name GPA
Formula
Description (Result)
=A2&" "&B2" "&C
Combines the names above, separated by a space
=B3&", "&A3","&C
Combines the names above, separated by a comma
=CONCATENATE(A2," ",B2," ",C2,)
Combines the names above, separated by a space
1
2
3
S
B C
First Name
Last Name GPA
Formula
Description (Result)
=A2&" "&B2" "&C
Combines the names above, separated by a space
=B3&", "&A3","&C
Combines the names above, separated by a comma
=CONCATENATE(A2," ",B2," ",C2,)
Combines the names above, separated by a space
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.