Please provide a solution and not guindance. I have some work and need a solution to cross reference. This MUST be done in SAS code

51. Information Technology Services (ITS) at Central State University has a computing service called the Grid, which is offered to faculty, staff, and students. This supercomputer is a cluster of 10 computers that, if programmed correctly in a grid environment, can process much faster by distributing the work across 10 machines. University users that would like to use the Grid computing environment must register with ITS. The raw data file CompUsers.dat contains the variables user ID, classification group (faculty, staff, or student), first name, last name, email address, campus phone number, and department.

a. Examine the raw data file CompUsers.dat and read it into SAS.

b. Print the data set.

c. Write another DATA step to read the raw data file and remove the student records. Do this as efficiently as possible by testing the classification group as it is being read in with the INPUT statement.

d. Print the data set.

Sample of the CompUsers.dat data

1 2 3 4 5 6 7 8 9 10 11 12 Faculty CHARLES PORTER email: charles.porter@csu.edu phone: 555-8511 AERO Faculty DONALD STEPHENS email: donald.stephens@csu.edu phone: 555-6884 CHEM Faculty CRYSTAL FLORES email:crystal.flores@csu.edu phone: 555-7053 AERO Faculty TERRY OWENS email:terry.owens@csu.edu phone: 555-5733 IME Faculty TRACY BARNES email:tracy.barnes@csu.edu phone: 555-8293 MATE Faculty MATTHEW WEST email:matthew.west@csu.edu phone: 555-5201 CHEM Faculty KEVIN PRICE email:kevin.price@csu.edu phone: 555-6347 CSC Faculty DANA RAMIREZ email: dana.ramirez@csu.edu phone: 555-1763 STAT Faculty CHARLES YOUNG email:charles.young@csu.edu phone: 555-7755 AERO Faculty TAMMY BENNETT email:tammy.bennett@csu.edu phone: 555-1267 CE Faculty JASON PERRY email:jason.perry@csu.edu phone: 555-1213 STAT Faculty PATRICIA BUTLER email: patricia.butler@csu.edu phone: 555-1452 CE Faculty NICOLE HALL email: nicole.hall@csu.edu phone: 555-1551 ME Faculty BENJAMIN WALLACE email:benjamin.wallace@csu.edu phone: 555-9094 BIOCHEM Faculty JOSEPH WALLACE email: joseph.wallace@csu.edu phone: 555-6256 CENG Faculty JUSTIN MORGAN email:justin.morgan@csu.edu phone: 555-5907 CIVIL Faculty JENNIFER LEWIS email: jennifer.lewis@csu.edu phone: 555-4440 CENG Faculty KAREN MASON email:karen.mason@csu.edu phone: 555-6605 AERO Faculty SHANE HUNT email:shane.hunt@csu.edu phone: 555-3147 MCRO Faculty KENNETH ADAMS email:kenneth.adams@csu.edu phone: 555-1961 CHEM Faculty AMANDA BROOKS email: amanda.brooks@csu.edu phone: 555-6806 CSC Faculty TARA CARROLL email:tara.carroll@csu.edu phone: 555-8963 BMED Faculty HOLLY ALEXANDER email:holly.alexander@csu.edu phone: 555-4260 BIO 13 14 15 16 17 18 19 20 21 22 23 243 244 245 246 247 248 249 250 251 252 253 254 Faculty DOUGLAS OWENS email: douglas.owens@csu.edu phone: 555-7389 MATE Faculty STACY WILLIAMS email:stacy.williams@csu.edu phone: 555-5001 IME Faculty JONATHAN FERGUSON email: jonathan.ferguson@csu.edu phone: 555-5910 CHEM Faculty SEAN HARRISON email:sean.harrison@csu.edu phone: 555-1977 STAT Faculty BENJAMIN TORRES email: benjamin.torres@csu.edu phone:555-6690 CHEM Faculty BRYAN GORDON email: bryan.gordon@csu.edu phone: 555-3990 MATH Faculty CHRISTINA DAVIS email: christina.davis@csu.edu phone: 555-440 ME Faculty MARIA ROBERTSON email:maria.robertson@csu.edu phone:555-3504 MATE Faculty KENNETH HOWARD email:kenneth.howard@csu.edu phone: 555-8849 ME Faculty RONALD COLE email:ronald.cole@csu.edu phone: 555-4267 MATE Faculty SHANNON BUTLER email:shannon.butler@csu.edu phone: 555-5997 AERO Student THOMAS PERKINS email: thomas.perkins@csu.edu phone: 555-6241 MATH Faculty SCOTT WALKER email:scott.walker@csu.edu phone: 555-6313 AERO Faculty JENNIFER SIMPSON email:jennifer.simpson@csu.edu phone: 555-9126 MATE Faculty JEFFREY SANCHEZ email:jeffrey.sanchez@csu.edu phone: 555-1857 EE Faculty DANIELLE GARDNER email:danielle.gardner@csu.edu phone: 555-3088 STAT Faculty MONICA BROOKS email:monica.brooks@csu.edu phone: 555-4443 ECON Faculty ANTHONY BELL email: anthony.bell@csu.edu phone: 555-5926 BIOCHEM Faculty DENISE MASON email:denise.mason@csu.edu phone: 555-9312 CENG Faculty WILLIAM MYERS email:william.myers@csu.edu phone: 555-2847 CIVIL Faculty ANDREW OLSON email:andrew.olson@csu.edu phone: 555-9211 BIO Faculty KENNETH COX email:kenneth.cox@csu.edu phone: 555-9834 BIO Faculty JENNIFER NICHOLS email:iennifer-nicholsorsu.edu phone-555-1436 CHEM 255 256 257 258 259 260 261 262 263 264 265 : 1 2 3 4 5 6 7 8 9 10 11 12 Faculty CHARLES PORTER email: charles.porter@csu.edu phone: 555-8511 AERO Faculty DONALD STEPHENS email: donald.stephens@csu.edu phone: 555-6884 CHEM Faculty CRYSTAL FLORES email:crystal.flores@csu.edu phone: 555-7053 AERO Faculty TERRY OWENS email:terry.owens@csu.edu phone: 555-5733 IME Faculty TRACY BARNES email:tracy.barnes@csu.edu phone: 555-8293 MATE Faculty MATTHEW WEST email:matthew.west@csu.edu phone: 555-5201 CHEM Faculty KEVIN PRICE email:kevin.price@csu.edu phone: 555-6347 CSC Faculty DANA RAMIREZ email: dana.ramirez@csu.edu phone: 555-1763 STAT Faculty CHARLES YOUNG email:charles.young@csu.edu phone: 555-7755 AERO Faculty TAMMY BENNETT email:tammy.bennett@csu.edu phone: 555-1267 CE Faculty JASON PERRY email:jason.perry@csu.edu phone: 555-1213 STAT Faculty PATRICIA BUTLER email: patricia.butler@csu.edu phone: 555-1452 CE Faculty NICOLE HALL email: nicole.hall@csu.edu phone: 555-1551 ME Faculty BENJAMIN WALLACE email:benjamin.wallace@csu.edu phone: 555-9094 BIOCHEM Faculty JOSEPH WALLACE email: joseph.wallace@csu.edu phone: 555-6256 CENG Faculty JUSTIN MORGAN email:justin.morgan@csu.edu phone: 555-5907 CIVIL Faculty JENNIFER LEWIS email: jennifer.lewis@csu.edu phone: 555-4440 CENG Faculty KAREN MASON email:karen.mason@csu.edu phone: 555-6605 AERO Faculty SHANE HUNT email:shane.hunt@csu.edu phone: 555-3147 MCRO Faculty KENNETH ADAMS email:kenneth.adams@csu.edu phone: 555-1961 CHEM Faculty AMANDA BROOKS email: amanda.brooks@csu.edu phone: 555-6806 CSC Faculty TARA CARROLL email:tara.carroll@csu.edu phone: 555-8963 BMED Faculty HOLLY ALEXANDER email:holly.alexander@csu.edu phone: 555-4260 BIO 13 14 15 16 17 18 19 20 21 22 23 243 244 245 246 247 248 249 250 251 252 253 254 Faculty DOUGLAS OWENS email: douglas.owens@csu.edu phone: 555-7389 MATE Faculty STACY WILLIAMS email:stacy.williams@csu.edu phone: 555-5001 IME Faculty JONATHAN FERGUSON email: jonathan.ferguson@csu.edu phone: 555-5910 CHEM Faculty SEAN HARRISON email:sean.harrison@csu.edu phone: 555-1977 STAT Faculty BENJAMIN TORRES email: benjamin.torres@csu.edu phone:555-6690 CHEM Faculty BRYAN GORDON email: bryan.gordon@csu.edu phone: 555-3990 MATH Faculty CHRISTINA DAVIS email: christina.davis@csu.edu phone: 555-440 ME Faculty MARIA ROBERTSON email:maria.robertson@csu.edu phone:555-3504 MATE Faculty KENNETH HOWARD email:kenneth.howard@csu.edu phone: 555-8849 ME Faculty RONALD COLE email:ronald.cole@csu.edu phone: 555-4267 MATE Faculty SHANNON BUTLER email:shannon.butler@csu.edu phone: 555-5997 AERO Student THOMAS PERKINS email: thomas.perkins@csu.edu phone: 555-6241 MATH Faculty SCOTT WALKER email:scott.walker@csu.edu phone: 555-6313 AERO Faculty JENNIFER SIMPSON email:jennifer.simpson@csu.edu phone: 555-9126 MATE Faculty JEFFREY SANCHEZ email:jeffrey.sanchez@csu.edu phone: 555-1857 EE Faculty DANIELLE GARDNER email:danielle.gardner@csu.edu phone: 555-3088 STAT Faculty MONICA BROOKS email:monica.brooks@csu.edu phone: 555-4443 ECON Faculty ANTHONY BELL email: anthony.bell@csu.edu phone: 555-5926 BIOCHEM Faculty DENISE MASON email:denise.mason@csu.edu phone: 555-9312 CENG Faculty WILLIAM MYERS email:william.myers@csu.edu phone: 555-2847 CIVIL Faculty ANDREW OLSON email:andrew.olson@csu.edu phone: 555-9211 BIO Faculty KENNETH COX email:kenneth.cox@csu.edu phone: 555-9834 BIO Faculty JENNIFER NICHOLS email:iennifer-nicholsorsu.edu phone-555-1436 CHEM 255 256 257 258 259 260 261 262 263 264 265