**************************************************************************;
*** Created: Dec 2005                                                  ***;
*** Program Name: READ_ALS_2000_P.2.A.SAS                              ***;
*** Written by: Abe George, Kforce Government Solutions, Fairfax, VA   ***;
***                                                                    ***;
*** SAS code was written for SAS version 8.0 or above.  Labels were    ***;
*** given a maximum length of 60 characters. If you are using a SAS    ***;
*** version before SAS 8.0, you should be aware that labels could      ***;
*** be truncated to 40 characters.  If so, the user may wish to        ***;
*** abbreviate labels so that they are unique and are descriptive.     ***;
*** Format names are limited to 8 characters long.                     ***;
***                                                                    ***;
*** This program provides frequency for all variables.                 ***;
*** Users should uncomment the frequency section to generate frequency ***;
*** tables.                                                            ***;
***                                                                    ***;
*** There may be missing data for some institutions due to parent-     ***;
*** child relations.                                                   ***;
**************************************************************************;

*** change OUT1 directory to where you wish the permanent SAS data set to be located;

LIBNAME OUT1 'C:\ALS2000';  

data OUT1.ALS_2000_P2A
     (LABEL='ALS_2000 DATA FILE VERSION-P2A');

infile 'C:\ALS2000_INPUT\ALS_2000_P.2.A.TXT'
       missover lrecl=2980 dsd dlm='09'x firstobs=2;

informat
UNITID        $6.
INSTNM       $50.      
ADDR         $60.    
CITY         $20.
STABBR        $2.
ZIP           $9.
FIPS          $2.
OBEREG         2. 
EIN           $9. 
DUNS         $10. 
OPEID         $8. 
OPEFLAG        1.
WEBADDR      $50.
SECTOR         2.
ICLEVEL        2.
CONTROL        2.
AFFIL          2.
HLOFFER       $2.
UGOFFER        2.
GROFFER        2.
FPOFFER        2.
HDEGOFFR       2.
DEGGRANT       2.
PCTMIN1        2.
PCTMIN2        2.
PCTMIN3        2.
PCTMIN4        2.
HBCU           2.
HOSPITAL       2.
MEDICAL        2.
TRIBAL         2.
CARNEGIE       2.
LOCALE         2.
OPENPUBL       2.
ASSOCDEG       8.
BACHDEG        8.
MASTDEG        8. 
DOCTDEG        8.
PROFDEG        8. 
ACT           $1.
FORM          $2.
STATUS        $2. 
EDITSTATUS    $2.
IMPUTE        $2.
DATEFLAG      $8.
CYPARCH       $2.
UNITIDX       $6.
DATSRC        $2. 
REFUSAL       $2.
PARTAFLAG     $2.
PARTBFLAG     $2. 
PARTCFLAG     $2.
PARTDFLAG     $2.
PARTEFLAG     $2.
PARTFFLAG     $2.
LIBSHAR1      $6.
LIBNAME1     $50. 
LIBSHAR2      $6.
LIBNAME2     $50.
LIBSHAR3      $6.
LIBNAME3     $50. 
ELGCOLL       $2.
ELGSTAFF      $2.
ELGSCHED      $2.
ELGPHYS       $2. 
FINSUPP       $2.
XBRANCHES     $1.
BRANCHES       6. 
XSTLIBS       $1. 
STLIBS        10.
XSTOTHPRO     $1.
STOTHPRO      10.
XSTLIBPRO     $1.
STLIBPRO      10. 
XSTOTH        $1.
STOTH         10.
XSTCONSRV     $1.
STCONSRV      10.
XSTASST       $1.
STASST        10.
XSTTOT2000    $1.
STTOT2000     10.
XSWLIBPRO     $1.
SWLIBPRO      12.
XSWOTH        $1.
SWOTH         12.
XSWASST       $1.
SWASST        12.
XIRPAMICR     $1.
IRPAMICR      12.
XEXELBKS      $1.
EXELBKS       12.
XCUPAMICR     $1.
CUPAMICR      12.
XEXELSER      $1.
EXELSER       12.
XEXAUD        $1.
EXAUD         12.
XEXDEL        $1.
EXDEL         12.
XEXPRES       $1.
EXPRES        12.
XEXOTHIR      $1.
EXOTHIR       12.
XEXFUREQP     $1.
EXFUREQP      12.
XEXCOMP       $1.
EXCOMP        12.
XEXBIB        $1.
EXBIB         12.
XEXOTH2000    $1.
EXOTH2000     12.
XEXTOT        $1.
EXTOT         12.
FRINGEYN      $2.
XFRINGE       $1.
FRINGE        12.
XCOLBKSA      $1.
COLBKSA       12.
XCOLBKSH      $1.
COLBKSH       12.
XCOLBKPTA     $1.
COLBKPTA      12. 
XCOLBKPTH     $1.
COLBKPTH      12.
XCOLMICRA     $1.
COLMICRA      12.
XCOLMICRH     $1.
COLMICRH      12.
XCOLSERA      $1.
COLSERA       12.
XCOLSERH      $1.
COLSERH       12.
XCOLAUDA      $1.
COLAUDA       12.
XCOLAUDH      $1. 
COLAUDH       12.
XILPRET       $1.
ILPRET        12.
XILPNON       $1.
ILPNON        12.
XILPTOT       $1.
ILPTOT        12.
XILRRET       $1.
ILRRET        12.
XILRNON       $1.
ILRNON        12.
XILRTOT       $1.
ILRTOT        12.
XDOCDEL       $1.
DOCDEL        12.
XCIRTRANS     $1.
CIRTRANS      12.
XPRESEN       $1.
PRESEN        12.
XATTEND       $1.
ATTEND        12.
XHOURS        $1.
HOURS         12.
XGATECT       $1.
GATECT        12.
XREFTRANS     $1.
REFTRANS      12. 
ELCATYN       $2.
ELCATCMPYN    $2.
ELCATOCPYN    $2.
ELCATOCOYN    $2.
ELINDYN       $2.
ELINDCMPYN    $2.
ELINDOCPYN    $2.
ELINDOCOYN    $2.
ELPERYN       $2.
ELPERCMPYN    $2.
ELPEROCPYN    $2.
ELPEROCOYN    $2.
ELCRSYN       $2.
ELCRSCMPYN    $2.
ELCRSOCPYN    $2.
ELCRSOCOYN    $2.
DOCDIGYN      $2.
DOCDIGCMPYN   $2.
DOCDIGOCPYN   $2.
DOCDIGOCOYN   $2.
INETYN        $2.
INETCMPYN     $2.
INETOCPYN     $2.
INETOCOYN     $2.
LIBREFYN      $2.
LIBREFCMPYN   $2.
LIBREFOCPYN   $2.
LIBREFOCOYN   $2.
LOANREQYN     $2.
LOANREQCMPYN  $2.
LOANREQOCPYN  $2.
LOANREQOCOYN  $2.
TECHYN        $2.
TECHCMPYN     $2.
TECHOCPYN     $2.
TECHOCOYN     $2.
INSINETYN     $2.
INSINETCMPYN  $2.
INSINETOCPYN  $2.
INSINETOCOYN  $2.
ELDOCDELYN    $2.
ELDOCDELCMPYN $2.
ELDOCDELOCPYN $2.
ELDOCDELOCOYN $2.
VDOCONFYN     $2.
VDOCONFCMPYN  $2.
VDOCONFOCPYN  $2.
VDOCONFOCOYN  $2.
SATBRYN       $2.
SATBRCMPYN    $2.
SATBROCPYN    $2.
SATBROCOYN    $2.
COMPUTERYN    $2.
SOFTWAREYN    $2.
SCANNERYN     $2.
DISTEDYN      $2.
DISTEDSRVYN   $2.
CNSUBYN       $2.
CNPARTYN      $2.
CNFULLYN      $2.
CNPRTLYN      $2.
CNOTHRYN      $2.
FTUS9899       9.
FTGS9899       9.
PTUS9899       9.
PTGS9899       9.
TOTENR9899     9.
XTFTFAC9_10M  $1.
TFTFAC9_10M    9.
XTFTFAC11_12M $1.
TFTFAC11_12M   9.
XEXTOTE_G2000 $1.
EXTOTE_G2000  12. 
EXTOT2000     12.
XEXTOT2000    $1.
EXTOT2000B    12. 
XEXTOT2000B   $1.
;

