• 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 school's acceptance rate. Note that the % sign is used in the le.
• 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:

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

2) Make 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.

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

Purdue 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