TITLE Process THECB Excel State Course Completion Data. *SPSS Syntax to Create Labels, Add Vars, Format Vars, and Drop Vars. *Created by Thomas K. Martin. *Last Modified on 7/9/2003. *. *Format input variables from THECB file. FORMATS fice (F6.0). FORMATS cipcode (F6.0). FORMATS cenenr (F8.0). FORMATS lastenr (F8.0). *. *Generate a Counter Variable to Tally Number of Data Points in Any Aggregation. COMPUTE counter = 1. FORMATS counter (F1.0). *. *Generate a variablie for the fiscal year (year ending August 31). *NOTE! THE FISCAL YEAR MUST BE MANUALLY SET ON THE NEXT LINE. *PRIOR TO RUNNING THIS SPSS SYNTAX FILE. COMPUTE fiscyear = 2002. FORMATS fiscyear (F4.0). *. *Generate Numeric Variable for Type of CIP Code. COMPUTE typecip = 0. IF (type = 'ACAD') typecip = 1. IF (type = 'TECH') typecip = 2. IF (type = 'WECM') typecip = 3. FORMATS typecip (F1.0). *. *Generate course completion rate in decimal, rather than percent, format. COMPUTE crscomrt = lastenr/cenenr. FORMATS crscomrt (F5.3). *. *Drop records from THECB file for institutional totals. SELECT IF (cipcode ~= 999999). *. VARIABLE LABELS fice 'Institutional FICE Code'/ cipcode 'Six-Digit CIP Code'/ cenenr 'Census Day Contact Hour Enrollment'/ lastenr 'Last Class Day Contact Hour Enrollment'/ crscompt 'Course Completion Percentage'/ counter 'Number of Data Points'/ fiscyear 'Fiscal Year'/ typecip 'Type of CIP Code'/ crscomrt 'Course Completion Rate'. *. VALUE LABELS fice 90 'San Jacinto College South Campus' 307 'Alamo CCD NW Vista College' 326 'Tarrant Southeast Campus' 574 'Southwest Collegiate Institute' 717 'NHMCCCD CY-FAIR' 719 'NHMCCCD Kingwood College' 720 'NHMCCCD Tomball College' 721 'NHMCCCD Montgomery College' 722 'NHMCCCD North Harris College' 3539 'Alvin Community College' 3540 'Amarillo College' 3546 'Coastal Bend College' 3549 'Blinn College' 3553 'Cisco Junior College' 3554 'Clarendon College' 3558 'North Central Texas College' 3561 'DCCCD Cedar Valley College' 3563 'Del Mar College' 3568 'Frank Phillips College' 3570 'Grayson County College' 3572 'Trinity Valley Comm College' 3573 'Hill College' 3574 'Howard College' 3580 'Kilgore College' 3582 'Laredo Community College' 3583 'Lee College' 3590 'McLennan Community College' 3593 'Navarro College' 3596 'Odessa College' 3600 'Panola College' 3601 'Paris Junior College' 3603 'Ranger College' 3608 "St. Philip's College" 3609 'San Jacinto College Central Campus' 3611 'South Plains College' 3614 'Southwest Texas Junior College' 3627 'Temple College' 3628 'Texarkana College' 3634 'Texas State TC Waco' 3643 'Texas Southmost College' 3648 'Tyler Junior College' 3662 'Victoria College, The' 3664 'Weatherford College' 3668 'Wharton County Junior College' 4003 'Central Texas College' 4453 'DCCCD El Centro College' 6661 'Angelina College' 6662 'Galveston College' 7096 'College of the Mainland' 7857 'Brazosport College' 8503 'DCCCD Mountain View College' 8504 'DCCCD Richland College' 8510 'DCCCD Eastfield College' 8899 'Tarrant Northeast Campus' 8900 'Tarrant South Campus' 9163 'San Antonio College' 9225 'Texas State TC Harlingen' 9549 'Western Texas College' 9797 'Midland College' 9932 'Texas State TC Sweetwater' 10060 'Vernon Regional Junior College' 10387 'El Paso Community College Dist' 10633 'Houston Community College' 10964 'Tarrant Northwest Campus' 12015 'Austin Community College' 12713 'San Jacinto College North Campus' 20774 'DCCCD North Lake College' 21002 'DCCCD Brookhaven College' 23154 'Northeast Texas Comm College' 23413 'Palo Alto College' 23485 'Lamar State Coll-Port Arthur' 23582 'Lamar State Coll-Orange' 23614 'CCCCD' 103634 'Texas State TC Marshall' 109225 'South Texas Community College' 358135 'Lamar Institute of Technology'/ cipcode 10101 'agri business & mgmt, general' 10102 'agri business/agribusinss oper' 10103 'agricultural economics' 10104 'farm & ranch management' 10201 'agri mechanization, general' 10204 'agri power machinery operator' 10302 'agri anml hsbndry & prod mgmt' 10303 'aquaculture oper & prod mgmt' 10304 'crop production oper & mgmt' 10507 'eqstrn/eqn std, hrs mgt & trng' 10601 'hort srvcs opers & mgmt, gnrl' 10603 'ornamental hort opers & mgmt' 10604 'greenhouse operations & mgmt' 10605 'landscaping operations & mgmt' 10606 'nursery operations & mgmt' 10607 'turf management' 20201 'animal sciences, general' 20205 'agricultural animal physiology' 20206 'dairy science' 20209 'poultry science' 20299 'animal sciences, other' 20301 'food sciences & technology' 20401 'plant sciences, gnrl' 20402 'agronomy & crop science' 20403 'horticulture science' 20405 'plant breeding & genetics' 20408 'plant protection (pest mgmt)' 20409 'range science & management' 20501 'soil sciences' 30101 'natural resources cnsrv, gnrl' 30102 'environmental science/studies' 30501 'forestry, general' 30502 'forestry sciences' 30506 'forest management' 30509 'wood science & pulp/paper tchn' 30601 'wildlife & wildlands mgmt' 40201 'architecture' 50107 'latin american studies' 80101 'apprl & accsrs mktg oper, gnrl' 80102 'fashion merchandising' 80503 'floristry marketing operations' 80701 'auctioneering' 80705 'general retailing operations' 80706 'gnrl sellng sklls & sale opers' 80708 'general marketing operations' 81105 'travel services marketing opers' 81203 'vhcl prts & accssrs mktg opers' 90201 'advertising' 90401 'journalism' 90402 'broadcast journalism' 90403 'mass communications' 90501 'publc relations & organ comm' 90701 'radio & tv broadcasting' 100101 'educ/instr media tchn/tchncn' 100104 'radio & tv broadcstng tch/tchn' 100199 'communications tch/tchn, other' 110101 'computer & info scis, general' 110201 'computer programming' 110301 'data processing tchn/tchncn' 110401 'information sciences & systems' 110501 'computer systems analysis' 110701 'computer science' 119999 'microcomputer applications' 120204 'umpires & other sport officls' 120301 'funeral servics & mortuary sci' 120402 'barber/hairstylist' 120403 'cosmetologist' 120501 'baker/pastry chef' 120503 'culinary arts/chef training' 120504 'food & bvrg/restaurant ops mgr' 130101 'education, general' 130201 'bilingual/bicultural education' 130301 'curriculum & instruction' 131001 'special education, general' 131305 'english teacher education' 131314 'physical educ tchng & coachng' 131321 'computer teacher education' 131501 'teacher assistant/aide' 140101 'engineering, general' 141001 'electrical, electronics & comm eng' 141101 'engineering mechanics' 142801 'textile sciences & engineering' 143101 'materials science' 150101 'architecturl engr tchn/tchncn' 150301 'computer engineering tch/tchn' 150303 'elctri, eltro & cmm egr tch/tc' 150304 'laser & optical tchn/tchncn' 150401 'biomedical engr-rel tch/tchn' 150402 'computer maintenance tchn/tchn' 150403 'elctromechanical tchn/tchncn' 150404 'instrumentation tchn/tchncn' 150405 'robotics technology/technician' 150501 'heating, a c, & rfrg tch/tchn' 150503 'energy mgmt & systs tch/tchn' 150505 'solar technology/technician' 150506 'wtr qual & wstwtr trtm tch/tchn' 150507 'envr & polltn cntrl tch/tchn' 150603 'indu/manufacturing tch/tchn' 150607 'plastics technology/technician' 150611 'metallurgical tchn/tchncn' 150701 'occuptnl safty & hlth tch/tchn' 150702 'quality control tchn/tchncn' 150801 'aeronautical/aerospace eng tch/tchn' 150903 'petroleum technology/tchncn' 151001 'construction/bldg tchn/tchn' 151101 'engineering tch/tchn, general' 151102 'surveying' 151103 'hydraulics technology/tchncian' 160301 'chinese language & literature' 160302 'japanese language & literature' 160399 'korean language & literature' 160402 'russian language & literature' 160501 'german language & literature' 160901 'french language & literature' 160902 'italian language & literature' 160904 'portuguese language & lit' 160905 'spanish language & literature' 161203 'latin lng & lit (ancnt & mdvl)' 190101 'home economics, general' 190401 'family resource mgmt studies' 190402 'consumer economics & science' 190501 'food & nutrition studies, gnrl' 190502 'foods & nutrition science' 190503 'dietetics/human nutritnl srvcs' 190505 'food systems administration' 190603 'interior environments' 190701 'indiv & family dev stds, gnrl' 190704 'family life & relations stds' 190705 'gerontological services' 190706 'child growth, care, & dev stds' 190901 'clothng/apparel & textile stds' 200107 'family living & parenthood' 200201 'chld care & gd wrk & mgs, gnrl' 200202 'child care provider/assistant' 200203 'child care services manager' 200301 'clth, & txtl wrk & mgrs, gnrl' 200303 'commercial garmnt & apprl wrkr' 200305 'custom tailor' 200401 'inst food workers & admn' 200404 'dietician assistant' 220101 'law (llb, jd)' 220103 'paralegal/legal assisting' 230301 'comparative literature' 230401 'english composition' 230501 'english creative writing' 230701 'american literature (U.S.)' 230801 'english lit (brit & commnwlth)' 231001 'speech & rhetorical studies' 231101 'english technical & busi wrtng' 239999 'english lng & lit/lettrs, othr' 240102 'general studies' 240103 'humanities/humanistic studies' 250101 'library science/librarianship' 260101 'biology, general' 260301 'botany, general' 260501 'microbiology/bacteriology' 260601 'anatomy' 260613 'genetics, plant & animal' 260701 'zoology, general' 260702 'entomology' 260704 'pathology, human & animal' 260705 'pharmacology, human & animal' 260706 'physiology, human & animal' 261101 'biology, unique need' 270101 'mathematics' 270301 'applied mathmatics, general' 270501 'mathematical statistics' 301101 'gerontology' 301201 'histrc prsv, cnsv, & arch hist' 310101 'prks, recr, & leisure studies' 310501 'health & phys educ, general' 310503 'athletic training & sports med' 310504 'sport & fitness adm/mgt' 310505 'exrcs scis/physlgy & mvmt stds' 310506 'socio-psychological sprts stds' 320101 'basic skills, general' 320104 'computational skills' 320107 'career exploratn/awrnss skills' 320108 'reading, literacy, & comm skls' 320199 'basic skills, other' 360108 'sports & exercise (activities)' 360114 'dancing (activities)' 380101 'philosophy' 380201 'religion/religious studies' 400101 'physical sciences, general' 400201 'astronomy' 400501 'chemistry, general' 400502 'analytical chemistry' 400504 'organic chemistry' 400601 'geology' 400703 'earth & planetary sciences' 400801 'physics, general' 410101 'biological tchnology/tchncn' 410205 'nuclear/nucl power tchn/tchncn' 410301 'chemical technology/technician' 420101 'psychology, general' 420201 'clinical psychology' 420301 'cognitive psyc & psycholngstcs' 420601 'counseling psychology' 420701 'developmental & child psyc' 420901 'industrial & organizatnal psyc' 421601 'social psychology' 429999 'psychology, other' 430102 'corrections/correctional admn' 430103 'crim justice/law enfrcmnt admn' 430104 'criminal justice studies' 430107 'law enforcement/police science' 430201 'fire protectn & safty tch/tchn' 430202 'fire services administration' 430203 'fire science/firefighting' 440401 'public administration' 440701 'social work' 450101 'social sciences, general' 450201 'anthropology' 450301 'archaeology' 450401 'criminology' 450601 'economics, general' 450701 'geography' 450702 'cartography' 450801 'history, general' 450802 'american (U.S.) history' 450901 'international relatns & affrs' 451001 'political science & govt, gnrl' 451002 'american govt & politics (U.S.)' 451101 'sociology' 451201 'urban studies/affairs' 460101 'mason & tile setter' 460201 'carpenter' 460301 'elctri & pwr trans instl, gnrl' 460302 'electrician' 460303 'lineworker' 460401 'building/property maint & mgr' 460408 'painter & wall coverer' 460501 'plumber & pipefitter' 470101 'elctri & eltro eqp i & r, gnrl' 470103 'commnctns systs instlr & repr' 470104 'computer installer & repairer' 470105 'indu electrncs instllrs & repr' 470106 'major appliance instllr & repr' 470201 'htng, a c, & rfrg mchnc & repr' 470302 'heavy equip maintenance & repr' 470303 'indu machinery maint & repr' 470401 'instrument calibration & repr' 470408 'watch, clock, & jewelry repr' 470603 'auto/automotive body repairer' 470604 'auto/automotive mechanic/tchn' 470605 'diesel engine mechanic & repr' 470606 'small engine mechanic & repr' 470607 'aircraft mchn/tchn airframe' 470608 'aircraft mchn/tchn powerplant' 470609 'aviation syst & avncs tch/tchn' 470611 'motorcycle mechanic & repairer' 480101 'drafting, general' 480102 'architectural drafting' 480103 'civil/structural drafting' 480104 'electrical/electronics draftng' 480105 'mechanical drafting' 480201 'grphc & prntng eqp oper, gnrl' 480206 'lithographer & platemaker' 480208 'printing press operator' 480211 'computer typgrph & cmp eqp opr' 480212 'desktop publishing equip oper' 480303 'upholsterer' 480501 'machinist/machine technologist' 480506 'sheet metal worker' 480507 'tool & die maker/technologist' 480508 'welder/welding technologist' 480703 'cabinet maker & millworker' 490102 'aircraft pilot & navgtr (prof)' 490104 'aviation management' 490202 'construction equipmnt operator' 490205 'truck, bus, & comm vhcle opers' 500101 'visual & performing arts' 500301 'dance' 500401 'design & visual communications' 500402 'grphc dsgn, cmmr art, & illstr' 500406 'commercial photography' 500407 'fashion design & illustration' 500408 'interior design' 500501 'drama/theater arts, general' 500502 'tchnl thtr/thtr dsgn & stagcft' 500503 'acting & directing' 500505 'drama/thtr lit, hist, & crtcsm' 500601 'film/cinema studies' 500602 'film-video mkng/cinemtg & prod' 500605 'photography' 500701 'art, general (visual)' 500703 'art history, crtcsm, & cnsrvtn' 500705 'drawing' 500708 'painting' 500709 'sculpture' 500710 'printmaking' 500711 'ceramic arts & ceramics' 500712 'fiber, textile, & weaving arts' 500713 'metal & jewelry arts' 500901 'music, general' 500902 'music history & literature' 500903 'music - general performance' 500904 'music theory & composition' 500905 'musicology & ethnomusicology' 500907 'music - piano & organ perf' 500908 'music - voice & chrl/opra perf' 500909 'music busi mgt & merchandising' 510205 'sign language interpreter' 510301 'community health liaison' 510601 'dental assistant' 510602 'dental hygienist' 510603 'dental laboratory technician' 510701 'rehab services admin' 510702 'hospital/health facilties admn' 510703 'health unit coord/ward clerk' 510707 'medical records tch/tchn' 510708 'medical transcription' 510799 'hlth & med admn services, othr' 500906 'music conducting' 510801 'medical assistant' 510802 'medical laboratory assistant' 510803 'occupational therapy assistant' 510805 'pharmacy technician/assistant' 510806 'physical therapy assistant' 510808 'vet asst/animal health tchncn' 510901 'cardiovascular technology/tchn' 510902 'electrocardiograph tch/tchn' 510904 'emergency medical tchn/tchncn' 510905 'nuclear medical tchn/tchncn' 510907 'medical radiologic tch/tchn' 510908 'respiratory therapy technician' 510909 'surgical/operating room tchncn' 510910 'diagnostic med songrphy tchncn' 511005 'medical technology' 511004 'medical laboratory technician' 511099 'hlth & med lab tch/tchn, other' 511199 'health professions, local need' 511501 'alcohol/drug abuse counseling' 511502 'psychtric/mntl hlth srvcs tchn' 511503 'clinical & medical social work' 511601 'nursing, general' 511602 'nursing admin (post-RN)' 511605 'nursing, family pract (post-RN)' 511606 'nrsng, matern/chld hlth (post-RN)' 511609 'nursing, pediatric (post-RN)' 511610 'nrsng, psychiatric/mntl hlth (post-RN)' 511612 'nursing, surgical (post-RN)' 511613 'practical nurse (LPN training)' 511614 'nursing assistant/aide' 511801 'opticianry/dispensing optician' 511802 'optical technician/assistant' 512308 'physical therapy' 512309 'recreational therapy' 512702 'medical dietician' 519999 'health profs & rel scis, other' 520101 'business, general' 520201 'busi admn & management, gnrl' 520202 'prchsng, prcrmnt, & cntrct mgt' 520203 'logistics & materials mgmt' 520204 'office supervision & mgmt' 520205 'operations management & supv' 520301 'accounting' 520302 'accounting technician' 520401 'admnstrtve asst/secr sci, gnrl' 520403 'legal administrative asst/secr' 520404 'medical admn assistant/secr' 520405 'court reporter' 520407 'info proc/data entry tchncn' 520408 'gnrl offce/clrcl & typng srvcs' 520501 'business communications' 520601 'business/managerial econ' 520701 'enterprise mgmt & oper, gnrl' 520801 'finance, general' 520803 'banking & financl spprt srvcs' 520805 'insurance & risk management' 520807 'investments & securities' 520901 'hospitality administration/mgt' 520902 'hotel/motel & restaurant mgt' 520903 'travel-tourism management' 521001 'human resources management' 521002 'labor/personnel rel & studies' 521003 'organizational behavior stds' 521101 'international business' 521201 'mgmt info syst & bus d p, gnrl' 521202 'busi computer programming/prog' 521203 'busi systems analysis & design' 521204 'busi systms ntwrkng & telecomm' 521205 'busi computer facilities oper' 521301 'management science' 521401 'busi marketing & mktg mgmt' 521501 'real estate' 521601 'taxation' 999999 'unknown'/ typecip 1 'Academic' 2 'Technical' 3 'Workforce Education'. *. FREQUENCIES VARIABLES = fice cipcode type typecip. *. SAVE OUTFILE = 'H:\Projects\Retention Comparisons\Original SPSS from THECB Files\Fall 2002 THECB Course Completion.sav' /DROP = type cipname. *.