input
UNITID       
INSTNM       
ADDR         
CITY         
STABBR       
ZIP          
FIPS         
OBEREG       
EIN          
DUNS         
OPEID        
OPEFLAG      
WEBADDR      
SECTOR       
ICLEVEL      
CONTROL      
AFFIL        
HLOFFER      
UGOFFER      
GROFFER      
FPOFFER      
HDEGOFFR     
DEGGRANT     
PCTMIN1      
PCTMIN2      
PCTMIN3      
PCTMIN4      
HBCU         
HOSPITAL     
MEDICAL      
TRIBAL       
CARNEGIE     
LOCALE       
OPENPUBL     
ASSOCDEG     
BACHDEG      
MASTDEG      
DOCTDEG      
PROFDEG      
ACT          
FORM         
STATUS       
EDITSTATUS   
IMPUTE       
DATEFLAG     
CYPARCH      
UNITIDX      
DATSRC       
REFUSAL      
PARTAFLAG    
PARTBFLAG    
PARTCFLAG    
PARTDFLAG    
PARTEFLAG    
PARTFFLAG    
LIBSHAR1     
LIBNAME1     
LIBSHAR2     
LIBNAME2     
LIBSHAR3     
LIBNAME3     
ELGCOLL      
ELGSTAFF     
ELGSCHED     
ELGPHYS      
FINSUPP      
XBRANCHES    
BRANCHES     
XSTLIBS      
STLIBS       
XSTOTHPRO    
STOTHPRO     
XSTLIBPRO    
STLIBPRO     
XSTOTH       
STOTH        
XSTCONSRV    
STCONSRV     
XSTASST      
STASST       
XSTTOT2000   
STTOT2000     
XSWLIBPRO    
SWLIBPRO     
XSWOTH       
SWOTH        
XSWASST      
SWASST       
XIRPAMICR    
IRPAMICR     
XEXELBKS     
EXELBKS      
XCUPAMICR    
CUPAMICR     
XEXELSER     
EXELSER      
XEXAUD       
EXAUD        
XEXDEL       
EXDEL        
XEXPRES      
EXPRES       
XEXOTHIR     
EXOTHIR      
XEXFUREQP    
EXFUREQP     
XEXCOMP      
EXCOMP       
XEXBIB       
EXBIB        
XEXOTH2000    
EXOTH2000    
XEXTOT       
EXTOT        
FRINGEYN     
XFRINGE      
FRINGE       
XCOLBKSA     
COLBKSA      
XCOLBKSH     
COLBKSH      
XCOLBKPTA    
COLBKPTA     
XCOLBKPTH    
COLBKPTH     
XCOLMICRA    
COLMICRA     
XCOLMICRH    
COLMICRH     
XCOLSERA     
COLSERA      
XCOLSERH     
COLSERH      
XCOLAUDA     
COLAUDA      
XCOLAUDH     
COLAUDH      
XILPRET      
ILPRET       
XILPNON      
ILPNON       
XILPTOT      
ILPTOT       
XILRRET      
ILRRET       
XILRNON      
ILRNON       
XILRTOT      
ILRTOT       
XDOCDEL      
DOCDEL       
XCIRTRANS    
CIRTRANS     
XPRESEN      
PRESEN       
XATTEND      
ATTEND       
XHOURS       
HOURS        
XGATECT      
GATECT       
XREFTRANS    
REFTRANS     
ELCATYN      
ELCATCMPYN   
ELCATOCPYN   
ELCATOCOYN   
ELINDYN      
ELINDCMPYN   
ELINDOCPYN   
ELINDOCOYN   
ELPERYN      
ELPERCMPYN   
ELPEROCPYN   
ELPEROCOYN   
ELCRSYN      
ELCRSCMPYN   
ELCRSOCPYN   
ELCRSOCOYN   
DOCDIGYN     
DOCDIGCMPYN  
DOCDIGOCPYN  
DOCDIGOCOYN  
INETYN       
INETCMPYN    
INETOCPYN    
INETOCOYN    
LIBREFYN     
LIBREFCMPYN  
LIBREFOCPYN  
LIBREFOCOYN  
LOANREQYN    
LOANREQCMPYN 
LOANREQOCPYN 
LOANREQOCOYN 
TECHYN       
TECHCMPYN    
TECHOCPYN    
TECHOCOYN    
INSINETYN    
INSINETCMPYN 
INSINETOCPYN 
INSINETOCOYN 
ELDOCDELYN   
ELDOCDELCMPYN
ELDOCDELOCPYN
ELDOCDELOCOYN
VDOCONFYN    
VDOCONFCMPYN 
VDOCONFOCPYN 
VDOCONFOCOYN 
SATBRYN      
SATBRCMPYN   
SATBROCPYN   
SATBROCOYN   
COMPUTERYN   
SOFTWAREYN   
SCANNERYN    
DISTEDYN     
DISTEDSRVYN  
CNSUBYN      
CNPARTYN     
CNFULLYN     
CNPRTLYN     
CNOTHRYN     
FTUS9899     
FTGS9899     
PTUS9899     
PTGS9899     
TOTENR9899   
XTFTFAC9_10M 
TFTFAC9_10M  
XTFTFAC11_12M
TFTFAC11_12M 
XEXTOTE_G2000
EXTOTE_G2000 
EXTOT2000    
XEXTOT2000   
EXTOT2000B   
XEXTOT2000B  
;

