**************************************************************************; *** Created: Sep 2006 ***; *** Modify the LIBNAME path below to point to your data file ***; *** Written by: Abe George, Kforce Government Solutions ***; *** ***; *** Program Name: Read_ALS_2004_P.2.A.sas ***; *** Data file Name: ALS_2004_P.2.A.txt ***; **************************************************************************; *** change OUT1 directory to where you wish the permanent SAS data set to be located *** this location does not need to be in the same location as ALS_2004_P.2.A.TXT; LIBNAME OUT1 'C:\ALS2004'; data OUT1.ALS_2004_P2A; *** change directory path to point to where ALS_2004_P.2.A.TXT is stored; infile 'C:\DOWNLOADED FILES\ALS_2004_P.2.A.TXT' dsd dlm='09'x missover lrecl=2228 firstobs=2; informat UNITID $6. INSTNM $50. ADDR $60. CITY $20. STABBR $2. ZIP $9. FIPS $2. ACT $1. OBEREG 2.0 EIN $9. DUNS $10. OPEID $8. OPEFLAG 1.0 WEBADDR $50. SECTOR 2.0 ICLEVEL 2.0 CONTROL 2.0 HLOFFER 2.0 UGOFFER 2.0 GROFFER 2.0 FPOFFER 2.0 HDEGOFFR 2.0 DEGGRANT 2.0 PCTMIN1 3.0 PCTMIN2 3.0 PCTMIN3 3.0 PCTMIN4 3.0 HBCU 2.0 HOSPITAL 2.0 MEDICAL 2.0 TRIBAL 2.0 CARNEGIE 2.0 LOCALE 2.0 OPENPUBL 2.0 DATSRC $1. STATUS $1. EDITST $1. EDITDATE $CHAR8. IMPUTE $1. IMPDATE $CHAR8. PARTAFLAG1 $1. PARTBFLAG1 $1. PARTBFLAG2 $1. PARTCFLAG1 $1. PARTCFLAG2 $1. PARTDFLAG1 $1. PARTDFLAG2 $1. PARTEFLAG1 $1. PARTEFLAG2 $1. PARTEFLAG3 $1. PARTFFLAG1 $1. NCESDATE $CHAR8. FTEUSED 8. FTEFLAG $1. ELGCOLL $1. ELGSTAFF $1. ELGSCHED $1. ELGPHYS $1. FINSUPP $1. CYPARCH $1. UNITIDX $6. LIBSHAR1 $6. LIBNAME1 $50. LIBSHAR2 $6. LIBNAME2 $50. LIBSHAR3 $6. LIBNAME3 $50. XBRANCHES $1. BRANCHES 6.0 XSTLIBS $1. STLIBS 9.2 XSTOTHPRO $1. STOTHPRO 9.2 XSTLIBPRO $1. STLIBPRO 9.2 XSTOTH $1. STOTH 9.2 XSTASST $1. STASST 9.2 XSTTOT $1. STTOT 9.2 XSWLIBPRO $1. SWLIBPRO 12.0 XSWOTH $1. SWOTH 12.0 XSWASST $1. SWASST 12.0 XSWTOT $1. SWTOT 12.0 XFRINGEYN $1. FRINGEYN $1. XFRINGE $1. FRINGE 12.0 XEXBKS $1. EXBKS 12.0 XEXELBKS $1. EXELBKS 12.0 XEXAUD $1. EXAUD 12.0 XEXCUSER $1. EXCUSER 12.0 XEXELSER $1. EXELSER 12.0 XEXDEL $1. EXDEL 12.0 XEXPRES $1. EXPRES 12.0 XEXOTHIR $1. EXOTHIR 12.0 XEXCOMP $1. EXCOMP 12.0 XEXBIB $1. EXBIB 12.0 XEXOTH $1. EXOTH 12.0 XEXTOT $1. EXTOT 12.0 XCOLELYN $1. COLELYN $1. XCOLBKSA $1. COLBKSA 12.0 XCOLEBKSA $1. COLEBKSA 12.0 XCOLMICRA $1. COLMICRA 12.0 XCOLAUDA $1. COLAUDA 12.0 XCOLSERA $1. COLSERA 12.0 XCOLELREFA $1. COLELREFA 12.0 XCOLBKSH $1. COLBKSH 12.0 XCOLEBKSH $1. COLEBKSH 12.0 XCOLMICRH $1. COLMICRH 12.0 XCOLAUDH $1. COLAUDH 12.0 XCOLSERH $1. COLSERH 12.0 XCOLELREFH $1. COLELREFH 12.0 XILPRET $1. ILPRET 12.0 XILPNON $1. ILPNON 12.0 XILPTOT $1. ILPTOT 12.0 XILRRET $1. ILRRET 12.0 XILRNON $1. ILRNON 12.0 XILRTOT $1. ILRTOT 12.0 XDOCDEL $1. DOCDEL 12.0 XCRGEN $1. CRGEN 12.0 XCRRSV $1. CRRSV 12.0 XPRESEN $1. PRESEN 12.0 XATTEND $1. ATTEND 12.0 XHOURS $1. HOURS 8.0 XGATECT $1. GATECT 12.0 XREFTRANS $1. REFTRANS 12.0 XDOCDIGYN $1. DOCDIGYN $1. XLIBREFYN $1. LIBREFYN $1. XTECHYN $1. TECHYN $1. XTHESYN $1. THESYN $1. XCNSUBYN $1. CNSUBYN $1. XCNPARTYN $1. CNPARTYN $1. XCNFULLYN $1. CNFULLYN $1. XCNPRTLYN $1. CNPRTLYN $1. XCNOTHRYN $1. CNOTHRYN $1. XINFLITDEFYN $1. INFLITDEFYN $1. XINFLITMISYN $1. INFLITMISYN $1. XINFLITPLNYN $1. INFLITPLNYN $1. XINFLITCOMYN $1. INFLITCOMYN $1. ; input UNITID INSTNM ADDR CITY STABBR ZIP FIPS ACT OBEREG EIN DUNS OPEID OPEFLAG WEBADDR SECTOR ICLEVEL CONTROL HLOFFER UGOFFER GROFFER FPOFFER HDEGOFFR DEGGRANT PCTMIN1 PCTMIN2 PCTMIN3 PCTMIN4 HBCU HOSPITAL MEDICAL TRIBAL CARNEGIE LOCALE OPENPUBL DATSRC STATUS EDITST EDITDATE IMPUTE IMPDATE PARTAFLAG1 PARTBFLAG1 PARTBFLAG2 PARTCFLAG1 PARTCFLAG2 PARTDFLAG1 PARTDFLAG2 PARTEFLAG1 PARTEFLAG2 PARTEFLAG3 PARTFFLAG1 NCESDATE FTEUSED FTEFLAG ELGCOLL ELGSTAFF ELGSCHED ELGPHYS FINSUPP CYPARCH UNITIDX LIBSHAR1 LIBNAME1 LIBSHAR2 LIBNAME2 LIBSHAR3 LIBNAME3 XBRANCHES BRANCHES XSTLIBS STLIBS XSTOTHPRO STOTHPRO XSTLIBPRO STLIBPRO XSTOTH STOTH XSTASST STASST XSTTOT STTOT XSWLIBPRO SWLIBPRO XSWOTH SWOTH XSWASST SWASST XSWTOT SWTOT XFRINGEYN FRINGEYN XFRINGE FRINGE XEXBKS EXBKS XEXELBKS EXELBKS XEXAUD EXAUD XEXCUSER EXCUSER XEXELSER EXELSER XEXDEL EXDEL XEXPRES EXPRES XEXOTHIR EXOTHIR XEXCOMP EXCOMP XEXBIB EXBIB XEXOTH EXOTH XEXTOT EXTOT XCOLELYN COLELYN XCOLBKSA COLBKSA XCOLEBKSA COLEBKSA XCOLMICRA COLMICRA XCOLAUDA COLAUDA XCOLSERA COLSERA XCOLELREFA COLELREFA XCOLBKSH COLBKSH XCOLEBKSH COLEBKSH XCOLMICRH COLMICRH XCOLAUDH COLAUDH XCOLSERH COLSERH XCOLELREFH COLELREFH XILPRET ILPRET XILPNON ILPNON XILPTOT ILPTOT XILRRET ILRRET XILRNON ILRNON XILRTOT ILRTOT XDOCDEL DOCDEL XCRGEN CRGEN XCRRSV CRRSV XPRESEN PRESEN XATTEND ATTEND XHOURS HOURS XGATECT GATECT XREFTRANS REFTRANS XDOCDIGYN DOCDIGYN XLIBREFYN LIBREFYN XTECHYN TECHYN XTHESYN THESYN XCNSUBYN CNSUBYN XCNPARTYN CNPARTYN XCNFULLYN CNFULLYN XCNPRTLYN CNPRTLYN XCNOTHRYN CNOTHRYN XINFLITDEFYN INFLITDEFYN XINFLITMISYN INFLITMISYN XINFLITPLNYN INFLITPLNYN XINFLITCOMYN INFLITCOMYN ; label UNITID = 'Unit Id Number for the Institution' INSTNM = 'Institution Name' ADDR = 'Institution Address' CITY = 'Institution City' STABBR = 'State Abbreviation Code' ZIP = 'Postal Zip code PLUS 4' FIPS = 'FIPS state code' ACT = 'Status of the Institution' OBEREG = 'OBE Region Code' EIN = 'Employer Id Number' DUNS = 'Dunn and Bradstreet Id Number' OPEID = 'Office of Post Sec Education Id Num for Title IV Participant' OPEFLAG = 'OPE Eligibility Indicator' WEBADDR = 'Institutions Web Address' SECTOR = 'Sector of Institution' ICLEVEL = 'Level of Institution' CONTROL = 'Control of Institution' HLOFFER = 'Highest Level of Education Offering' UGOFFER = 'Undergraduate Offering' GROFFER = 'Graduate Offering' FPOFFER = 'First Professional Offering' HDEGOFFR = 'Highest Degree Offered' DEGGRANT = 'Degree Granting Status' PCTMIN1 = 'Percent Black non-Hispanic 2004 Fall Enroll' PCTMIN2 = 'Percent American Indian 2004 Fall Enroll' PCTMIN3 = 'Percent Asian/Pacific Islander 2004 Fall Enroll' PCTMIN4 = 'Percent Hispanic 2004 Fall Enroll' HBCU = 'Historically Black College/University' HOSPITAL = 'Institution has Hospital' MEDICAL = 'Institution Grants Medical Degree' TRIBAL = 'Tribal College' CARNEGIE = 'Carnegie Classification Code' LOCALE = 'Locale Code - Degree of Urbanization' OPENPUBL = 'Institution Open to the General Public' DATSRC = 'Data Source Code - Media Source Used for Returning Data' STATUS = 'Response Status Code' EDITST = 'Release Status Give to NCES' EDITDATE = 'Most Recent Edit Date' IMPUTE = 'Impute Indicator' IMPDATE = 'Most Recent Impute Date' PARTAFLAG1 = 'Imp Flag for Line Item 1' PARTBFLAG1 = 'Imp Flag for Line Items 2-7' PARTBFLAG2 = 'Imp Flag for Line Items 8a,8b' PARTCFLAG1 = 'Imp Flag for Line Items 10,13,15-21' PARTCFLAG2 = 'Imp Flag for Line Items 11,12,14' PARTDFLAG1 = 'Imp Flag for Line Items 22,24-26' PARTDFLAG2 = 'Imp Flag for Line Item 23' PARTEFLAG1 = 'Imp Flag for Line Items 27-33' PARTEFLAG2 = 'Imp Flag for Line Items 34a,34b' PARTEFLAG3 = 'Imp Flag for Line Items 35,36' PARTFFLAG1 = 'Imp Flag for Line Items 37-39' NCESDATE = 'Date Imputations Run by ESMPD' FTEUSED = '2004 IPEDS Fall Full-Time Equivalent Enrollment - Imputation used' FTEFLAG = 'Full-Time Equivalent Estimated or Not' ELGCOLL = 'Institution has an Eligible Collection' ELGSTAFF = 'Institution has Eligible Staff' ELGSCHED = 'Institution has an Established Schedule' ELGPHYS = 'Institution has physical Library Facility' FINSUPP = 'Provide Financial Support to Another Library' CYPARCH = 'Current Year Parent/Child Indicator' UNITIDX = 'If Child, Parent Institution Unit Id' LIBSHAR1 = 'Shared Library, 1st Unit Id' LIBNAME1 = 'Name of 1st Institution Library is Shared With' LIBSHAR2 = 'Shared Library, 2nd Unit Id' LIBNAME2 = 'Name of 2nd Institution Library is Shared With' LIBSHAR3 = 'Shared Library, 3rd Unit Id' LIBNAME3 = 'Name of 3rd Institution Library is Shared With' XBRANCHES = 'Status Flag - BRANCHES' BRANCHES = 'Number of Branch and Independent Libraries' XSTLIBS = 'Status Flag - STLIBS' STLIBS = 'Staff - Librarians' XSTOTHPRO = 'Status Flag - STOTHPRO' STOTHPRO = 'Staff - Other Professional Staff' XSTLIBPRO = 'Status Flag - STLIBPRO' STLIBPRO = 'Staff - Total Librarians and Other Professional Staff' XSTOTH = 'Status Flag - STOTH' STOTH = 'All Other Paid Staff' XSTASST = 'Status Flag - STASST' STASST = 'Student Assistants' XSTTOT = 'Status Flag - STTOT' STTOT = 'Total Full Time Equivalent Staff' XSWLIBPRO = 'Status Flag - SWLIBPRO' SWLIBPRO = 'Salary & Wage - Librarian and Other Professional Staff' XSWOTH = 'Status Flag - SWOTH' SWOTH = 'Salary & Wage - Other Paid Staff' XSWASST = 'Status Flag - SWASST' SWASST = 'Salary & Wage - Student Assistant' XSWTOT = 'Status Flag - SWTOT' SWTOT = 'Salary & Wage - Total Full Time Equivalent' XFRINGEYN = 'Status Flag - FRINGEYN' FRINGEYN = 'Are Fringe Benefit paid from Library Budget' XFRINGE = 'Status Flag - FRINGE' FRINGE = 'Fringe Benefit' XEXBKS = 'Status Flag - EXBKS' EXBKS = 'Expenditure - Books' XEXELBKS = 'Status Flag - EXELBKS' EXELBKS = 'Expenditure - Electronic Books' XEXAUD = 'Status Flag - EXAUD' EXAUD = 'Expenditure - Audio visual' XEXCUSER = 'Status Flag - EXCUSER' EXCUSER = 'Expenditure - Serial Subscription' XEXELSER = 'Status Flag - EXELSER' EXELSER = 'Expenditure - Electronic serials' XEXDEL = 'Status Flag - EXDEL' EXDEL = 'Expenditure - Document Deliver' XEXPRES = 'Status Flag - EXPRES' EXPRES = 'Expenditure - Preservation' XEXOTHIR = 'Status Flag - EXOTHIR' EXOTHIR = 'Expenditure - Other Information Resources' XEXCOMP = 'Status Flag - EXCOMP' EXCOMP = 'Expenditure - Computer Hardware Software' XEXBIB = 'Status Flag - EXBIB' EXBIB = 'Expenditure - Bibliographic Utilities' XEXOTH = 'Status Flag - EXOTH' EXOTH = 'Expenditure - All Other Operating Expenditure' XEXTOT = 'Status Flag - EXTOT' EXTOT = 'Expenditure - Total' XCOLELYN = 'Status Flag - XCOLELYN' COLELYN = 'Library Collection is Entirely Electronic' XCOLBKSA = 'Status Flag - COLBKSA' COLBKSA = 'Collections - Books - Added' XCOLEBKSA = 'Status Flag - COLEBKSA' COLEBKSA = 'Collections - E Books - Added' XCOLMICRA = 'Status Flag - COLMICRA' COLMICRA = 'Collections - Microforms - Added' XCOLAUDA = 'Status Flag - COLAUDA' COLAUDA = 'Collections - Audiovisual - Added' XCOLSERA = 'Status Flag - COLSERA' COLSERA = 'Collections - Serial Subscription - Added' XCOLELREFA = 'Status Flag - XCOLELREFA' COLELREFA = 'Collections - Electronic Ref Sources - Added' XCOLBKSH = 'Status Flag - COLBKSH' COLBKSH = 'Collections - Books - Held' XCOLEBKSH = 'Status Flag - COLEBKSH' COLEBKSH = 'Collections - E Books - Held' XCOLMICRH = 'Status Flag - COLMICRH' COLMICRH = 'Collections - Microforms - Held' XCOLAUDH = 'Status Flag - COLAUDH' COLAUDH = 'Collections - Audiovisual - Held' XCOLSERH = 'Status Flag - COLSERH' COLSERH = 'Collections - Serial Subscriptions Held' XCOLELREFH = 'Status Flag - COLELREFH' COLELREFH = 'Collections - Electronic Ref Sources - Held' XILPRET = 'Status Flag - ILPRET' ILPRET = 'Inter Library Loans Provided Returnable' XILPNON = 'Status Flag - ILPNON' ILPNON = 'Inter Library Loans Provided Non-returnable' XILPTOT = 'Status Flag - ILPTOT' ILPTOT = 'Inter Library Loans Provided Total' XILRRET = 'Status Flag - ILRRET' ILRRET = 'Inter Library Loans Received Returnable' XILRNON = 'Status Flag - ILRNON' ILRNON = 'Inter Library Loans Received Non-returnable' XILRTOT = 'Status Flag - ILRTOT' ILRTOT = 'Inter Library Loans Received Total' XDOCDEL = 'Status Flag - DOCDEL' DOCDEL = 'Documents Delivered from Commercial Services' XCRGEN = 'Status Flag - CRGEN' CRGEN = 'General Circulation Transactions' XCRRSV = 'Status Flag - CRRSV' CRRSV = 'Reserve Circulation Transactions' XPRESEN = 'Status Flag - PRESEN' PRESEN = 'Number of Presentations' XATTEND = 'Status Flag - ATTEND' ATTEND = 'Total Attendance at Presentations' XHOURS = 'Status Flag - HOURS' HOURS = 'Hours Open in a Typical Week' XGATECT = 'Status Flag - GATECT' GATECT = 'Gate Count in a Typical Week' XREFTRANS = 'Status Flag - REFTRANS' REFTRANS = 'Reference Transactions in a Typical Week' XDOCDIGYN = 'Status Flag - DOCDIGYN' DOCDIGYN = 'Does Documents Digitized by Library Staff' XLIBREFYN = 'Status Flag - LIBREFYN' LIBREFYN = 'Does Library Provide Reference Service by Email or Web' XTECHYN = 'Status Flag - TECHYN' TECHYN = 'Technology to Assist the Disabled' XTHESYN = 'Status Flag - THESYN' THESYN = 'Electronic Theses Produced by Students' XCNSUBYN = 'Status Flag - CNSUBYN' CNSUBYN = 'State have Subsidized Library Consortium' XCNPARTYN = 'Status Flag - CNPARTYN' CNPARTYN = 'Participate in Consortium' XCNFULLYN = 'Status Flag - CNFULLYN' CNFULLYN = 'Consortium Cost Fully Funded by State' XCNPRTLYN = 'Status Flag - CNPRTLYN' CNPRTLYN = 'Consortium Cost Partially Funded by State' XCNOTHRYN = 'Status Flag - CNOTHRYN' CNOTHRYN = 'Library Participate in any Other Consortia' XINFLITDEFYN = 'Status Flag - XINFLITDEFYN' INFLITDEFYN = 'Information Literacy Definition' XINFLITMISYN = 'Status Flag - XINFLITMISYN' INFLITMISYN = 'Information Literacy in Institution Mission' XINFLITPLNYN = 'Status Flag - XINFLITPLNYN' INFLITPLNYN = 'Information Literacy in Institution Plan' XINFLITCOMYN = 'Status Flag - XINFLITCOMYN' INFLITCOMYN = 'Information Literacy Committee for Implementation' ; run; proc format; value $act "A" ="A Active - Institution active and not an add" "C" ="C Combined - Merged with another institution" "D" ="D Delete - Institution is out of business" "H" ="H Areas search on hold pending verification" "I" ="I Inactive" "M" ="M Death with data - Closed in current year" "N" ="N New - Added during the current year" "O" ="O Out-of-scope - Not within scope of universe" "P" ="P Potential add - might be added" "Q" ="Q Potential restore - might be restored" "R" ="R Restore - restored to the current universe" "S" ="S Split - Split into more than one institution" "U" ="U Duplicate - UNITID previously assigned" "W" ="W Wipe out - out-of-scope potential add" "X" ="X Potential restore not within scope of IPEDS" "Z" ="Z Universe III - out-of-scope"; value carnegie 15 ="15 Doctoral/Research universities - Extensive" 16 ="16 Doctoral/Research universities - Intensive" 21 ="21 Master's Colleges and Universities I" 22 ="22 Master's (comprehensive) Colleges and Universities II" 31 ="31 Baccalaureate Colleges - Liberal Arts" 32 ="32 Baccalaureate Colleges - General" 33 ="33 Baccalaureate/Associate's Colleges" 40 ="40 Associate's Colleges" 51 ="51 Theological seminaries and other specialized faith-related institutions" 52 ="52 Medical schools and medical centers" 53 ="53 Other separate health profession schools" 54 ="54 Schools of engineering and technology" 55 ="55 Schools of business and management" 56 ="56 Schools of art, music, and design" 57 ="57 Schools of law" 58 ="58 Teachers colleges" 59 ="59 Other specialized institutions" 60 ="60 Tribal Colleges and Universities" -2 ="-2 Not applicable" -3 ="-3 Not available"; value $cnpart "1" ="1 Yes" "2" ="2 No" "3" ="3 State has no subsidized consortium" "F" ="F Full participation" "N" ="N No response" "S" ="S Skip, no participation" "H" ="H Data suppressed"; value control 1 ="1 Public" 2 ="2 Private, nonprofit" 3 ="3 Private, for profit" -3 ="-3 Not available"; value $cyparch "1" ="1 Parent" "2" ="2 Child" "9" ="9 Not applicable" "N" ="N No response"; value $datsrc "1" ="1 Internet/Web" "7" ="7 Other, telephone" "N" ="N Not returned"; value $editst "0" ="0 Not edited" "1" ="1 Record edited with no edit or critical flags" "2" ="2 Record edited with critical edit flags, analyst accept" "3" ="3 Record edited with critical edit flags remaining, NCES override" "4" ="4 Record is on hold" "5" ="5 Record failed the edits" "N" ="N No response"; value $fips "01" ="01 Alabama" "02" ="02 Alaska" "04" ="04 Arizona" "05" ="05 Arkansas" "06" ="06 California" "08" ="08 Colorado" "09" ="09 Connecticut" "10" ="10 Delaware" "11" ="11 District of Columbia" "12" ="12 Florida" "13" ="13 Georgia" "15" ="15 Hawaii" "16" ="16 Idaho" "17" ="17 Illinois" "18" ="18 Indiana" "19" ="19 Iowa" "20" ="20 Kansas" "21" ="21 Kentucky" "22" ="22 Louisiana" "23" ="23 Maine" "24" ="24 Maryland" "25" ="25 Massachusetts" "26" ="26 Michigan" "27" ="27 Minnesota" "28" ="28 Mississippi" "29" ="29 Missouri" "30" ="30 Montana" "31" ="31 Nebraska" "32" ="32 Nevada" "33" ="33 New Hampshire" "34" ="34 New Jersey" "35" ="35 New Mexico" "36" ="36 New York" "37" ="37 North Carolina" "38" ="38 North Dakota" "39" ="39 Ohio" "40" ="40 Oklahoma" "41" ="41 Oregon" "42" ="42 Pennsylvania" "44" ="44 Rhode Island" "45" ="45 South Carolina" "46" ="46 South Dakota" "47" ="47 Tennessee" "48" ="48 Texas" "49" ="49 Utah" "50" ="50 Vermont" "51" ="51 Virginia" "53" ="53 Washington" "54" ="54 West Virginia" "55" ="55 Wisconsin" "56" ="56 Wyoming" "60" ="60 American Samoa" "64" ="64 Fed State Micronesia" "66" ="66 Guam" "68" ="68 Marshall Islands" "69" ="69 Northern Mariana Isl" "70" ="70 Palau" "72" ="72 Puerto Rico" "78" ="78 Virgin Islands"; value fpoffer 1 ="1 First professional degree or first professional certificate (Post-degree)" 2 ="2 No first professional offering" -3 ="-3 Not available"; value $fteflag "0" ="0 Not estimated" "1" ="1 Estimated"; value groffer 1 ="1 Graduate degree or certificate offered" 2 ="2 No graduate offering" -3 ="-3 Not available"; value hdegoffr 0 ="0 Non degree granting (certificates only)" 1 ="1 First professional degrees only" 10 ="10 Doctoral" 11 ="11 Doctoral and First professional" 20 ="20 Master's" 21 ="21 Master's and First professional" 30 ="30 Bachelors" 31 ="31 Bachelors and First professional" 40 ="40 Associates" 41 ="41 Associates and First professional" -3 ="-3 Not available"; value hloffer 0 ="0 Other" 1 ="1 Postsecondary award, certificate or diploma of less than one academic year" 2 ="2 Postsecondary award, certificate or diploma of at least one but less than two academic years" 3 ="3 Associate degree" 4 ="4 Postsecondary award, certificate or diploma of at least two but less than four academic years" 5 ="5 Bachelor's degree" 6 ="6 Post baccalaureate certificate" 7 ="7 Master's degree" 8 ="8 Post master's certificate" 9 ="9 Doctoral degree" -2 ="-2 Not applicable, first professional only" -3 ="-3 Not available" -9 ="-9 None of the above or no answer"; value iclevel 1 ="1 Four or more years (Baccalaureate or higher degree)" 2 ="2 At least 2 but less than 4 years (below the Baccalaureate)" 3 ="3 Less than 2 years (below Associate degree)" -3 ="-3 Not available"; value $impcode "A" ="A Analyst adjusted a reported value" "C" ="C Analyst corrected a cell that was blank" "I" ="I Imputation for a cell that previously was a nonresponse, using a method other than prior year" "N" ="N Original data field was blank" "P" ="P Imputation for a cell that previously was a nonresponse, using prior year data" "R" ="R Original data value was reported" "S" ="S Not applicable, not imputed" "T" ="T Total replaced with sum of detail during imputation" "Z" ="Z Implied reported zero value" "H" ="H Data suppressed"; value $impute "0" ="0 Not imputed" "1" ="1 At least one part is imputed"; value locale 1 ="1 Large city" 2 ="2 Mid-size city" 3 ="3 Urban fringe of large city" 4 ="4 Urban fringe of mid-size city" 5 ="5 Large town" 6 ="6 Small town" 7 ="7 Rural" 9 ="9 Not assigned" -3 ="-3 Not available"; value $mis_res "-1" ="-1 Not reported" "-2" ="-2 Not applicable" "-3" ="-3 Not available" " " ="Blank value" other="Valid value"; value mis_res -1 ="-1 Not reported" -2 ="-2 Not applicable" -3 ="-3 Not available" . ="Missing numeric value" other="Valid value"; value obereg 0 ="0 US Service Schools" 1 ="1 New England - CT ME MA NH RI VT" 2 ="2 Mid East - DE DC MD NJ NY PA" 3 ="3 Great Lakes - IL IN MI OH WI" 4 ="4 Plains - IA KS MN MO NE ND SD" 5 ="5 Southeast - AL AR FL GA KY LA MS NC SC TN VA WV" 6 ="6 Southwest - AZ NM OK TX" 7 ="7 Rocky Mountains - CO ID MT UT WY" 8 ="8 Far West - AK CA HI NV OR WA" 9 ="9 Outlying areas - AS FM GU MH MP PR PW VI" -3 ="-3 Not available"; value opeflag 1 ="1 Institution participates in Title IV federal financial aid programs" 2 ="2 Branch campus of a main campus that participates in Title IV" 3 ="3 Deferment only - limited participation" 4 ="4 New participants (became eligible during the Fall collection-IPEDS)" 5 ="5 Not currently participating in Title IV, has an OPE ID number" 6 ="6 Not currently participating in Title IV, does not have an OPE ID number"; value $partflg "0" ="0 Nothing imputed for this part/total respondent for this part" "1" ="1 Total non-respondent for this part" "2" ="2 Partial non-respondent for this part"; value sector 0 ="0 Administrative unit only (central, system, or corporate office)" 1 ="1 Public, 4-year or above" 2 ="2 Private nonprofit, 4-year and above" 3 ="3 Private for profit, 4-year and above" 4 ="4 Public, 2-year" 5 ="5 Private nonprofit, 2-year" 6 ="6 Private for profit, 2-year" 7 ="7 Public, less than 2-year" 8 ="8 Private nonprofit, less than 2-year" 9 ="9 Private for profit, less than 2-year" -3 ="-3 Not available"; value $stabbr "AL" ="AL Alabama" "AK" ="AK Alaska" "AZ" ="AZ Arizona" "AR" ="AR Arkansas" "CA" ="CA California" "CO" ="CO Colorado" "CT" ="CT Connecticut" "DE" ="DE Delaware" "DC" ="DC District of Columbia" "FL" ="FL Florida" "GA" ="GA Georgia" "HI" ="HI Hawaii" "ID" ="ID Idaho" "IL" ="IL Illinois" "IN" ="IN Indiana" "IA" ="IA Iowa" "KS" ="KS Kansas" "KY" ="KY Kentucky" "LA" ="LA Louisiana" "ME" ="ME Maine" "MD" ="MD Maryland" "MA" ="MA Massachusetts" "MI" ="MI Michigan" "MN" ="MN Minnesota" "MS" ="MS Mississippi" "MO" ="MO Missouri" "MT" ="MT Montana" "NE" ="NE Nebraska" "NV" ="NV Nevada" "NH" ="NH New Hampshire" "NJ" ="NJ New Jersey" "NM" ="NM New Mexico" "NY" ="NY New York" "NC" ="NC North Carolina" "ND" ="ND North Dakota" "OH" ="OH Ohio" "OK" ="OK Oklahoma" "OR" ="OR Oregon" "PA" ="PA Pennsylvania" "RI" ="RI Rhode Island" "SC" ="SC South Carolina" "SD" ="SD South Dakota" "TN" ="TN Tennessee" "TX" ="TX Texas" "UT" ="UT Utah" "VT" ="VT Vermont" "VA" ="VA Virginia" "WA" ="WA Washington" "WV" ="WV West Virginia" "WI" ="WI Wisconsin" "WY" ="WY Wyoming" "AS" ="AS American Samoa" "FM" ="FM Fed State Micronesia" "GU" ="GU Guam" "MH" ="MH Marshall Islands" "MP" ="MP Northern Mariana Isl" "PW" ="PW Palau" "PR" ="PR Puerto Rico" "VI" ="VI Virgin Islands"; value $status "1" ="1 Respondent" "3" ="3 Nonrespondent to data and screening questions, not imputed" "4" ="4 Nonrespondent, imputed" "5" ="5 Nonrespondent to data (screening questions reported, out-of-scope), not imputed" "6" ="6 Nonrespondent to data (screening questions reported, in-scope), not imputed"; value ugoffer 1 ="1 Undergraduate degree or certificate offered" 2 ="2 No undergraduate offering" -3 ="-3 Not available"; value yes_no 1 ="1 Yes" 2 ="2 No" -1 ="-1 Not reported" -3 ="-3 Not available"; value $yes_no "1" ="1 Yes" "2" ="2 No" "N" ="N No response"; run; *******************************************************************; *** Listed below are all the variables in alphabetical order. ***; *** Corresponding to each variable name, the format name to be ***; *** used is listed. Character string data and continuous ***; *** numeric variables may not have specific formats, but will ***; *** have a general format assigned to show number and percentage***; *** of valid responses for that variable. ***; *******************************************************************; /* ACT $act. ADDR $mis_res. ATTEND mis_res. BRANCHES mis_res. CARNEGIE carnegie. CITY $mis_res. CNFULLYN $cnpart. CNOTHRYN $cnpart. CNPARTYN $cnpart. CNPRTLYN $cnpart. CNSUBYN $cnpart. COLAUDA mis_res. COLAUDH mis_res. COLBKSA mis_res. COLBKSH mis_res. COLEBKSA mis_res. COLEBKSH mis_res. COLELREFA mis_res. COLELREFH mis_res. COLELYN $yes_no. COLMICRA mis_res. COLMICRH mis_res. COLSERA mis_res. COLSERH mis_res. CONTROL control. CRGEN mis_res. CRRSV mis_res. CYPARCH $cyparch. DATSRC $datsrc. DEGGRANT yes_no. DOCDEL mis_res. DOCDIGYN $yes_no. DUNS $mis_res. EDITDATE $mis_res. EDITST $editst. EIN $mis_res. ELGCOLL $yes_no. ELGPHYS $yes_no. ELGSCHED $yes_no. ELGSTAFF $yes_no. EXAUD mis_res. EXBIB mis_res. EXBKS mis_res. EXCOMP mis_res. EXCUSER mis_res. EXDEL mis_res. EXELBKS mis_res. EXELSER mis_res. EXOTH mis_res. EXOTHIR mis_res. EXPRES mis_res. EXTOT mis_res. FINSUPP $yes_no. FIPS $fips. FPOFFER fpoffer. FRINGE mis_res. FRINGEYN $yes_no. FTEUSED mis_res. FTEFLAG $fteflag. GATECT mis_res. GROFFER groffer. HBCU yes_no. HDEGOFFR hdegoffr. HLOFFER hloffer. HOSPITAL yes_no. HOURS mis_res. ICLEVEL iclevel. ILPNON mis_res. ILPRET mis_res. ILPTOT mis_res. ILRNON mis_res. ILRRET mis_res. ILRTOT mis_res. IMPDATE $mis_res. IMPUTE $impute. INFLITCOMYN $yes_no. INFLITDEFYN $yes_no. INFLITMISYN $yes_no. INFLITPLNYN $yes_no. INSTNM $mis_res. LIBNAME1 $mis_res. LIBNAME2 $mis_res. LIBNAME3 $mis_res. LIBREFYN $yes_no. LIBSHAR1 $mis_res. LIBSHAR2 $mis_res. LIBSHAR3 $mis_res. LOCALE locale. MEDICAL yes_no. NCESDATE $mis_res. OBEREG obereg. OPEFLAG opeflag. OPEID $mis_res. OPENPUBL yes_no. PARTAFLAG1 $partflg. PARTBFLAG1 $partflg. PARTBFLAG2 $partflg. PARTCFLAG1 $partflg. PARTCFLAG2 $partflg. PARTDFLAG1 $partflg. PARTDFLAG2 $partflg. PARTEFLAG1 $partflg. PARTEFLAG2 $partflg. PARTEFLAG3 $partflg. PARTFFLAG1 $partflg. PCTMIN1 mis_res. PCTMIN2 mis_res. PCTMIN3 mis_res. PCTMIN4 mis_res. PRESEN mis_res. REFTRANS mis_res. SECTOR sector. STABBR $stabbr. STASST mis_res. STATUS $status. STLIBPRO mis_res. STLIBS mis_res. STOTH mis_res. STOTHPRO mis_res. STTOT mis_res. SWASST mis_res. SWLIBPRO mis_res. SWOTH mis_res. SWTOT mis_res. TECHYN $yes_no. THESYN $yes_no. TRIBAL yes_no. UGOFFER ugoffer. UNITID $mis_res. UNITIDX $mis_res. WEBADDR $mis_res. XATTEND $impcode. XBRANCHES $impcode. XCNFULLYN $impcode. XCNOTHRYN $impcode. XCNPARTYN $impcode. XCNPRTLYN $impcode. XCNSUBYN $impcode. XCOLAUDA $impcode. XCOLAUDH $impcode. XCOLBKSA $impcode. XCOLBKSH $impcode. XCOLEBKSA $impcode. XCOLEBKSH $impcode. XCOLELREFA $impcode. XCOLELREFH $impcode. XCOLELYN $impcode. XCOLMICRA $impcode. XCOLMICRH $impcode. XCOLSERA $impcode. XCOLSERH $impcode. XCRGEN $impcode. XCRRSV $impcode. XDOCDEL $impcode. XDOCDIGYN $impcode. XEXAUD $impcode. XEXBIB $impcode. XEXBKS $impcode. XEXCOMP $impcode. XEXCUSER $impcode. XEXDEL $impcode. XEXELBKS $impcode. XEXELSER $impcode. XEXOTH $impcode. XEXOTHIR $impcode. XEXPRES $impcode. XEXTOT $impcode. XFRINGE $impcode. XFRINGEYN $impcode. XGATECT $impcode. XHOURS $impcode. XILPNON $impcode. XILPRET $impcode. XILPTOT $impcode. XILRNON $impcode. XILRRET $impcode. XILRTOT $impcode. XINFLITCOMYN $impcode. XINFLITDEFYN $impcode. XINFLITMISYN $impcode. XINFLITPLNYN $impcode. XLIBREFYN $impcode. XPRESEN $impcode. XREFTRANS $impcode. XSTASST $impcode. XSTLIBPRO $impcode. XSTLIBS $impcode. XSTOTH $impcode. XSTOTHPRO $impcode. XSTTOT $impcode. XSWASST $impcode. XSWLIBPRO $impcode. XSWOTH $impcode. XSWTOT $impcode. XTECHYN $impcode. XTHESYN $impcode. ZIP $mis_res. ; */ *******************************************************************; *** The following lines of code have been commented out. If the ***; *** user should wish to run file frequencies, or univariates ***; *** they may submit these lines separtely or remove the "/*" ***; *** and "*/" characters before running this code. ***; *******************************************************************; /* options pageno=1 nocenter; proc freq; where cyparch NE '2'; tables ACT ADDR ATTEND BRANCHES CARNEGIE CITY CNFULLYN CNOTHRYN CNPARTYN CNPRTLYN CNSUBYN COLAUDA COLAUDH COLBKSA COLBKSH COLEBKSA COLEBKSH COLELREFA COLELREFH COLELYN COLMICRA COLMICRH COLSERA COLSERH CONTROL CRGEN CRRSV CYPARCH DATSRC DEGGRANT DOCDEL DOCDIGYN DUNS EDITDATE EDITST EIN ELGCOLL ELGPHYS ELGSCHED ELGSTAFF EXAUD EXBIB EXBKS EXCOMP EXCUSER EXDEL EXELBKS EXELSER EXOTH EXOTHIR EXPRES EXTOT FINSUPP FIPS FPOFFER FRINGE FRINGEYN FTEUSED FTEFLAG GATECT GROFFER HBCU HDEGOFFR HLOFFER HOSPITAL HOURS ICLEVEL ILPNON ILPRET ILPTOT ILRNON ILRRET ILRTOT IMPDATE IMPUTE INFLITCOMYN INFLITDEFYN INFLITMISYN INFLITPLNYN INSTNM LIBNAME1 LIBNAME2 LIBNAME3 LIBREFYN LIBSHAR1 LIBSHAR2 LIBSHAR3 LOCALE MEDICAL NCESDATE OBEREG OPEFLAG OPEID OPENPUBL PARTAFLAG1 PARTBFLAG1 PARTBFLAG2 PARTCFLAG1 PARTCFLAG2 PARTDFLAG1 PARTDFLAG2 PARTEFLAG1 PARTEFLAG2 PARTEFLAG3 PARTFFLAG1 PCTMIN1 PCTMIN2 PCTMIN3 PCTMIN4 PRESEN REFTRANS SECTOR STABBR STASST STATUS STLIBPRO STLIBS STOTH STOTHPRO STTOT SWASST SWLIBPRO SWOTH SWTOT TECHYN THESYN TRIBAL UGOFFER UNITID UNITIDX WEBADDR XATTEND XBRANCHES XCNFULLYN XCNOTHRYN XCNPARTYN XCNPRTLYN XCNSUBYN XCOLAUDA XCOLAUDH XCOLBKSA XCOLBKSH XCOLEBKSA XCOLEBKSH XCOLELREFA XCOLELREFH XCOLELYN XCOLMICRA XCOLMICRH XCOLSERA XCOLSERH XCRGEN XCRRSV XDOCDEL XDOCDIGYN XEXAUD XEXBIB XEXBKS XEXCOMP XEXCUSER XEXDEL XEXELBKS XEXELSER XEXOTH XEXOTHIR XEXPRES XEXTOT XFRINGE XFRINGEYN XGATECT XHOURS XILPNON XILPRET XILPTOT XILRNON XILRRET XILRTOT XINFLITCOMYN XINFLITDEFYN XINFLITMISYN XINFLITPLNYN XLIBREFYN XPRESEN XREFTRANS XSTASST XSTLIBPRO XSTLIBS XSTOTH XSTOTHPRO XSTTOT XSWASST XSWLIBPRO XSWOTH XSWTOT XTECHYN XTHESYN ZIP /missing ; format ACT $act. ADDR $mis_res. ATTEND mis_res. BRANCHES mis_res. CARNEGIE carnegie. CITY $mis_res. CNFULLYN $cnpart. CNOTHRYN $cnpart. CNPARTYN $cnpart. CNPRTLYN $cnpart. CNSUBYN $cnpart. COLAUDA mis_res. COLAUDH mis_res. COLBKSA mis_res. COLBKSH mis_res. COLEBKSA mis_res. COLEBKSH mis_res. COLELREFA mis_res. COLELREFH mis_res. COLELYN $yes_no. COLMICRA mis_res. COLMICRH mis_res. COLSERA mis_res. COLSERH mis_res. CONTROL control. CRGEN mis_res. CRRSV mis_res. CYPARCH $cyparch. DATSRC $datsrc. DEGGRANT yes_no. DOCDEL mis_res. DOCDIGYN $yes_no. DUNS $mis_res. EDITDATE $mis_res. EDITST $editst. EIN $mis_res. ELGCOLL $yes_no. ELGPHYS $yes_no. ELGSCHED $yes_no. ELGSTAFF $yes_no. EXAUD mis_res. EXBIB mis_res. EXBKS mis_res. EXCOMP mis_res. EXCUSER mis_res. EXDEL mis_res. EXELBKS mis_res. EXELSER mis_res. EXOTH mis_res. EXOTHIR mis_res. EXPRES mis_res. EXTOT mis_res. FINSUPP $yes_no. FIPS $fips. FPOFFER fpoffer. FRINGE mis_res. FRINGEYN $yes_no. FTEUSED mis_res. FTEFLAG $fteflag. GATECT mis_res. GROFFER groffer. HBCU yes_no. HDEGOFFR hdegoffr. HLOFFER hloffer. HOSPITAL yes_no. HOURS mis_res. ICLEVEL iclevel. ILPNON mis_res. ILPRET mis_res. ILPTOT mis_res. ILRNON mis_res. ILRRET mis_res. ILRTOT mis_res. IMPDATE $mis_res. IMPUTE $impute. INFLITCOMYN $yes_no. INFLITDEFYN $yes_no. INFLITMISYN $yes_no. INFLITPLNYN $yes_no. INSTNM $mis_res. LIBNAME1 $mis_res. LIBNAME2 $mis_res. LIBNAME3 $mis_res. LIBREFYN $yes_no. LIBSHAR1 $mis_res. LIBSHAR2 $mis_res. LIBSHAR3 $mis_res. LOCALE locale. MEDICAL yes_no. NCESDATE $mis_res. OBEREG obereg. OPEFLAG opeflag. OPEID $mis_res. OPENPUBL yes_no. PARTAFLAG1 $partflg. PARTBFLAG1 $partflg. PARTBFLAG2 $partflg. PARTCFLAG1 $partflg. PARTCFLAG2 $partflg. PARTDFLAG1 $partflg. PARTDFLAG2 $partflg. PARTEFLAG1 $partflg. PARTEFLAG2 $partflg. PARTEFLAG3 $partflg. PARTFFLAG1 $partflg. PCTMIN1 mis_res. PCTMIN2 mis_res. PCTMIN3 mis_res. PCTMIN4 mis_res. PRESEN mis_res. REFTRANS mis_res. SECTOR sector. STABBR $stabbr. STASST mis_res. STATUS $status. STLIBPRO mis_res. STLIBS mis_res. STOTH mis_res. STOTHPRO mis_res. STTOT mis_res. SWASST mis_res. SWLIBPRO mis_res. SWOTH mis_res. SWTOT mis_res. TECHYN $yes_no. THESYN $yes_no. TRIBAL yes_no. UGOFFER ugoffer. UNITID $mis_res. UNITIDX $mis_res. WEBADDR $mis_res. XATTEND $impcode. XBRANCHES $impcode. XCNFULLYN $impcode. XCNOTHRYN $impcode. XCNPARTYN $impcode. XCNPRTLYN $impcode. XCNSUBYN $impcode. XCOLAUDA $impcode. XCOLAUDH $impcode. XCOLBKSA $impcode. XCOLBKSH $impcode. XCOLEBKSA $impcode. XCOLEBKSH $impcode. XCOLELREFA $impcode. XCOLELREFH $impcode. XCOLELYN $impcode. XCOLMICRA $impcode. XCOLMICRH $impcode. XCOLSERA $impcode. XCOLSERH $impcode. XCRGEN $impcode. XCRRSV $impcode. XDOCDEL $impcode. XDOCDIGYN $impcode. XEXAUD $impcode. XEXBIB $impcode. XEXBKS $impcode. XEXCOMP $impcode. XEXCUSER $impcode. XEXDEL $impcode. XEXELBKS $impcode. XEXELSER $impcode. XEXOTH $impcode. XEXOTHIR $impcode. XEXPRES $impcode. XEXTOT $impcode. XFRINGE $impcode. XFRINGEYN $impcode. XGATECT $impcode. XHOURS $impcode. XILPNON $impcode. XILPRET $impcode. XILPTOT $impcode. XILRNON $impcode. XILRRET $impcode. XILRTOT $impcode. XINFLITCOMYN $impcode. XINFLITDEFYN $impcode. XINFLITMISYN $impcode. XINFLITPLNYN $impcode. XLIBREFYN $impcode. XPRESEN $impcode. XREFTRANS $impcode. XSTASST $impcode. XSTLIBPRO $impcode. XSTLIBS $impcode. XSTOTH $impcode. XSTOTHPRO $impcode. XSTTOT $impcode. XSWASST $impcode. XSWLIBPRO $impcode. XSWOTH $impcode. XSWTOT $impcode. XTECHYN $impcode. XTHESYN $impcode. ZIP $mis_res. ; title "ALS_2004_P.2.A variable frequencies"; run; */ /* proc univariate; where cyparch NE '2'; var ATTEND BRANCHES COLAUDA COLAUDH COLBKSA COLBKSH COLEBKSA COLEBKSH COLELREFA COLELREFH COLMICRA COLMICRH COLSERA COLSERH CRGEN CRRSV DOCDEL EXAUD EXBIB EXBKS EXCOMP EXCUSER EXDEL EXELBKS EXELSER EXOTH EXOTHIR EXPRES EXTOT FRINGE FTEUSED GATECT HOURS ILPNON ILPRET ILPTOT ILRNON ILRRET ILRTOT PRESEN PCTMIN1 PCTMIN2 PCTMIN3 PCTMIN4 REFTRANS STASST STLIBPRO STLIBS STOTHPRO STOTH STTOT SWASST SWLIBPRO SWOTH SWTOT ; title "ALS_2004_P.2.A continuous variable univariate statistics"; run; */