*Begin by querying the IPEDS Data Center and downloading the short length variable names*; /*Fall Enrollment:*/ /*Undergraduate: Grand Total enrollment, men, women*/ /*Race/Ethnicity:*/ /*UG - American Indian/Alaskan Native total, Asian total, Black/African American total, Hispanic total, Native Hawaiian/Pacific Islander total,*/ /*White total, Two or more races total, Non-Resident Alien (International) total*/ *1. Import the downloaded IPEDS data using the code below using the import code below*; /*You will need to change the name of your file location*/ proc import datafile='C:\Users\USERID\Downloads\Data_Date.csv' dbms=csv out=work.import replace; run; /*The global let statement is one of the best features of SAS. You merely have to change the variable appropriate year instead of re-writing all of the code*/ %let year=2012; data work.peers; set work.import; rename EFTOTAL__EF&year.__EFLEVEL_20_ = GrandTotal_&year.; rename EFMEN__EF&year.__EFLEVEL_20_ = TotalMen_&year.; rename EFWOM__EF&year.__EFLEVEL_20_ = TotalWomen_&year.; rename EFAIANT__EF&year.A__EFALEVEL_2_ = AmerIndianAlaskNat_&year.; rename EFBKAAT__EF&year.A__EFALEVEL_2_ = Black_&year.; rename EFHISPT__EF&year.A__EFALEVEL_2_ = Hispanic_&year.; rename EFASIAT__EF&year.A__EFALEVEL_2_ = Asian_&year.; rename EFNHPIT__EF&year.A__EFALEVEL_2_ = Hawaiian_&year.; rename EFWHITT__EF&year.A__EFALEVEL_2_ = White_&year.; rename EF2MORT__EF&year.A__EFALEVEL_2_= TwoOrMore_&year.; rename EFUNKNT__EF&year.A__EFALEVEL_2_ = Unknown_&year.; rename EFNRALT__EF&year.A__EFALEVEL_2_ = International_&year.; run; data work.peers1; set work.peers; *Percentage of Female/Male Students*; PctFemale= TotalWomen_&year. / GrandTotal_&year.; PctMale = TotalMen_&year. / GrandTotal_&year.; Minority = (AmerIndianAlaskNat_&year. + Black_&year. + Hispanic_&year. + Hawaiian_&year. + TwoOrMore_&year. )/ GrandTotal_&year.; Majority = (Asian_&year. + White_&year.) / GrandTotal_&year.; Unknown = Unknown_&year. / GrandTotal_&year.; International = International_&year. / GrandTotal_&year.; *Easy check to see if your numbers add up*; Total_percent=Minority+Majority+Unknown+International; run;