label
UNITID        = 'Unit Id Number for the Institution'   
INSTNM        = 'Institution Name'   
ADDR          = 'Street address or post office box'    
CITY          = 'Institution City'   
STABBR        = 'State Abbreviation Code'   
ZIP           = 'Postal Zip code PLUS 4'   
FIPS          = 'FIPS state code'   
OBEREG        = 'OBE Region Code'  
EIN           = 'Employer Id Number'   
DUNS          = 'Dunn and Bradstreet Id Number'  
OPEID         = 'Office of Post Sec Education Id'   
OPEFLAG       = 'OPE Eligibility Indicator'   
WEBADDR       = 'Institutions Web Address' 
SECTOR        = 'Sector of Institution'    
ICLEVEL       = 'Level of Institution'   
CONTROL       = 'Control of Institution'   
AFFIL         = 'Affiliation 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'   
PCTMIN2       = 'Percent American Indian/Alaskan Native'  
PCTMIN3       = 'Percent Asian/Pacific Islander'   
PCTMIN4       = 'Percent Hispanic'   
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'   
ASSOCDEG      = 'Total number of associate�s degrees from Completions'   
BACHDEG       = 'Total number of bachelor�s degrees from Completions'   
MASTDEG       = 'Total number of master�s degrees from Completions'   
DOCTDEG       = 'Total number of doctor�s degrees from Completions'   
PROFDEG       = 'Total number of first prof degrees from Completions'  
ACT           = 'Status of institution'   
FORM          = 'Survey form'  
STATUS        = 'Response status of the institution' 
EDITSTATUS    = 'Edit status of the institution'
IMPUTE        = 'Impute status of the institution'       
DATEFLAG      = 'The most recent date the record was edited or imputed'     
CYPARCH       = 'Parent/child indicator'      
UNITIDX       = 'UNITID number of parent institution'      
DATSRC        = 'Medium used to collect data'       
REFUSAL       = 'Refusal status of the institution'    
PARTAFLAG     = 'Imputation status of Part A' 
PARTBFLAG     = 'Imputation status of Part B'
PARTCFLAG     = 'Imputation status of Part C'
PARTDFLAG     = 'Imputation status of Part D'
PARTEFLAG     = 'Imputation status of Part E'
PARTFFLAG     = 'Imputation status of Part F' 
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'     
ELGCOLL       = 'Institution has organized collection of materials'    
ELGSTAFF      = 'Institution has trained staff'    
ELGSCHED      = 'Institution has established schedule'     
ELGPHYS       = 'Institution has physical facilities for collection'      
FINSUPP       = 'Institution provides financial support to another'      
XBRANCHES     = 'Status Flag - BRANCES'   
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'  
XSTCONSRV     = 'Status Flag - STCONSRV'  
STCONSRV      = 'Contributed services staff'   
XSTASST       = 'Status Flag - STASST'   
STASST        = 'Student Assistants'   
XSTTOT2000    = 'Status Flag - STTOT2000'   
STTOT2000     = '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'   
XIRPAMICR     = 'Status Flag - IRPAMICR'    
IRPAMICR      = 'Expenditures for books - paper and microform'   
XEXELBKS      = 'Status Flag - EXELBKS'   
EXELBKS       = 'Expenditure - Electronic Books'   
XCUPAMICR     = 'Status Flag - CUPAMICR'   
CUPAMICR      = 'Expenditures for current serials: paper and microform'   
XEXELSER      = 'Status Flag - EXELSER'   
EXELSER       = 'Expenditures for current serials: electronic'   
XEXAUD        = 'Status Flag - EXAUD'    
EXAUD         = 'Expenditures for audiovisual materials'    
XEXDEL        = 'Status Flag - EXDEL'    
EXDEL         = 'Expenditures for document delivery/interlibrary loan'   
XEXPRES       = 'Status Flag - EXPRES'    
EXPRES        = 'Expenditures for preservation'    
XEXOTHIR      = 'Status Flag - EXOTHIR'    
EXOTHIR       = 'Expenditures for other materials'   
XEXFUREQP     = 'Status Flag - EXFUREQP'   
EXFUREQP      = 'Expenditures for furniture and equipment'     
XEXCOMP       = 'Status Flag - EXCOMP'     
EXCOMP        = 'Expenditures for computer hardware and software'      
XEXBIB        = 'Status Flag - EXBIB'      
EXBIB         = 'Exp for bibliographic utilities, networks, and consortia'       
XEXOTH2000    = 'Status Flag - EXOTH2000'    
EXOTH2000     = 'All other operating expenditures'     
XEXTOT        = 'Status Flag - EXTOT'      
EXTOT         = 'Total expenditures'       
FRINGEYN      = 'Employee fringe benefits paid from library budget'     
XFRINGE       = 'Status Flag - FRINGE'      
FRINGE        = 'Exp from library budget for employee fringe benefits'      
XCOLBKSA      = 'Status Flag - COLBKSA'    
COLBKSA       = 'Number of volumes (books-paper) added'     
XCOLBKSH      = 'Status Flag - COLBKSH'     
COLBKSH       = 'Number of volumes (books-paper) held'     
XCOLBKPTA     = 'Status Flag - COLBKPTA'    
COLBKPTA      = 'Number of titles (books-paper) added'    
XCOLBKPTH     = 'Status Flag - COLBKPTH'   
COLBKPTH      = 'Number of titles (books-paper) held'    
XCOLMICRA     = 'Status Flag - COLMICRA'    
COLMICRA      = 'Number of units (books-microforms) added'    
XCOLMICRH     = 'Status Flag - COLMICRH'   
COLMICRH      = 'Number of units (books-microforms) held'    
XCOLSERA      = 'Status Flag - COLSERA'    
COLSERA       = 'Number of units (current serial subscriptions) added'     
XCOLSERH      = 'Status Flag - COLSERH'     
COLSERH       = 'Number of units (current serial subscriptions) held'     
XCOLAUDA      = 'Status Flag - COLAUDA'     
COLAUDA       = 'Number of units (audiovisual materials) added'     
XCOLAUDH      = 'Status Flag - COLAUDH'     
COLAUDH       = 'Number of units (audiovisual materials) held'     
XILPRET       = 'Status Flag - ILPRET'      
ILPRET        = 'Interlib loans to othr lib-returnable'
XILPNON       = 'Status Flag - ILPNON'      
ILPNON        = 'Interlib loans to othr lib-non-return'      
XILPTOT       = 'Status Flag - ILPTOT'     
ILPTOT        = 'Interlib loans to othr lib-total'      
XILRRET       = 'Status Flag - ILRRET'     
ILRRET        = 'Interlib loans from othr lib-returnable'      
XILRNON       = 'Status Flag - ILRNON'      
ILRNON        = 'Interlib loans from othr lib-non-return'      
XILRTOT       = 'Status Flag - ILRTOT'      
ILRTOT        = 'Interlib loans from othr lib-total'      
XDOCDEL       = 'Status Flag - DOCDEL'     
DOCDEL        = 'Documents delivered from commercial services'      
XCIRTRANS     = 'Status Flag - CIRTRANS'    
CIRTRANS      = 'Circulation transactions'    
XPRESEN       = 'Status Flag - PRESEN'      
PRESEN        = 'Number of presentations during the fiscal year'      
XATTEND       = 'Status Flag - ATTEND'      
ATTEND        = 'Total attendance at all 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'    
ELCATYN       = 'Access of elec catalog from within the library'    
ELCATCMPYN    = 'Access of elec catalog from elsewhere on campus'  
ELCATOCPYN    = 'Access of elec catalog from off campus by primary clientele'  
ELCATOCOYN    = 'Access of elec catalog from off campus by others'  
ELINDYN       = 'Acc elec index & ref tools w/in lib'  
ELINDCMPYN    = 'Acc elec index & ref tool else on cmp'  
ELINDOCPYN    = 'Acc elec index & ref tool off cmp-prmry'  
ELINDOCOYN    = 'Acc elec index & ref tool off cmp-oth'   
ELPERYN       = 'Acc elec full text periodical w/in lib'     
ELPERCMPYN    = 'Acc elec full text period. else on cmp'  
ELPEROCPYN    = 'Acc elec full text period. off cmp-prm'   
ELPEROCOYN    = 'Acc elec full text period. off cmp-oth'   
ELCRSYN       = 'Acc elec full text course res w/in lib'     
ELCRSCMPYN    = 'Acc elec fl txt course res else on cmp'   
ELCRSOCPYN    = 'Acc elec fl txt course res off cmp-prm'   
ELCRSOCOYN    = 'Acc elec fl txt course res off cmp-oth'   
DOCDIGYN      = 'Acc elec files(not ctlg) w/in lib'    
DOCDIGCMPYN   = 'Acc elec files(not ctlg) else on cmpus'  
DOCDIGOCPYN   = 'Acc elec files(not ctlg) off cmpus-prm'  
DOCDIGOCOYN   = 'Acc elec files(not ctlg) off cmpus-oth'  
INETYN        = 'Internet access from within the library'      
INETCMPYN     = 'Internet access from elsewhere on campus'   
INETOCPYN     = 'Internet access from off campus by primary clientele'    
INETOCOYN     = 'Internet access from off campus by others'   
LIBREFYN      = 'Lib ref serv by email w/in library'    
LIBREFCMPYN   = 'Lib ref serv by email else on campus'  
LIBREFOCPYN   = 'Lib ref serv by email off campus-prim'  
LIBREFOCOYN   = 'Lib ref serv by email off campus-othr'  
LOANREQYN     = 'Interlib loan req elec w/in library'   
LOANREQCMPYN  = 'Interlib loan req elec else on campus'
LOANREQOCPYN  = 'Interlib loan req elec off campus-prim' 
LOANREQOCOYN  = 'Interlib loan req elec off campus-othr' 
TECHYN        = 'Tech to asst patrons w/disabil w/in lib'      
TECHCMPYN     = 'Tech to asst ptrns w/disabil else on cmp'    
TECHOCPYN     = 'Tech to asst ptrns w/disabil off cmp-prm'    
TECHOCOYN     = 'Tech to asst ptrns w/disabil off cmp-oth'    
INSINETYN     = 'Instr by lib stf-internet w/in lib'    
INSINETCMPYN  = 'Instr by lib stf-internet else on cmp' 
INSINETOCPYN  = 'Instr by lib stf-internet off cmp-prm' 
INSINETOCOYN  = 'Instr by lib stf-internet off cmp-oth' 
ELDOCDELYN    = 'Elec doc deliv-lib to acct w/in lib'   
ELDOCDELCMPYN = 'Elec doc deliv-lib to acct else on cmp'
ELDOCDELOCPYN = 'Elec doc deliv-lib to acct off cmp-prm'
ELDOCDELOCOYN = 'Elec doc deliv-lib to acct off cmp-oth'
VDOCONFYN     = 'Video/desktop conf for lib w/in lib'    
VDOCONFCMPYN  = 'Video/desktop conf for lib else on cmp' 
VDOCONFOCPYN  = 'Video/desktop conf for lib off cmp-prm' 
VDOCONFOCOYN  = 'Video/desktop conf for lib off cmp-oth' 
SATBRYN       = 'Satellite broadcast for lib w/in lib'     
SATBRCMPYN    = 'Satellite broadcast for lib-else on cmp'   
SATBROCPYN    = 'Satellite broadcast for lib-off cmp-prm'   
SATBROCOYN    = 'Satellite broadcast for lib-off cmp-oth'   
COMPUTERYN    = 'Computers for patron use in library'   
SOFTWAREYN    = 'Computer software for patron use in the library'   
SCANNERYN     = 'Scanning equipment for patron use in the library'    
DISTEDYN      = 'Institution has distance education students'    
DISTEDSRVYN   = 'Services to your institution�s distance education students'  
CNSUBYN       = 'Subsidized consortium-access to elec res'      
CNPARTYN      = 'Library participates in the consortium'     
CNFULLYN      = 'Cost of library�s participation fully funded by the state'     
CNPRTLYN      = 'Library�s participation partially funded by the state'     
CNOTHRYN      = 'Participate in other consortia-elec res'     
FTUS9899      = 'Full-time undergraduate students 1998-99'     
FTGS9899      = 'Full-time graduate students 1998-99'     
PTUS9899      = 'Part-time undergraduate students 1998-99'     
PTGS9899      = 'Part-time graduate students 1998-99'     
TOTENR9899    = 'Total enrollment 1998-99'   
XTFTFAC9_10M  = 'Status flag - TFTFAC9_10M' 
TFTFAC9_10M   = 'Total FT faculty on 9/10 month contract' 
XTFTFAC11_12M = 'Status flag - TFTFAC11_12M' 
TFTFAC11_12M  = 'Total FT faculty on 11/12 month contract' 
XEXTOTE_G2000 = 'Status flag - EXTOTE_G2000'
EXTOTE_G2000  = 'Total educational & general expenditures 2000' 
EXTOT2000     = 'Total expenses 2000'   
XEXTOT2000    = 'Status flag - EXTOT2000'   
EXTOT2000B    = 'Total expenses 2000'   
XEXTOT2000B   = 'Status flag - EXTOT2000B';

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 affil
			1="1 Public"
			2="2 Private for-profit"
			3="3 Private nonprofit, no religious affiliation"
			4="4 Private nonprofit"
			-3="-3 Not Available";
