Consider the University.txt file used in Homework 5. Recall that the included variables are:

School: The name of the college or university.

State: The state (abbreviation) in which the school is located.

Location: The city in which the school is located.

Grad Rate: The percentage of students that enter the school that graduate. Note that the % sign is used in the file.

Cost: The average annual cost, including tuition, fees, books, room and board, and other related costs, minus any grants or scholarships, for a student at the school.

Acceptance: The schools acceptance rate. Note that the % sign is used in the file.

Undergrad: The number of undergraduate students attending the school.

1

Load this file into SAS and store it as a data frame. Make sure Grad Rate, Cost, Acceptance, and Undergrad are all stored as numeric data. In addition, do each of the following:

Create a variable called Selective. Selective should be assigned a value of Yes if the acceptance rate is less than or equal to 25%. It should be assigned a value of No if the acceptance rate exceeds 25%.

Create a variable called Expenses. Expenses should be assigned a value of Low if the average annual cost is less than $15,000, a value of Medium if the average annual cost is between $15,000 and $30,000, and a value of High if the average annual cost is higher than $30,000.

Print the School, Cost, Acceptance, Selective, and Expenses variables of the resulting data set. Report your output. University.txt School State Location Grad Rate Cost Acceptance Undergrad Harvard University MA Cambridge 98% $15,561 5% 7582 Duke University NC Durham 96% $23,442 9% 6596 University of Notre Dame IN Notre Dame 96% $32,096 18% 8568 Williams College MA Williamstown 96% $21,239 13% 2028 Colby College ME Waterville 92% $18,553 13% 2000 Rice University TX Houston 93% $20,879 11% 3962 Smith College MA Northampton 88% $28,193 31% 2496 Lehigh University PA Bethlehem 89% $30,832 22% 5030 Brigham Young University-Provo UT Provo 87% $13,181 64% 31441 Mount Holyoke College MA South Hadley 84% $25,937 51% 2190 University of Georgia GA Athens 84% $13,971 49% 29474 George Washington University DC Washington 84% $33,734 42% 12161 Muhlenberg College PA Allentown 83% $30,684 62% 2285 Binghamton University NY Vestal 82% $18,958 40% 13990 University of Miami FL Coral Gables 81% $30,841 32% 10873 Michigan State University MI East Lansing 80% $18,984 78% 39208 Marquette University WI Milwaukee 79% $29,693 82% 8200 University of Delaware DE Newark 79% $16,127 66% 19060 Indiana University-Bloomington IN Bloomington 78% $13,428 77% 32991 Luther College IA Decorah 77% $23,792 63% 1974 San Diego State University CA San Diego 76% $15,287 35% 30018 Ohio Northern University OH Ada 74% $22,854 64% 2144 Saint John Fisher College NY Rochester 74% $27,299 68% 2728 SUNY Oneonta NY Oneonta 72% $16,853 51% 6021 University of Central Florida FL Orlando 71% $12,733 43% 58392 Pennsylvania State University-Penn State Harrisburg PA Middletown 71% $23,152 88% 4162 Sonoma State University CA Rohnert Park 69% $16,801 90% 8642 Albion College MI Albion 69% $15,413 68% 1512 Colorado State University-Fort Collins CO Fort Collins 68% $19,800 84% 24210 Marlboro College VA Marlboro 64% $17,497 59% 140 Florida International University FL Miami 64% $8,311 59% 41777 Winona State University MN Winona 63% $17,399 66% 7052 Kansas State University KS Manhattan 60% $18,450 93% 17611 University of Wyoming WY Laramie 59% $13,379 96% 9854 LeTourneau University TX Longview 57% $22,105 46% 1771 University of Nevada-Las Vegas NV Las Vegas 52% $10,551 82% 24707 CUNY Hunter College NY New York 53% $2,796 36% 16205 Montana Technological University MT Butte 48% $13,886 92% 1585 Sterling College KS Sterling 46% $19,940 41% 568 Eastern Kentucky University KY Richmond 46% $13,845 87% 12246 Jackson State University MS Jackson 45% $13,492 69% 5305 University of Central Oklahoma OK Edmond 42% $16,572 78% 13118 Dakota State University SD Madison 41% $17,244 83% 2051 burdue University Fort Wayne IN Fort Wayne 29% $11,404 97% 7270 George Mason University VA Fairfax 73% $20,321 81% 25508 Lafayette College PA Easton 89% $29,884 29% 2616 University of Mary Washington VA Fredericksburg 71% $21,483 72% 4371 Stanford University CA Stanford 96% $12,265 4% 7083 University of New Mexico-Main Campus NM Albuquerque 51% $14,329 70% 17321 Occidental College CA Los Angeles 85% $31,842 37% 1910