****Degree Title Categories: National Student Clearinghouse Created by Pam Borkowski-Valentin Swarthmore College Office of Institutional Research Spring 2016; modified Fall 2017. *******NOTE******** This syntax was developed for a particular project, and categories/sub-categories reflect this Adjust categories/sub-categories as needed. ****************IMPORTANT***************************************************** NOTE: Be sure to add additional Degree Titles to the syntax so that ALL Degree Titles in your file are captured. ***************************************************** *if it is particularly important to a project, you may also want to add syntax to account for the DegreeMajor1 field for those who have a broad MA, MS etc degree. COMPUTE DegreeTitleCategories=99. EXECUTE. DO IF (DegreeTitle=" "). RECODE DegreeTitleCategories (ELSE=SYSMIS). END IF. EXECUTE. ***If you do not want to include those with no degree titles for a particular project, you can comment this out Also note that some degree records have multiple lines, so always make sure to be selecting one record per person or otherwise taking that into account. DO IF (Graduated="Y" & DegreeTitle=" "). RECODE DegreeTitleCategories (ELSE=99). END IF. EXECUTE. ***Leaving as 99 (unknown) "POST-BACCALAUREATE PROGRAM", "AGING", "CANDIDATE IN PHILOSOPHY", "SPECIALIST IN EDUCATION", *"EDUCATIONAL SPECIALIST", "CREDENTIAL", "PRELIM ADM SERV CRED PREP", DO IF (ANY(DegreeTitle, 'ADVANCED CERTIFICATE', 'ADVANCED TECHNICAL CERTIFICATE', "CE CERTIFICATE", "CERT ALCOHOL & DRUG COUNSELING", "CERTIFICATE", "CERTIFICATE - CREDIT", "CERTIFICATE IN NONPROFIT MANAGEMENT", "CERTIFICATE OF ADV. GRAD STUDY", "CERTIFICATE OF COMPLETION", "CERTIFICATE OF GRADUATE ACHIEVEMENT", "CERTIFICATE OF GRADUATE STUDIES", "CERTIFICATE OF GRADUATE STUDY", "CERTIFICATE OF PROFICIENCY", "CERTIFICATE PROGRAM", "CERTIFICATE, SECONDARY EDUC.", "CERTIFICATE: AMERICAN STUDIES", "CERTIFICATE: INTER TECH & PED", "COLLEGE CREDIT CERTIFICATE", "CRTFCT-EDUCTNL SINGLE SUBJ", "OCCUPATIONAL CERTIFICATE", "PARENTING & FAM MGMT CERT", "MUSIC PERFORMER'S CERTIFICATE 1", "NON-DEGREE, CERTIFICATE", "MUSIC PERFORMER'S CERTIFICATE 1", "NON-DEGREE, CERTIFICATE", "TEACHER CERTIFICATION PROGRAM", "UNDERGRADUATE CERTIFICATE", "URBAN WATER RESOURCE DESIGN CERTIFICATE", "CTF. OF ADVANCED STUDY", "DIPLOMA IN INNOVATION", "PROFESSIONAL STUDIES DIPLOMA", "CERTIFICATE IN PRE-HEALTH", "CERTIFICATE IN DENTISTRY", "STATE SECONDARY PROVIS CERTIF", "DOCTORAL LEVEL CERTIFICATE" )). RECODE DegreeTitleCategories (99=1). END IF. EXECUTE. DO IF (ANY(DegreeTitle, 'ASSOCIATE APPLIED SCIENCE', 'ASSOCIATE IN APPLIED SCIENCE', 'ASSOCIATE IN ARTS', 'ASSOCIATE IN SCIENCE', 'ASSOCIATE OCCUPATIONAL STUDIES', 'ASSOCIATE OF OCCUPATIONAL STUDIES', "ASSOCIATE'S")). RECODE DegreeTitleCategories (99=2). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "BS IN MECHANICAL ENGINEERING", "BACHELOR OF SCIENCE", "BACHELOR OF SCIENCE IN PHYSICS" )). RECODE DegreeTitleCategories (99=3). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "BACHELOR OF SCI-NURSING", "BACHELOR OF SCIENCE IN NURSING", "BACHELOR OF SCIENCE/NURSING", "BS IN NURSING", "B.S. IN NURSING", "BACH OF SCIENCE IN NURSING" )). RECODE DegreeTitleCategories (99=3.5). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "BACH FINE ARTS", "BACHELOR OF ARTS", "BACHELOR OF ARTS IN EDUCATION", "BACHELOR OF FINE ARTS", "BACHELOR OF PROF STUDIES" )). RECODE DegreeTitleCategories (99=4). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "POST BACCALAUREATE CERTIFICATE", "POST BACC CERTIFICATE", "ADVANCED CERTIFICATE POST BACCALAUREATE", "POST-BAC CERT/APPLIED STUDIES", "POST-BAC CERTIFICATE", "POST-BAC PRE-MED CERTIFICATE", "POST-BACCALAUREATE", "POST-BACCALAUREATE CERT", "POSTBACCALAUREATE CERTIFICATE", "GRADUATE ACADEMIC CERTIFICATE", "GRADUATE CERTIFICATE", "MASTER'S LEVEL CERTIFICATE" )). RECODE DegreeTitleCategories (99=5). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MS", "SM", "M S", "MASTER OF SCIENCE (WITHOUT SPECIFICATION OF FIELD)", "M.S.", "M. S. IN ORGANIZATIONAL DYNAMICS", "MASTER OF SCIENCE" )). RECODE DegreeTitleCategories (99=6). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MA", "MASTER OF ARTS", "MASTER OF ARTS (M.A.)", "M.A.", "AM", "ARTIUM MAGISTRI" )). RECODE DegreeTitleCategories (99=7). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF APPLIED POSITIVE PSYCHOLO", "MASTER OF ARTS IN PSYCHOLOGY", "MASTER OF COUNSELING", "M.S. IN PSYCHOLOGY", "MS-PSYCHOLOGY", "M.S., COUNS & HUMAN RELATIONS", "MASTER OF ARTS IN EXPRESSIVE THERAPIES", "MS-EDUCATIONAL PSYCHOLOGY", "MASTER OF PSYCHOLOGY" )). RECODE DegreeTitleCategories (99=8). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF BUS ADMIN", "MASTER OF BUS ADMINISTRATION", "MASTER OF BUS. ADMIN.", "MASTER OF BUSINESS ADMIN", "MASTER OF BUSINESS ADMIN.", "MASTER OF BUSINESS ADMINISTR.", "MASTER OF BUSINESS ADMINISTRAT", "MASTER OF BUSINESS ADMINISTRATION", "MASTER OF BUSINESS ADMINISTRTN", "MASTER OF BUSINESS ADMN", "MASTERS OF BUSINESS ADMINISTRATION", "MBA", "MBA IN GLOBAL MANAGEMENT", "M B A", "M.B.A.", "MASTER BUS ADMIN", "MASTER IN BUSINESS ADMIN.", "MASTER BUSINESS ADMINISTRATION", "MASTER IN BUSINESS ADMINISTRATION" )). RECODE DegreeTitleCategories (99=9). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MSW", "MASTER SOCIAL WORK", "MASTER OF SOCIAL SERVICE", "MASTER OF SOCIAL WELFARE", "MASTER OF SOCIAL WORK", "M S W", "MASTER OF LAW & SOCIAL POLICY", "MASTER OF SOCIAL WRK" )). RECODE DegreeTitleCategories (99=10). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF PUBLIC HEALTH", "MASTER OF PUBLIC HEALTH (HEALTH SERV - COMMUNITY PRACTICE)", "MASTER PUBLIC HEALTH", "MASTER OF SCIENCE IN PUBLIC HEALTH", "MASTER OF SCIENCE (PUB HLTH- ENVIRONMENTAL HEALTH)", "MASTER OF SCIENCE (PUB HLTH- PATHOBIOLOGY)", "M P H", "MS IN PUBLIC HEALTH", "MPH" )). RECODE DegreeTitleCategories (99=11). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MFA", "MASTER OF FINE ART", "MASTER OF FINE ARTS", "M.F.A.", "MASTER FINE ARTS", "MASTER OF FINE ARTS IN WRITING" )). RECODE DegreeTitleCategories (99=12). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MPA", "MPA/ID", "MASTER OF PUBLIC ADMIN", "MASTER OF PUBLIC ADMINISTR.", "MASTER OF PUBLIC ADMINISTRAT.", "MASTER OF PUBLIC ADMINISTRATIO", "MASTER OF PUBLIC ADMINISTRATION", "MASTER/PUBLIC ADMINISTRATION" )). RECODE DegreeTitleCategories (99=13). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF DIVINITY", "MASTER OF THEOLOGICAL STUDIES" )). RECODE DegreeTitleCategories (99=14). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF ARTS IN COMPARATIVE LITERATURE", "MASTER OF ARTS IN ENGLISH" )). RECODE DegreeTitleCategories (99=15). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF COMPUTER & INFO TECHNOLOG", "MASTER OF COMPUTER SCIENCE", "MS IN COMPUTER SCIENCE", "MS-COMPUTER SCIENCES", "MASTER OF SCIENCE IN COMPUTER SCIENCE", "MASTER OF SCIENCE IN COMPUTER SCIENCES", "MASTER OF SCIENCE IN INFORMATION AND COMPUTER SCIENCE", "MASTER OF SCIENCE (COMPUTER SCIENCE & ENGINEERING)", "MS INFORMATION SCIENCE" )). RECODE DegreeTitleCategories (99=16). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF NURSING", "MASTER OF SCIENCE IN NURSING", "MSN" )). RECODE DegreeTitleCategories (99=17). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF PHYSICIAN ASSISTANT", "MASTER OF PHYSICIAN ASSISTANT STUDIES" )). RECODE DegreeTitleCategories (99=18). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF LAWS", "MASTER OF LAWS IN TAXATION", "LLM - ADVOCACY", "LLM-ADVOCACY", "LLM-GLOBAL HEALTH LAW", "LLM-TAXATION" )). RECODE DegreeTitleCategories (99=19). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MA-HISTORY", "M.A. IN HISTORY" )). RECODE DegreeTitleCategories (99=20). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF LIB & INFO SCIENCE", "MASTER OF LIBRARY & INFORM SCI", "MASTER OF LIBRARY AND INFORMATION SCIENCE", "MASTER OF LIBRARY SCIENCE", "MASTER OF LIBRARY/INFO SCIENCE", "MASTER LIB & INFO SCIENCE", "MASTER SCIENCE LIBRARY SCIENCE", "MASTER OF SCI IN LIBRARY SCI", "MS LIBRARY SCIENCE", "MASTER OF LIBRARY SERVICE", "MASTER OF SCIENCE IN INFORMATION STUDIES", "MASTER OF SCIENCE IN INFORMATION", "MASTER LIBRARY INFO SCI" )). RECODE DegreeTitleCategories (99=21). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF ENVIRONMENTAL AND ENERGY POLICY", "MS-LAND RESOURCES", "MS-CONSERV BIOL SUSTAIN DEVLP", "MASTER OF SCIENCE (FISHERIES)", "MASTER OF SCIENCE (FOREST RESOURCES)", "MASTER OF FORESTRY", "MASTER OF MARINE POLICY", "MASTER OF ENVIRONMENTAL MGT" )). RECODE DegreeTitleCategories (99=22). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF HEALTH SERVICES ADMINISTRATION", "MASTER OF HEALTHCARE ADMIN", "M H A" )). RECODE DegreeTitleCategories (99=23). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF HEALTH SCIENCE", "MASTER OF HEALTH SCIENCES", "MASTER OF SCIENCE IN MEDICAL SCIENCE", "MS-PHARMACEUTICAL SCIENCES", "M S IN HEALTH SCIENCES", "MASTER OF MEDICAL SCIENCE", "MASTER OF SCIENCE IN TRANSLTL RSRCH", "MHS" )). RECODE DegreeTitleCategories (99=24). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF URBAN AND REGIONAL PLANNING", "MASTER OF URBAN PLANNING", "MASTER OF PUBLIC AFFAIRSURBAN & REGIONAL PLANNING", "MASTER OF REGIONAL PLANNING", "MASTER OF CITY & REGIONAL PLAN", "MASTER OF CITY PLANNING", "MASTER REGIONAL PLANNING", "MASTER-URBAN PLANNG & POLICY", "MASTER CITY/REG PLANNING", "MASTER IN CITY PLANNING", "MASTER IN URBAN PLANNING", "MS-URBAN & REGIONAL PLANNING", "MASTER OF COMM & REGIONAL PLAN" )). RECODE DegreeTitleCategories (99=25). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF PUBLIC AFFAIRS", "MASTER OF PUBLIC POLICY", "MPP", "M P P", "MASTER IN PUBLIC POLICY", "MASTER OF GOVERNMENT ADMINISTRATION", "MASTER IN PUBLIC AFFAIRS" )). RECODE DegreeTitleCategories (99=26). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF ENGINEERING", "MASTER OF ENGINEERING - CIVIL", "MASTER OF ENGINEERING PHYSICS", "MASTER OF SCIENCE IN MECHANICAL AND AEROSPACE ENGINEERING", "MASTER OF SCIENCE IN CIVIL ENGINEERING", "MS IN CIVIL ENGINEERING", "MS ENVIRONMENT ENGR", "MS IN ENGINEERING", "MS-ELECTRICAL ENGINEERING", "MASTER OF SCIENCE IN ELECTRICAL ENGINEERING", "MASTER OF SCIENCE IN ENGINEERING", "MS-NUCLEAR EGR & EGR PHYSICS", "M.S., COMPUTER ENGINEERING", "MS IN ELEC & COMPUTER ENGR", "MASTER OF SOFTWARE ENGINEERING", "MSE", "MS IN ELECTRICAL AND COMPUTER", "M.S.E." )). RECODE DegreeTitleCategories (99=27). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF ACCOUNTANCE & PROFESSIONAL CONSULTANCY", "MASTER OF ACCOUNTING", "MASTER OF QUANTITATIVE FINANCE", "MASTER OF TAXATION", "MASTER OF SCIENCE IN FINANCE", "M.S. IN ACCOUNTING", "MAC" )). RECODE DegreeTitleCategories (99=28). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF ARCHITECTURE", "MASTER OF ARCHITECTURE 1", "MASTER OF ARCH-1", "MASTER OF ARCHITECTURAL HISTORY", "MASTER IN ARCHITECTURE" )). RECODE DegreeTitleCategories (99=29). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER IN TEACHING", "MASTER OF ARTS IN EDUCATION", "MA-EDUCATIONAL POLICY STUDIES", "M A IN EDUC & HUMAN DEV", "MASTER ART IN TEACH.", "MASTER OF ARTS IN TEACHING", "M.A. IN TEACHING", "MASTER OF TEACHING", "MASTER OF EDUCATION", "MASTERS IN ARTS AND TEACHING", "MASTER OF SCIENCE-EDUCATION", "M.S. IN EDUCATION", "MASTER OF SCIENCE IN EDUCATION", "MS IN EDUCATION", "MASTER OF SCIENCE IN TEACHING", "MASTER OF SCIENCE ED.", "MASTER OF SCIENCE FOR TEACHERS", "MASTER OF SCI IN EDUCATION", "MASTER OF EDUCATION(EDUCATIONAL LEADERSHIP & POLICY STUDIES", "ED.M", "MS EDUCATION & SOCIAL POLICY", "MS-CURRICULUM AND INSTRUCTION", "MASTER OF PHILOSOPHY IN EDUCATION", "MASTER OF EDUCATION(EDUCATIONAL LEADERSHIP & POLICY STUDIES)", "ED.M." )). RECODE DegreeTitleCategories (99=30). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF INTERNAT'L AFFAIRS", "MASTER OF INTERNATIONAL AFF.", "MA.OF INT'L AFFAIRS & DEV", "MASTER OF PACIFIC INTL AFFAIRS", "MASTER OF ARTS IN INTERNATIONAL STUDIES:COMPARATIVE RELIGION", "MA IN INTERCULTURAL STUDIES" )). RECODE DegreeTitleCategories (99=31). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF INDUSTRIAL & LABOR RELATIONS", "MASTER OF INDUSTRIAL AND LABOR RELATIONS" )). RECODE DegreeTitleCategories (99=32). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER IN LANDSCAPE ARCHITECTURE", "MASTER OF LANDSCAPE ARCH" )). RECODE DegreeTitleCategories (99=33). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER IN LIBERAL ARTS", "MASTER OF ARTS IN LIB. STD.", "MASTER OF LIBERAL ARTS" )). RECODE DegreeTitleCategories (99=34). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER HUMAN RESOURCE MGMT" )). RECODE DegreeTitleCategories (99=35). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MS IN JOURNALISM", "MASTER OF JOURNALISM" )). RECODE DegreeTitleCategories (99=36). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF PROFESSIONAL STUDIES", "MASTER PROFESSIONAL STUDIES" )). RECODE DegreeTitleCategories (99=37). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF MUSIC", "MAST OF INDUSTL DES", "MASTER OF ARTS IN VISUAL STUDIES" )). RECODE DegreeTitleCategories (99=38). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "M.S. IN APPLIED STATISTICS", "MASTER OF SCIENCE IN STATISTICS", "MASTER OF STATISTICAL PRACTICE", "MASTER OF SCIENCE (STATISTICS)", "MASTER OF SCIENCE (MATHEMATICS)", "MASTER OF SCIENCE IN COMPUTATIONAL FINANCE", "MASTER OF SCIENCE (APPLIED MATHEMATICS)" )). RECODE DegreeTitleCategories (99=39). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF ARTS IN APPLIED ECONOMICS", "MASTER OF SCIENCE IN ECONOMICS", "MS-ECONOMICS" )). RECODE DegreeTitleCategories (99=40). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MS-MEDICAL PHYSICS", "MS-PHYSICS", "MASTER OF SCIENCE (PHYSICS)", "MA-PHYSICS" )). RECODE DegreeTitleCategories (99=41). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "M.S., CHEMISTRY" )). RECODE DegreeTitleCategories (99=42). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF PHILOSOPHY", "MA-PHILOSOPHY" )). RECODE DegreeTitleCategories (99=43). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF SCIENCE IN ENGINEERING MANAGEMENT", "MASTER ENGG MGMT" )). RECODE DegreeTitleCategories (99=44). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MS-EPIDEMIOLOGY" )). RECODE DegreeTitleCategories (99=45). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MS-GEOGRAPHY" )). RECODE DegreeTitleCategories (99=46). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF LATIN", "MA-CHINESE", "MASTER OF SCIENCE (COMPUTATIONAL LINGUISTICS)", "MA-LANGUAGES&CULTURES OF ASIA", "MASTER OF ARTS (CLASSICS)" )). RECODE DegreeTitleCategories (99=47). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF ENTERTAINMENT TECHNOLOGY" )). RECODE DegreeTitleCategories (99=48). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MA-POLITICAL SCIENCE" )). RECODE DegreeTitleCategories (99=49). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF SCIENCE IN HIST. PRESERV." )). RECODE DegreeTitleCategories (99=49.1). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MS IN PREDICTIVE ANALYTICS", "MS IN ANALYTICS" )). RECODE DegreeTitleCategories (99=49.2). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF SCIENCE (ASTRONOMY)" )). RECODE DegreeTitleCategories (99=49.3). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MA-ANTHROPOLOGY" )). RECODE DegreeTitleCategories (99=49.4). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF TOURISM & HOSPITALITY MGMT" )). RECODE DegreeTitleCategories (99=49.5). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF SCIENCE (OCEANOGRAPHY)" )). RECODE DegreeTitleCategories (99=49.6). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF OCC THER" )). RECODE DegreeTitleCategories (99=49.7). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MS-AGROECOLOGY" )). RECODE DegreeTitleCategories (99=49.8). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MASTER OF SCIENCE IN BIOLOGICAL SCIENCES", "MS BIOTECHNOLOGY/MBA", "MS-BACTERIOLOGY", "MS-ZOOLOGY" )). RECODE DegreeTitleCategories (99=49.9). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "MS IN ADMINISTRATION" )). RECODE DegreeTitleCategories (99=48.1). END IF. EXECUTE. *Notes: Code 50 is 'Master Not Otherwsie Specified' MFS could stand for Master of Forensic Science or Master of Forestry Science MM could be Master of Music or Master of Management. DO IF (ANY(DegreeTitle, "MFS", "MSA", "MM", "MASTER" )). RECODE DegreeTitleCategories (99=50). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR OF VETERINARY MEDICINE", "DVM", "VETERINARIAE MEDICINAE DOCTORIS-VMD" )). RECODE DegreeTitleCategories (99=51). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR", "DOCTOR OF DENTAL MEDICINE", "DOCTOR OF DENTAL SURGERY", "DOCTOR OF MEDICINE", "DOCTOR OF MEDICINE (M.D.)", "DOCTOR OF MEDICINE (MD)", "DOCTOR OF OSTEOPATHIC MED", "DOCTOR OF OSTEOPATHIC MEDICINE", "DOCTOR OF OSTEOPATHY", "DR. OF MEDICINE/DR. OF PHILOS.", "DR. OF OSTEOPATHIC MED.", "M.D.", "MEDICAL DOCTORATE", "M D", "MD", "MEDICINAE DOCTORIS", "DO" )). RECODE DegreeTitleCategories (99=52). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR OF AUDIOLOGY" )). RECODE DegreeTitleCategories (99=53). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR OF OPTOMETRY", "O.D." )). RECODE DegreeTitleCategories (99=54). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR OF PSYCHOLOGY" )). RECODE DegreeTitleCategories (99=55). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR OF PUBLIC HEALTH" )). RECODE DegreeTitleCategories (99=56). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR OF SCIENCE" )). RECODE DegreeTitleCategories (99=57). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR OF EDUCATION", "ED.D.", "ED.L.D." )). RECODE DegreeTitleCategories (99=58). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR OF MUSICAL ARTS" )). RECODE DegreeTitleCategories (99=59). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "PH D", "PH.D.", "PHD", "PHILOSOPHIAE DOCTORIS", "DR OF PHILOSOPHY", "DOCTOR OF PHILOSOPHY", "DOCTOR OF PHILOSOPHY (ANTHROPOLOGY)", "DOCTOR OF PHILOSOPHY (APPLIED MATHEMATICS)", "DOCTOR OF PHILOSOPHY (EDUCATION: CURRICULUM & INSTRUCTION)", "DOCTOR OF PHILOSOPHY (MATHEMATICS)", "DOCTOR OF PHILOSOPHY (MICROBIOLOGY)", "DOCTOR OF PHILOSOPHY (BIOLOGY)", "DOCTOR OF PHILOSOPHY (OCEANOGRAPHY)", "DOCTOR OF PHILOSOPHY (PSYCHOLOGY)", "DOCTOR OF PHILOSOPHY (QUANTITATIVE ECOLOGY & RESOURCE MGMT)", "DOCTOR OF PHILOSOPHY (ZOOLOGY)", "DOCTOR OF PHILOSOPHY IN ENGLISH", "DOCTOR OF PHILOSOPHY IN INFORMATION AND COMPUTER SCIENCE", "DOCTOR OF PHILOSOPHY IN VISUAL STUDIES", "DOCTOR OF PHILOSOPHY(ENV HLTH: ENVIR & OCCUPATIONAL HYGIENE)" )). RECODE DegreeTitleCategories (99=60). END IF. EXECUTE. DO IF (ANY(DegreeTitle, "DOCTOR OF JURISPRUDENCE", "DOCTOR OF LAW", "DOCTOR OF LAW (JURIS DOCTOR)", "J D", "J.D.", "JD", "JD-JURIS DOCTOR", "JURIS DOCTOR", "JURIS DOCTOR (DOCTOR OF LAW)", "JURIS DOCTOR (LAW)", "JURIS DOCTORATE", "JURIS DOCTORIS" )). RECODE DegreeTitleCategories (99=61). END IF. EXECUTE. VALUE LABELS DegreeTitleCategories 1 'Certificate or Diploma' 2 'Associate' 3 'Bachelor of Science (not specified as Nursing)' 3.5 'Bachelor of Science-Nursing' 4 'Bachelor of Arts or Bachelor of Prof Studies' 5 'Post-Baccalaureate Certificate' 6 'MS' 7 'MA' 8 'Master of Psychology or Counseling' 9 'MBA' 10 'MSW' 11 'MPH' 12 'MFA' 13 'Master of Public Administration or Public Administration/International Development' 14 'Master of Divinity or Theological Studies' 15 'Master of English, Comparative Literature' 16 'Master of Computer Science/Info Tech/Info Science' 17 'Master of Nursing' 18 'Master of Physician Assistant' 19 'Master of Laws' 20 'Master of History' 21 'Master of Library Science or Library Service' 22 'Master of Natural Resource & Conservation' 23 'Master of Health Services Administration' 24 'Master of Health Sciences, Medical Science, or Pharmaceutical Science' 25 'Master of Urban, Regional, City, or Community Planning' 26 'Master of Public Policy, Affairs, or Administration' 27 'Master of Engineering' 28 'Master of Accounting, Finance, or Taxation' 29 'Master of Architecture & related services' 30 'Master in Teaching, Education, Education Policy or Philosophy' 31 'Master of International/Intercultural Affairs/Studies' 32 'Master of Industrial & Labor Relations' 33 'Master of Landscape Architecture' 34 'Master of Liberal Arts' 35 'Master of Human Resource Management' 36 'Master of Journalism' 37 'Master of Professional Studies' 38 'Master of Visual or Performing Arts (not MFA)' 39 'Master of Mathematics or Statistics' 40 'Master of Economics' 41 'Master of Physics, Medical Physics' 42 'Master of Chemistry' 43 'Master of Philosophy' 44 'Master of Engineering Management' 45 'Master of Epidemiology' 46 'Master of Geography' 47 'Master of Foreign Language, Literature, & Linguistics' 48 'Master of Entertainment Technology' 48.1 'Master of Administration' 49 'Master of Political Science' 49.1 'Master of Historical Preservation' 49.2 'Master of Analytics or Predictive Analytics' 49.3 'Master of Astronomy' 49.4 'Master of Anthropology' 49.5 'Master of Tourism & Hospitality Management' 49.6 'Master of Oceanography' 49.7 'Master of Occupational Therapy' 49.8 'Master of Agroecology' 49.9 'Master of Biological & Biomedical Science' 50 'Master Not Otherwsie Specified' 51 'Doctor of Veterinary Medicine' 52 'Medical Doctor' 53 'Doctor of Audiology (AuD)' 54 'Doctor of Optometry (OD)' 55 'Doctor of Psychology' 56 'Doctor of Public Health' 57 'Doctor of Science' 58 'Doctor of Education' 59 'Doctor of Musical Arts' 60 'PhD' 61 'Juris Doctor (Doctor of Law)' 99 'Unknown' 100 'No Degree'. Execute. **DegreeTitleCatShort categories were specified for a particular project Other projects may necessitate recoding the variable DegreeTitleCategories differently. RECODE DegreeTitleCategories (1=1) (5=1) (99=1) (2=2) (3 thru 4=3) (6 thru 8=4) (10 thru 50=4) (9=5) (55 thru 60=6) (61=7) (51 thru 54=8) INTO DegreeTitleCatShort. EXECUTE. VALUE LABELS DegreeTitleCatShort 1 'Certificate, Diploma, or Unknown' 2 'Associate' 3 'Bachelor' 4 'Master (excluding MBA)' 5 'MBA' 6 'PhD or other Doctorate' 7 'Juris Doctor' 8 'Doctor or Veterinary Medicine'. Execute. ***check for unknowns or anything else that didn't get coded, but that needs to be coded, in your particular data set.