value carnegie
			11="11 Research universities I"
			12="12 Research universities II"
			13="13 Doctoral universities I"
			14="14 Doctoral universities II"
			21="21 Masters comprehensive I"
			22="22 Masters comprehensive II"
			31="31 BA liberal arts colleges I"
			32="32 Baccalaureate colleges II"
			40="40 Associate of Arts College"
			51="51 Theological seminaries"
			52="52 Medical schools"
			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"
			-2="-2 Not Applicable"
			-3="-3 Not Available";
value $cn
			"1"="1 YES"
			"2"="2 NO"
			"-1"="-1 Not Reported"
			"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 record (combined data)"
			"2"="2 Child record , no data"
			"-2"="-2 Not Applicable";
value $datsrc
			"1"="1 Internet (FTP/WWW)"
			"2"="2 Tape"
			"3"="3 Diskette"
			"4"="4 Form"
			"5"="5 Form Facsimile"
			"6"="6 Postsecondary Education Telephone System (PETS)"
			"7"="7 Other"
			"-2"="-2 Not Applicable";
value $editst
			"1"="1 Passed edits"
			"2"="2 Edit flags remain, analyst accepted"
			"3"="3 Edit flags remain, NCES accepted"
			"4"="4 Edit flags remain"
			"5"="5 Failed the edits"
			"-2"="-2 Not Applicable";
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 $form
			"L"="L Academic Libraries"
			"-2"="-2 Not Applicable";
