Reference no: EM132074344

All I need is guidance on the steps i don't need the output just the steps then i will figure out the rest, your help will be appreciated. i have an issue with the last part of the question only not the entire question.

Please come up with a data step to read the the following data. Those columns are corresponding to, from left to right,

first name, last name, id, gender, grade of midterm exam 1, grade of midterm exam 2, grade of final exam, date of birth, and major.

- Please put the FULL name in one column in the new SAS data set;

- calculate the weighted average grade for each student: 30% allocated to midterm exam 1, 30% to midterm exam 2, and 40% to final exam;

- come up with new variable Scholarship whose value is 'First' if the weighted average is at least 90, 'Second' if it is less than 90 but at least 85, 'No' 

 if it is less than 85;

- calculate the age of students as of today. 

Steve Crowe 2342 M 75 82 85 01/28/98 Economics

Jennifer Lynch 2783 F 67 65 70 04/08/98 Mathematics

Christopher Malone 3218 M 89 93 90 08/23/97 Electronic Engineering

Matthew Baumier 3569 M 82 88 95 06/01/99 Music

Vivien Green 1498 F 77 85 83 11/05/98 History

Amy Swann 4136 F 82 82 87 10/27/97 Political Science