value fpoffer
			1="1 First professional degree or first professional certificate"
			2="2 No first professional offering"
			-3="-3 Not available";
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 Postsec. award, certificate/diploma-less than one academic year"
			"2"="2 Postsec. award, certificate/diploma-one to two academic years"
			"3"="3 Associate degree"
			"4"="4 Postsec. award, certificate/diploma-two to 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"
			"b"="b None of the above or No answer"
			"-2"="-2 Not applicable, first professional only"
			"-3"="-3 Not available";
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"
			"H"="H Data Suppressed"
			"I"="I Imputation for previous nonresponse cell, non-prior year method"
			"N"="N Original data field was blank"
			"P"="P Imputation for previous nonresponse cell, using prior year data"
			"R"="R Original data value was reported"
			"T"="T Total adjusted to equal the sum of detail"
			"Z"="Z Implied reported zero value"
			" "="Blank Value";
value $impute
			"1"="1 At least one part is imputed"
			"-2"="-2 Not Applicable";
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"
			"b"="b 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 Institition is eligible for Title IV aid"
			2="2 Not eligible separately but branch of an eligible campus"
			3="3 Eligible for Title IV aid, but for deferment only"
			4="4 Eligible for Title IV aid, but not in-scope of IPEDS"
			5="5 Not currently eligible"
			6="6 Institution is not eligible and not listed on Title IV file";
value $partaf
			"1"="1 Imputed, using current year mean average"
			"2"="2 Imputed, using institution's prior year data"
			"9"="9 Partial Impute"
			"-2"="-2 Not Applicable";
value $partbf
			"1"="1 Imputed, using current year mean average"
			"2"="2 Imputed, using institution's prior year data"
			"3"="3 Imputed, using institution's current part b data"
			"9"="9 Partial Impute"
			"-2"="-2 Not Applicable";
value $partcf
			"1"="1 Imputed, using current year mean average"
			"2"="2 Imputed, using institution's prior year data"
			"3"="3 Imputed, using institution's current part c data"
			"9"="9 Partial Impute"
			"-2"="-2 Not Applicable";
value $partdf
			"1"="1 Imputed, using current year mean average"
			"2"="2 Imputed, using institution's prior year data"
			"9"="9 Partial Impute"
			"-2"="-2 Not Applicable";
value $partef
			"1"="1 Imputed, using current year mean average"
			"2"="2 Imputed, using institution's prior year data"
			"9"="9 Partial Impute"
			"-2"="-2 Not Applicable";
value $partff
			"1"="1 Imputed, using current year mean average"
			"2"="2 Imputed, using institution's prior year data"
			"9"="9 Partial Impute"
			"-2"="-2 Not Applicable";
value $refusal
			"1"="Refused to provide data"
			"-2"="-2 Not Applicable";
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 Mailed, response"
			"3"="3 Mailed, nonresponse, not imputed"
			"4"="4 Mailed, nonresponse, imputed"
			"5"="5 Mailed, nonresponse, out-of-scope, not imputed"
			"6"="6 Nonrespondent to data (in-scope), not imputed"
			"-2"="-2 Not Applicable";
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"
			"N"="N No response"
			"-1"="-1 Not Reported"
			"-2"="-2 Not Applicable";
value yes_no
			1="1 YES"
			2="2 NO"
			-1="-1 Not Reported"
			-3="-3 Not Available";
run;

*******************************************************************;
*** Listed below are all the variables in alphabetical order.   ***;
*** Corresponding to each variable name, the format name to be  ***;
*** used is listed.                                             ***;
*******************************************************************;
/*
ACT          $act.
ADDR         $mis_res.
AFFIL        affil.
ASSOCDEG     mis_res.
ATTEND       mis_res.
BACHDEG      mis_res.
BRANCHES     mis_res.
CARNEGIE     carnegie.
CIRTRANS     mis_res.
CITY         $mis_res.
CNFULLYN     $cn.
CNOTHRYN     $cn.
CNPARTYN     $cn.
CNPRTLYN     $cn.
CNSUBYN      $cn.
COLAUDA      mis_res.
COLAUDH      mis_res.
COLBKPTA     mis_res.
COLBKPTH     mis_res.
COLBKSA      mis_res.
COLBKSH      mis_res.
COLMICRA     mis_res.
COLMICRH     mis_res.
COLSERA      mis_res.
COLSERH      mis_res.
COMPUTERYN   $yes_no.
CONTROL      control.
CUPAMICR     mis_res.
CYPARCH      $cyparch.
DATEFLAG     $mis_res.
DATSRC       $datsrc.
DEGGRANT     yes_no.
DISTEDSRVYN  $yes_no.
DISTEDYN     $yes_no.
DOCDEL       mis_res.
DOCDIGCMPYN  $yes_no.
DOCDIGOCOYN  $yes_no.
DOCDIGOCPYN  $yes_no.
DOCDIGYN     $yes_no.
DOCTDEG      mis_res.
DUNS         $mis_res.
EDITSTATUS   $editst.
EIN          $mis_res.
ELCATCMPYN   $yes_no.
ELCATOCOYN   $yes_no.
ELCATOCPYN   $yes_no.
ELCATYN      $yes_no.
ELCRSCMPYN   $yes_no.
ELCRSOCOYN   $yes_no.
ELCRSOCPYN   $yes_no.
ELCRSYN      $yes_no.
ELDOCDELCMPYN $yes_no.
ELDOCDELOCOYN $yes_no.
ELDOCDELOCPYN $yes_no.
ELDOCDELYN   $yes_no.
ELGCOLL      $yes_no.
ELGPHYS      $yes_no.
ELGSCHED     $yes_no.
ELGSTAFF     $yes_no.
ELINDCMPYN   $yes_no.
ELINDOCOYN   $yes_no.
ELINDOCPYN   $yes_no.
ELINDYN      $yes_no.
ELPERCMPYN   $yes_no.
ELPEROCOYN   $yes_no.
ELPEROCPYN   $yes_no.
ELPERYN      $yes_no.
EXAUD        mis_res.
EXBIB        mis_res.
EXCOMP       mis_res.
EXDEL        mis_res.
EXELBKS      mis_res.
EXELSER      mis_res.
EXFUREQP     mis_res.
EXOTHIR      mis_res.
EXOTH2000    mis_res.
EXPRES       mis_res.
EXTOT        mis_res.
EXTOT2000    mis_res.
EXTOT2000B   mis_res.
EXTOTE_G2000 mis_res.
FINSUPP      $yes_no.
FIPS         $fips.
FORM         $form.
FPOFFER      fpoffer.
FRINGE       mis_res.
FRINGEYN     $yes_no.
FTGS9899     mis_res.
FTUS9899     mis_res.
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.
IMPUTE       $impute.
INETCMPYN    $yes_no.
INETOCOYN    $yes_no.
INETOCPYN    $yes_no.
INETYN       $yes_no.
INSINETCMPYN $yes_no.
INSINETOCOYN $yes_no.
INSINETOCPYN $yes_no.
INSINETYN    $yes_no.
INSTNM       $mis_res.
IRPAMICR     mis_res.
LIBNAME1     $mis_res.
LIBNAME2     $mis_res.
LIBNAME3     $mis_res.
LIBREFCMPYN  $yes_no.
LIBREFOCOYN  $yes_no.
LIBREFOCPYN  $yes_no.
LIBREFYN     $yes_no.
LIBSHAR1     $mis_res.
LIBSHAR2     $mis_res.
LIBSHAR3     $mis_res.
LOANREQCMPYN $yes_no.
LOANREQOCOYN $yes_no.
LOANREQOCPYN $yes_no.
LOANREQYN    $yes_no.
LOCALE       locale.
MASTDEG      mis_res.
MEDICAL      yes_no.
OBEREG       obereg.
OPEFLAG      opeflag.
OPEID        $mis_res.
OPENPUBL     yes_no.
PARTAFLAG    $partaf.
PARTBFLAG    $partbf.
PARTCFLAG    $partcf.
PARTDFLAG    $partdf.
PARTEFLAG    $partef.
PARTFFLAG    $partff.
PCTMIN1      mis_res.
PCTMIN2      mis_res.
PCTMIN3      mis_res.
PCTMIN4      mis_res.
PRESEN       mis_res.
PROFDEG      mis_res.
PTGS9899     mis_res.
PTUS9899     mis_res.
REFTRANS     mis_res.
REFUSAL      $refusal.
SATBRCMPYN   $yes_no.
SATBROCOYN   $yes_no.
SATBROCPYN   $yes_no.
SATBRYN      $yes_no.
SCANNERYN    $yes_no.
SECTOR       sector.
SOFTWAREYN   $yes_no.
STABBR       $stabbr.
STASST       mis_res.
STATUS       $status.
STCONSRV     mis_res.
STLIBPRO     mis_res.
STLIBS       mis_res.
STOTH        mis_res.
STOTHPRO     mis_res.
STTOT2000    mis_res.
SWASST       mis_res.
SWLIBPRO     mis_res.
SWOTH        mis_res.
TECHCMPYN    $yes_no.
TECHOCOYN    $yes_no.
TECHOCPYN    $yes_no.
TECHYN       $yes_no.
TFTFAC11_12M mis_res.
TFTFAC9_10M  mis_res.
TOTENR9899   mis_res.
TRIBAL       yes_no.
UGOFFER      ugoffer.
UNITID       $mis_res.
UNITIDX      $mis_res.
VDOCONFCMPYN $yes_no.
VDOCONFOCOYN $yes_no.
VDOCONFOCPYN $yes_no.
VDOCONFYN    $yes_no.
WEBADDR      $mis_res.
XATTEND      $impcode.
XBRANCHES    $impcode.
XCIRTRANS    $impcode.
XCOLAUDA     $impcode.
XCOLAUDH     $impcode.
XCOLBKPTA    $impcode.
XCOLBKPTH    $impcode.
XCOLBKSA     $impcode.
XCOLBKSH     $impcode.
XCOLMICRA    $impcode.
XCOLMICRH    $impcode.
XCOLSERA     $impcode.
XCOLSERH     $impcode.
XCUPAMICR    $impcode.
XDOCDEL      $impcode.
XEXAUD       $impcode.
XEXBIB       $impcode.
XEXCOMP      $impcode.
XEXDEL       $impcode.
XEXELBKS     $impcode.
XEXELSER     $impcode.
XEXFUREQP    $impcode.
XEXOTHIR     $impcode.
XEXOTH2000   $impcode.
XEXPRES      $impcode.
XEXTOT       $impcode.
XEXTOT2000   $impcode.
XEXTOT2000B  $impcode.
XEXTOTE_G2000 $impcode.
XFRINGE      $impcode.
XGATECT      $impcode.
XHOURS       $impcode.
XILPNON      $impcode.
XILPRET      $impcode.
XILPTOT      $impcode.
XILRNON      $impcode.
XILRRET      $impcode.
XILRTOT      $impcode.
XIRPAMICR    $impcode.
XPRESEN      $impcode.
XREFTRANS    $impcode.
XSTASST      $impcode.
XSTCONSRV    $impcode.
XSTLIBPRO    $impcode.
XSTLIBS      $impcode.
XSTOTH       $impcode.
XSTOTHPRO    $impcode.
XSTTOT2000   $impcode.
XSWASST      $impcode.
XSWLIBPRO    $impcode.
XSWOTH       $impcode.
XTFTFAC11_12M $impcode.
XTFTFAC9_10M $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 data=OUT1.ALS_2000_P2A;
tables 
ACT          
ADDR         
AFFIL        
ASSOCDEG     
ATTEND       
BACHDEG      
BRANCHES     
CARNEGIE     
CIRTRANS     
CITY         
CNFULLYN     
CNOTHRYN     
CNPARTYN     
CNPRTLYN     
CNSUBYN      
COLAUDA      
COLAUDH      
COLBKPTA     
COLBKPTH     
COLBKSA      
COLBKSH      
COLMICRA     
COLMICRH     
COLSERA      
COLSERH      
COMPUTERYN   
CONTROL      
CUPAMICR     
CYPARCH      
DATEFLAG     
DATSRC       
DEGGRANT     
DISTEDSRVYN  
DISTEDYN     
DOCDEL       
DOCDIGCMPYN  
DOCDIGOCOYN  
DOCDIGOCPYN  
DOCDIGYN     
DOCTDEG      
DUNS         
EDITSTATUS   
EIN          
ELCATCMPYN   
ELCATOCOYN   
ELCATOCPYN   
ELCATYN      
ELCRSCMPYN   
ELCRSOCOYN   
ELCRSOCPYN   
ELCRSYN      
ELDOCDELCMPYN
ELDOCDELOCOYN
ELDOCDELOCPYN
ELDOCDELYN   
ELGCOLL      
ELGPHYS      
ELGSCHED     
ELGSTAFF     
ELINDCMPYN   
ELINDOCOYN   
ELINDOCPYN   
ELINDYN      
ELPERCMPYN   
ELPEROCOYN   
ELPEROCPYN   
ELPERYN      
EXAUD        
EXBIB        
EXCOMP       
EXDEL        
EXELBKS      
EXELSER      
EXFUREQP     
EXOTHIR      
EXOTH2000     
EXPRES       
EXTOT        
EXTOT2000    
EXTOT2000B   
EXTOTE_G2000 
FINSUPP      
FIPS         
FORM         
FPOFFER      
FRINGE       
FRINGEYN     
FTGS9899     
FTUS9899     
GATECT       
GROFFER      
HBCU         
HDEGOFFR     
HLOFFER      
HOSPITAL     
HOURS        
ICLEVEL      
ILPNON       
ILPRET       
ILPTOT       
ILRNON       
ILRRET       
ILRTOT       
IMPUTE       
INETCMPYN    
INETOCOYN    
INETOCPYN    
INETYN       
INSINETCMPYN 
INSINETOCOYN 
INSINETOCPYN 
INSINETYN    
INSTNM       
IRPAMICR     
LIBNAME1     
LIBNAME2     
LIBNAME3     
LIBREFCMPYN  
LIBREFOCOYN  
LIBREFOCPYN  
LIBREFYN     
LIBSHAR1     
LIBSHAR2     
LIBSHAR3     
LOANREQCMPYN 
LOANREQOCOYN 
LOANREQOCPYN 
LOANREQYN    
LOCALE       
MASTDEG      
MEDICAL      
OBEREG       
OPEFLAG      
OPEID        
OPENPUBL     
PARTAFLAG    
PARTBFLAG    
PARTCFLAG    
PARTDFLAG    
PARTEFLAG    
PARTFFLAG    
PCTMIN1      
PCTMIN2      
PCTMIN3      
PCTMIN4      
PRESEN       
PROFDEG      
PTGS9899     
PTUS9899     
REFTRANS     
REFUSAL      
SATBRCMPYN   
SATBROCOYN   
SATBROCPYN   
SATBRYN      
SCANNERYN    
SECTOR       
SOFTWAREYN   
STABBR       
STASST       
STATUS       
STCONSRV     
STLIBPRO     
STLIBS       
STOTH        
STOTHPRO     
STTOT2000     
SWASST       
SWLIBPRO     
SWOTH        
TECHCMPYN    
TECHOCOYN    
TECHOCPYN    
TECHYN       
TFTFAC11_12M 
TFTFAC9_10M  
TOTENR9899   
TRIBAL       
UGOFFER      
UNITID       
UNITIDX      
VDOCONFCMPYN 
VDOCONFOCOYN 
VDOCONFOCPYN 
VDOCONFYN    
WEBADDR      
XATTEND      
XBRANCHES    
XCIRTRANS    
XCOLAUDA     
XCOLAUDH     
XCOLBKPTA    
XCOLBKPTH    
XCOLBKSA     
XCOLBKSH     
XCOLMICRA    
XCOLMICRH    
XCOLSERA     
XCOLSERH     
XCUPAMICR    
XDOCDEL      
XEXAUD       
XEXBIB       
XEXCOMP      
XEXDEL       
XEXELBKS     
XEXELSER     
XEXFUREQP    
XEXOTHIR     
XEXOTH2000    
XEXPRES      
XEXTOT       
XEXTOT2000   
XEXTOT2000B  
XEXTOTE_G2000
XFRINGE      
XGATECT      
XHOURS       
XILPNON      
XILPRET      
XILPTOT      
XILRNON      
XILRRET      
XILRTOT      
XIRPAMICR    
XPRESEN      
XREFTRANS    
XSTASST      
XSTCONSRV    
XSTLIBPRO    
XSTLIBS      
XSTOTH       
XSTOTHPRO    
XSTTOT2000   
XSWASST      
XSWLIBPRO    
XSWOTH       
XTFTFAC11_12M
XTFTFAC9_10M 
ZIP / missing
;

format
ACT          $act.
ADDR         $mis_res.
AFFIL        affil.
ASSOCDEG     mis_res.
ATTEND       mis_res.
BACHDEG      mis_res.
BRANCHES     mis_res.
CARNEGIE     carnegie.
CIRTRANS     mis_res.
CITY         $mis_res.
CNFULLYN     $cn.
CNOTHRYN     $cn.
CNPARTYN     $cn.
CNPRTLYN     $cn.
CNSUBYN      $cn.
COLAUDA      mis_res.
COLAUDH      mis_res.
COLBKPTA     mis_res.
COLBKPTH     mis_res.
COLBKSA      mis_res.
COLBKSH      mis_res.
COLMICRA     mis_res.
COLMICRH     mis_res.
COLSERA      mis_res.
COLSERH      mis_res.
COMPUTERYN   $yes_no.
CONTROL      control.
CUPAMICR     mis_res.
CYPARCH      $cyparch.
DATEFLAG     $mis_res.
DATSRC       $datsrc.
DEGGRANT     yes_no.
DISTEDSRVYN  $yes_no.
DISTEDYN     $yes_no.
DOCDEL       mis_res.
DOCDIGCMPYN  $yes_no.
DOCDIGOCOYN  $yes_no.
DOCDIGOCPYN  $yes_no.
DOCDIGYN     $yes_no.
DOCTDEG      mis_res.
DUNS         $mis_res.
EDITSTATUS   $editst.
EIN          $mis_res.
ELCATCMPYN   $yes_no.
ELCATOCOYN   $yes_no.
ELCATOCPYN   $yes_no.
ELCATYN      $yes_no.
ELCRSCMPYN   $yes_no.
ELCRSOCOYN   $yes_no.
ELCRSOCPYN   $yes_no.
ELCRSYN      $yes_no.
ELDOCDELCMPYN $yes_no.
ELDOCDELOCOYN $yes_no.
ELDOCDELOCPYN $yes_no.
ELDOCDELYN   $yes_no.
ELGCOLL      $yes_no.
ELGPHYS      $yes_no.
ELGSCHED     $yes_no.
ELGSTAFF     $yes_no.
ELINDCMPYN   $yes_no.
ELINDOCOYN   $yes_no.
ELINDOCPYN   $yes_no.
ELINDYN      $yes_no.
ELPERCMPYN   $yes_no.
ELPEROCOYN   $yes_no.
ELPEROCPYN   $yes_no.
ELPERYN      $yes_no.
EXAUD        mis_res.
EXBIB        mis_res.
EXCOMP       mis_res.
EXDEL        mis_res.
EXELBKS      mis_res.
EXELSER      mis_res.
EXFUREQP     mis_res.
EXOTHIR      mis_res.
EXOTH2000    mis_res.
EXPRES       mis_res.
EXTOT        mis_res.
EXTOT2000    mis_res.
EXTOT2000B   mis_res.
EXTOTE_G2000 mis_res.
FINSUPP      $yes_no.
FIPS         $fips.
FORM         $form.
FPOFFER      fpoffer.
FRINGE       mis_res.
FRINGEYN     $yes_no.
FTGS9899     mis_res.
FTUS9899     mis_res.
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.
IMPUTE       $impute.
INETCMPYN    $yes_no.
INETOCOYN    $yes_no.
INETOCPYN    $yes_no.
INETYN       $yes_no.
INSINETCMPYN $yes_no.
INSINETOCOYN $yes_no.
INSINETOCPYN $yes_no.
INSINETYN    $yes_no.
INSTNM       $mis_res.
IRPAMICR     mis_res.
LIBNAME1     $mis_res.
LIBNAME2     $mis_res.
LIBNAME3     $mis_res.
LIBREFCMPYN  $yes_no.
LIBREFOCOYN  $yes_no.
LIBREFOCPYN  $yes_no.
LIBREFYN     $yes_no.
LIBSHAR1     $mis_res.
LIBSHAR2     $mis_res.
LIBSHAR3     $mis_res.
LOANREQCMPYN $yes_no.
LOANREQOCOYN $yes_no.
LOANREQOCPYN $yes_no.
LOANREQYN    $yes_no.
LOCALE       locale.
MASTDEG      mis_res.
MEDICAL      yes_no.
OBEREG       obereg.
OPEFLAG      opeflag.
OPEID        $mis_res.
OPENPUBL     yes_no.
PARTAFLAG    $partaf.
PARTBFLAG    $partbf.
PARTCFLAG    $partcf.
PARTDFLAG    $partdf.
PARTEFLAG    $partef.
PARTFFLAG    $partff.
PCTMIN1      mis_res.
PCTMIN2      mis_res.
PCTMIN3      mis_res.
PCTMIN4      mis_res.
PRESEN       mis_res.
PROFDEG      mis_res.
PTGS9899     mis_res.
PTUS9899     mis_res.
REFTRANS     mis_res.
REFUSAL      $refusal.
SATBRCMPYN   $yes_no.
SATBROCOYN   $yes_no.
SATBROCPYN   $yes_no.
SATBRYN      $yes_no.
SCANNERYN    $yes_no.
SECTOR       sector.
SOFTWAREYN   $yes_no.
STABBR       $stabbr.
STASST       mis_res.
STATUS       $status.
STCONSRV     mis_res.
STLIBPRO     mis_res.
STLIBS       mis_res.
STOTH        mis_res.
STOTHPRO     mis_res.
STTOT2000    mis_res.
SWASST       mis_res.
SWLIBPRO     mis_res.
SWOTH        mis_res.
TECHCMPYN    $yes_no.
TECHOCOYN    $yes_no.
TECHOCPYN    $yes_no.
TECHYN       $yes_no.
TFTFAC11_12M mis_res.
TFTFAC9_10M  mis_res.
TOTENR9899   mis_res.
TRIBAL       yes_no.
UGOFFER      ugoffer.
UNITID       $mis_res.
UNITIDX      $mis_res.
VDOCONFCMPYN $yes_no.
VDOCONFOCOYN $yes_no.
VDOCONFOCPYN $yes_no.
VDOCONFYN    $yes_no.
WEBADDR      $mis_res.
XATTEND      $impcode.
XBRANCHES    $impcode.
XCIRTRANS    $impcode.
XCOLAUDA     $impcode.
XCOLAUDH     $impcode.
XCOLBKPTA    $impcode.
XCOLBKPTH    $impcode.
XCOLBKSA     $impcode.
XCOLBKSH     $impcode.
XCOLMICRA    $impcode.
XCOLMICRH    $impcode.
XCOLSERA     $impcode.
XCOLSERH     $impcode.
XCUPAMICR    $impcode.
XDOCDEL      $impcode.
XEXAUD       $impcode.
XEXBIB       $impcode.
XEXCOMP      $impcode.
XEXDEL       $impcode.
XEXELBKS     $impcode.
XEXELSER     $impcode.
XEXFUREQP    $impcode.
XEXOTHIR     $impcode.
XEXOTH2000   $impcode.
XEXPRES      $impcode.
XEXTOT       $impcode.
XEXTOT2000   $impcode.
XEXTOT2000B  $impcode.
XEXTOTE_G2000 $impcode.
XFRINGE      $impcode.
XGATECT      $impcode.
XHOURS       $impcode.
XILPNON      $impcode.
XILPRET      $impcode.
XILPTOT      $impcode.
XILRNON      $impcode.
XILRRET      $impcode.
XILRTOT      $impcode.
XIRPAMICR    $impcode.
XPRESEN      $impcode.
XREFTRANS    $impcode.
XSTASST      $impcode.
XSTCONSRV    $impcode.
XSTLIBPRO    $impcode.
XSTLIBS      $impcode.
XSTOTH       $impcode.
XSTOTHPRO    $impcode.
XSTTOT2000   $impcode.
XSWASST      $impcode.
XSWLIBPRO    $impcode.
XSWOTH       $impcode.
XTFTFAC11_12M $impcode.
XTFTFAC9_10M $impcode.
ZIP          $mis_res.
;
run;
*/
/*
proc univariate data=OUT1.ALS_2000_P2A;
var 
ASSOCDEG
ATTEND
BACHDEG
BRANCHES
CIRTRANS
COLAUDA
COLAUDH
COLBKPTA
COLBKPTH
COLBKSA
COLBKSH
COLMICRA
COLMICRH
COLSERA
COLSERH
CUPAMICR
DOCDEL
DOCTDEG
EXAUD
EXBIB
EXCOMP
EXDEL
EXELBKS
EXELSER
EXFUREQP
EXOTHIR
EXOTH2000
EXPRES
EXTOT
EXTOT2000
EXTOT2000B
EXTOTE_G2000
FTGS9899
FTUS9899
GATECT
HOURS
ILPNON
ILPRET
ILPTOT
ILRNON
ILRRET
ILRTOT
IRPAMICR
IRPAMICR
MASTDEG
PCTMIN1
PCTMIN2
PCTMIN3
PCTMIN4
PRESEN
PROFDEG
PTGS9899
PTUS9899
REFTRANS
STASST
STCONSRV
STLIBPRO
STLIBS
STOTH
STOTHPRO
STTOT2000
SWASST
SWLIBPRO
SWOTH
TFTFAC11_12M
TFTFAC9_10M
TOTENR9899
;
run;       
*/