* This Code Creates A Cohort Retention and Completion Table based on a StudentTracker return file. . * Authored by Richard Reeves, Director of Research, National Student Clearinghouse. * This code is meant to work for a StudentTracker SE query of an entire entering cohort with. * the search date being prior to the end of the first semester of enrollment. * Please be aware that due to some very subtle differences in processing between SAS and SPSS * there could be some counting differences. These differences were as high as 2 students for a given * year for an institution with 5000 students in the cohort. *Import the ST file; *Note submit_code should equal the 6 digit institutional submission code; *IF YOU DON'T KNOW YOUR SUBMIT CODE THEN LOOK AT YOUR RETURN FILE FOR A STUDENT ENROLLED AT YOUR INSTITUTION * AND USE THAT CODE; **Change the file tree to work with your system**. **An easy way to do this is to copy the file tree out of the address line of Windows Explorer**. *****************************************************************************************************************. *****EDIT HERE EDIT HERE**********************************************. *****************************************************************************************************************. FILE HANDLE ST_IMPORT /NAME="F:\app state\002906ST_T35474.200808290846_CO.csv". **the save command will save the file to the same folder as was used in the import handle***. FILE HANDLE ST_SAVE /NAME="COHORT_DEMO.SAV". *****************************************************************************************************************. *****ONE MORE EDIT BELOW GET DATA COMMAND**********************************************. *****************************************************************************************************************. GET DATA /TYPE = TXT /FILE = ST_IMPORT /DELCASE = LINE /DELIMITERS = "," /QUALIFIER = '"' /ARRANGEMENT = DELIMITED /FIRSTCASE = 2 /IMPORTCASE = ALL /VARIABLES = Your_Unique_Identifier A16 First_Name A20 Middle_Initial A1 Last_Name A20 Name_Suffix F5.0 Requester_Return_Field A50 Record_Found A1 SD1 A8 College_Code_Branch A9 College_Name A40 College_State A2 Year2Year4 F1.0 Public_Private A7 EB1 A8 EE1 A8 Enrollment_Status A1 Graduated A1 GD1 A8 Degree_Title A80 Major A80 College_Sequence F2.0 . COMPUTE ORIG_ROW=$CASENUM. STRING SUBMIT_CODE (A6). *****************************************************************************************************************. *****EDIT HERE EDIT HERE**********************************************. *****************************************************************************************************************. *CREATE AN IDENTIFIER FOR ORIGINAL SCHOOL (this should be file based not hard coded). *****************************************************************************************************************. *****EDIT HERE EDIT HERE**********************************************. *****************************************************************************************************************. COMPUTE SUBMIT_CODE ='002906'. *****************************************************************************************************************. *****************************************************************************************************************. *IF YOU HAVE CHANGED THE FILE LOCATION AND INSERTED A SUBMIT CODE THEN RUN*. ****************************************************************************************************************************************************************************. FILTER OFF. USE ALL. SELECT IF (ANY(Enrollment_Status,'F','H','L') OR Graduated='Y'). EXECUTE. CACHE. EXECUTE. DATASET NAME DataSet1 WINDOW=FRONT. VARIABLE WIDTH ALL (10). *REFORMAT DATES FROM ALPHA TO DATE FORMAT*. COMPUTE SearchDate= DATE.DMY(NUMBER(SUBSTR(SD1,7,2),F2.0),NUMBER(SUBSTR(SD1,5,2),F2.0),NUMBER(SUBSTR(SD1,1,4),F4.0)). COMPUTE EnrollmentBegin= DATE.DMY(NUMBER(SUBSTR(EB1,7,2),F2.0),NUMBER(SUBSTR(EB1,5,2),F2.0),NUMBER(SUBSTR(EB1,1,4),F4.0)). COMPUTE EnrollmentEnd= DATE.DMY(NUMBER(SUBSTR(EE1,7,2),F2.0),NUMBER(SUBSTR(EE1,5,2),F2.0),NUMBER(SUBSTR(EE1,1,4),F4.0)). COMPUTE GraduationDate= DATE.DMY(NUMBER(SUBSTR(GD1,7,2),F2.0),NUMBER(SUBSTR(GD1,5,2),F2.0),NUMBER(SUBSTR(GD1,1,4),F4.0)). COMPUTE Requester_Return_Field=REPLACE(Requester_Return_Field,"_",""). FORMAT SEARCHDATE EnrollmentBegin EnrollmentEnd GraduationDate(ADATE) . EXE. DELETE VARIABLES EB1 EE1 GD1 SD1. *CREATE A SINGULAR FIELD FOR THE DATE OF INTEREST EITHER ENROLLMENT END OR GRAD DATE. *assumes that all grad records do not have an enrollment date (this is currently true). *this is very important for sorting. COMPUTE END_GRAD=ENROLLMENTEND. IF ABS(GRADUATIONDATE )>0 END_GRAD=GRADUATIONDATE. EXE. IF Enrollment_Status=' ' AND GRADUATED = 'Y' Enrollment_Status='G'. EXE. *KEEP MATCHED RECORDS FROM 2 YEAR AND 4 YEAR INSTITUTIONS. select IF (Record_Found = 'Y' AND ANY(Year2Year4,2,4)). FORMAT GRADUATIONDATE EnrollmentEnd EnrollmentBegin SEARCHDATE END_GRAD (ADATE9). *CREATE SCHL_CODE AND BRANCH FROM STFILE. STRING SCHL_CODE (A6). STRING SCHL_BRNCH (A2). COMPUTE SCHL_CODE = SUBSTR(College_Code_Branch,1,6). COMPUTE SCHL_BRNCH = SUBSTR(College_Code_Branch,8,2). EXE. STRING ORG_SCHL (A1). COMPUTE ORG_SCHL = '0'. IF SCHL_CODE = SUBMIT_CODE ORG_SCHL = '1'. EXE. *CREATE A UNIQUE ID (we must have a unique id. If possible can we use SSN before stripping it?). STRING SSN (A9). STRING STPROFIL_TOKEN (A24). COMPUTE SSN=CONCAT (Your_Unique_Identifier,'_'). COMPUTE STPROFIL_TOKEN = SSN. IF (STPROFIL_TOKEN=' ') STPROFIL_TOKEN = CONCAT(First_Name, Middle_Initial, Last_Name,SSN). EXE. *******TIER 1: very certain recodes using substr command. this is faster. STRING DEGREE_TITLE_RENAME (A29). DO IF (SUBSTR(Degree_Title,1,5)) ='ASSOC'. COMPUTE DEGREE_TITLE_RENAME= 'ASSOCIATES'. ELSE IF (SUBSTR(Degree_Title,1,2))='AA'. COMPUTE DEGREE_TITLE_RENAME= 'ASSOCIATES'. ELSE IF Degree_Title='AS'. COMPUTE DEGREE_TITLE_RENAME= 'ASSOCIATES'. ELSE IF (SUBSTR(Degree_Title,1,4))='BACH'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,5))='BA IN'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,4))='B.S.'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,2))='BS'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,4))='B S '. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,5))='B SCI'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,4))='B OF'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,4))='B.A.'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,4))='B A '. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BA'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B A'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BA NONTEACHING'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BA LIBERAL ARTS AND SCIENCE'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,4))='BACCA'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='AB'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B S'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (SUBSTR(Degree_Title,1,5))='MASTE'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (SUBSTR(Degree_Title,1,3))='MBA'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (SUBSTR(Degree_Title,1,6))='M.B.A.'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (SUBSTR(Degree_Title,1,4))='M.S.'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (SUBSTR(Degree_Title,1,4))='M.A.'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (SUBSTR(Degree_Title,1,2))='MS'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (SUBSTR(Degree_Title,1,4))='M S '. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MA'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M S'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M A'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M.S.'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MED'. COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF EDUCATION'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF (SUBSTR(Degree_Title,1,3))='PHD'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF (SUBSTR(Degree_Title,1,5))='PH.D.'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF (SUBSTR(Degree_Title,1,5))='PH D'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF (SUBSTR(Degree_Title,1,5))='CERTI'. COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF (SUBSTR(Degree_Title,1,5))='HONOR'. COMPUTE DEGREE_TITLE_RENAME='HONOR'. ELSE IF (SUBSTR(Degree_Title,1,5))='DIPLOMA'. COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF (SUBSTR(Degree_Title,1,5))='DIMPLOMA'. COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. **********TIER 2: very certain recodes using 'index' AND 'any' commands. this is slower. *index returns an integer that indicates the starting position of the first occurence of a string. *index returns a zero if the string does not occur. *any looks for combinations of letters in words or independent. ELSE IF (CHAR.INDEX(Degree_Title,'DIPLOMA')>0). COMPUTE DEGREE_TITLE_RENAME='HIGH SCHOOL DIPLOMA'. ELSE IF (CHAR.INDEX(Degree_Title,'CERT')>0). COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF (CHAR.INDEX(Degree_Title,'ASSOCIATE')>0). COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF (CHAR.INDEX(Degree_Title,'ASSOC')>0). COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF (CHAR.INDEX(Degree_Title,'A.A.S.')>0). COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF (CHAR.INDEX(Degree_Title,'MASTER')>0). COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (CHAR.INDEX(Degree_Title,'M B A')>0). COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (ANY(Degree_Title ,'MBA') >0). COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (ANY(Degree_Title ,'MSN') >0). COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (ANY(Degree_Title ,'M.S.') >0). COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF (ANY (Degree_Title ,'BACHELOR')>0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'BSB/M') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'BACH') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'B.S.') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'BSN') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'BS') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'BSB/A') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'B.A.') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'BBA') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'BACCALAURI') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title ,'BACCALAUREI') >0). COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF (ANY (Degree_Title,'DOCTOR OF PHILOSOPHY')>0). COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF (ANY(Degree_Title,'DOCTOR OF PHYSICAL THERAPY')>0). COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF (ANY(Degree_Title,'JURIS DOCTOR')>0). COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF (ANY(Degree_Title,'DOCTOR OF JURISPRUDENCE')>0). COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF (ANY(Degree_Title,'DOCTOR OF MEDICINE')>0). COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF DENTAL SURGERY'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF VETERINARY MEDICIN'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF LAW'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF (ANY(Degree_Title,'DOCTOR OF PHARMACY')>0). COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF OSTEOPATHIC MEDICINE'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF DENTAL MEDICINE'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='J D'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF LAW (JURIS DOCTOR)'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='M D'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='D D S'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='D V M'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='JD'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF PODIATRIC MEDICINE'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR IN DENTAL SURGERY'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF DENTISTRY'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='MD'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. ELSE IF Degree_Title='JURIS DOCTORATE'. COMPUTE DEGREE_TITLE_RENAME= 'PROFESSIONAL'. **************TIER 3: prominent matches that must be exact ordered by prevalence in dv system. ELSE IF Degree_Title='STANDARD'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='RECOMMENDED'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='GENERAL'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MINIMUM'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SPECIALIST IN EDUCATION'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BOE - CUM LAUDE'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DIMPLOMA'. COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='REGULAR'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CREDENTIAL'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B S B'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MAOM'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M ED'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='BASIC'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ADVANCED'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='A.AP.S. DEGREE'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='SSOCIATE OF ARTS'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='BACH. OF BUSINESS ADMIN.'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='CANDIDATE IN PHILOSOPHY'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='EDUCATIONAL SPECIALIST'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BA TEACHING'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='GRADUATED'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BOE - MAGNA CUM LAUDE'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='RECOMMENDED HS PRO 9TH 98-99+'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B OF ELECTRICAL ENGINEERING'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='ADDITIONAL MAJOR'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BA IN EDUCATION'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B B A'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B.B.A.'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B OF INDUSTRIAL ENGINEERING'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='EDUCATION SPECIALIST'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B OF MECHANICAL ENGINEERING'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='M OF INTL MGT'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MINIM HS PROG 9TH 95-96.96-97'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='STANDARD HS DIPLOMAT'. COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='BOE - SUMMA CUM LAUDE'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DOCTOR OF OSTEOPATHY'. COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='A.A. DEGREE'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='BAC OF SCI IN EDUCATION'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='ADVANCED STUDIES'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='A.A.S.'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='BFA'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BAC OF SCI'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='AGRICULTURE SHORT COURSE'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B S IN BUSINESS & ECONOMICS'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='CANDIDATE IN PHILOSOPHY (PH C)'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B M E'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B A SC'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DOCTORATE OF MUSICAL ARTS'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='BAM'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='RECOMMENDED HS PROGRAM'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BA-JOURNALISM'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DOCTOR OF OPTOMETRY'. COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF PSYCHOLOGY'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='B S N'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MAED/CI'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='JURIS DOCTORIS'. COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='BAAS'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B E E'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='ARTIUM MAGISTRI'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B OF CIVIL ENGINEERING'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='APPLIED AND LIBERAL ARTS STUDIES'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SPECIALIZATION UNDERGRADUATE'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SSOCIATE OF ARTS'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='MAED/TED-E'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='DISTINGUISHED'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='EDUCATION'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='AWARD OF ACHIEVEMENT'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MAED/ADM'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='ADDITIONAL MAJCOMPUTE'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='A.S.'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='A.A.'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='RHSP'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BAC OF SCI IN BUS ADMIN'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='A A'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='B OF CHEMICAL ENGINEERING'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MAT'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='G22 RECOMMENDED HS PROG SE'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BA IN BUSINESS ADMINISTRATION'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='A A S'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='MA IN EDUCATION'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='PHILOSOPHIAE DOCTORIS'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='RECOMMENDED H S PROG 9TH 97-98'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MPA'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M S W'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='RECOM HS PROG 95-96.96-97'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M P H'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='BAC OF ARTS'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BA IN INTERDIS STDS' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='M.A. IN LIBERAL STUDIES' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='DIP' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='B C E'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B CH E'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MEDICINAE DOCTORIS'. COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='15'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M.ED.' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B.F.A.'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BM'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='LLM - TAXATION' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MPH'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='1'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BESS' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MINIMUM HS 9TH 98-99+' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BA APPL' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BACH/SCI-BUSINESS ADMIN'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='002 TECH PREP'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B ACC'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MA IN TEACHING'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B F A'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='INDIVIDUAL PRESCRIBED PROGRAM' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MAED/TED-S'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='D.V.M.'. COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='GED'. COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='APPRENTICE'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF MINISTRY'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='001 ADVANCED STUDIES'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B S ED'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MINIMUM HS PROGRAM'. COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='HIGH SCHOOL'. COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='APPLIED SCIENCE DEGREE'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BAC OF FINE ARTS'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='A.SCI. DEGREE'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='PHILOSOPHIAE DOCTOR'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='M.A.'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='OCCUPATIONAL CERT-31CR OR MORE'. COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='RECOMMENDED HIGH SCHOOL PROGRAM'. COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='MFA'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='REGULAR GRAD 94-95 BEFORE'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF AUDIOLOGY'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='GRD'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MM' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='#ASSOCIATE IN ARTS'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='GRAD_PCDE22'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BGS'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='PHARM D'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='M.B.A.'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='CONCENTRATION GRADUATE'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BVSC'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MINIMUM H S 9TH 97-98'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B S IN MECHANICAL ENGINEERING' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MA-LIBRARY & INFORMATION STDYS'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='AS IN NURSING'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='B S PHARM'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MAED/AS'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B OF AEROSPACE ENGINEERING' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BA IN LIBERAL STUDIES'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MHSP'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='HRM'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MULTIPLE SUBJECT TEACHING'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MAED/COUN'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MA IN CHRISTIAN ED'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B ARCH' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MINOR' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTORATE'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='ASC IN ARTS & SCIENCES-PLAN B#' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='LETTER OF RECOGNITION'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DR OF OSTEOPATHIC MEDICINE'. COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='BCH SCI CRIM JUST' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='SINGLE SUBJECT TEACHING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B COMP SC' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='M S E E'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B A E M' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='CERTFICATE OF COMPLETION' . COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='A.G.S. DEGREE'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='REGULAR DIPLOMA, NO CIM' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='NURSING (LPN)'. COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='MAED/CT' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M.A. IN TEACHING'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B I S' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='J.D.'. COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='ADV'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MAED/ECN' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MAED/AEDL'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B.L.S.'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MEL' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='SIXTH YEAR PROGRAM'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DIPLOMA(IPEDS PROGRAM LENGTH)'. COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='003 ADV. STUDIES & TECH PREP' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='PRACTICAL NURSING CERT.'. COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='COURSEWORK COMPLETED'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='A.B. INTERNATIONAL STUDIES'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BA IN JOURNALISM'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BACH. OF SCI. IN ELEC. ENG.' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B S IN ELECTRICAL ENGINEERING' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='CTF. OF ADVANCED STUDY'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B A A'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BACHELOR OF SCIENCE, NURSING'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='A L A' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ASOC IN SEC SCIENCES'. COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='B S IN INDUSTRIAL ENGINEERING'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DMIN (THEOLOGY SCHOOL)'. COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='POST-BACCALAUREATE PROGRAM'. COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MAED/DL' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B S A S'. COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DOCTOR OF NATUROPATHIC MEDICINE' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='MHA'. COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MC' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='SHORT-TERM CERTIFICATE<26'. COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='GRADUATE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ADVANCED TECHNICAL CERT.'. COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='B A S' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DPH' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='RN COMPLETION' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CORE 40 ONLY (PASSED GQE)' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BACH. OF ENGR. TECH.' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B MUS' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='TED/S' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MDIV IN MISSIONS' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='TECHNICAL/CAREER' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SECOND MAJOR COMPLETION' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='G D H' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ASOC IN BUS ADMINIS' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='DOCTOR OF ARTS' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='TED/CLAD' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='REG' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M H A' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='BA/ED' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B S IN CIVIL ENGINEERING' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='M F A' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='NURSING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M S M E' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='COLLEGE PREPARATORY' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SPECIALIST IN SCHOOL PSYCHOLOGY' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MDIV IN CHRISTIAN ED' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M.EDUC' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='A.S. IN NURSING' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='DOCTOR OF SCIENCE' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='DOCTOR IN EDUCATION' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='ADJUSTED' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B S IN CHEMICAL ENGINEERING' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B.ARCH' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DOCTOR OF PUBLIC HEALTH' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='B S IN ENGINEERING TECHNOLOGY' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='G23 DISTINGUISHED AP SE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BUS' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DOCTOR OF DENISTRY' . COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='DIPLOMA, 2-YEAR' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='B OF SCIENCE' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DOCTORATE OF PHILOSOPHY' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='DIPLOMA(IPEDS PRG LENGTH)' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='OPTION UNDERGRADUATE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='REGENTS' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BA IN EDUC & TECH' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='13' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MOD GRAD REQ' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA IN CHRISTIAN EDUCATION' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='REQUIREMENTS MET' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M. A. IN APPLIED BEHAVIORAL SCIENCE' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B MATH' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MAED/SPE' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='SECOND BACHELORS' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='M.ED' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B E S' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='G21 MINIMUM HS PROGRAM SE' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='CANDIDATE IN PHILOSOPHY (PHC)' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR IN DENTAL SURGERY DENTISTRY' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='AET' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='REGULAR (PASSED GQE)' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SPECIALIST' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='INITIAL LICENSURE' . COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='A.S.IN BUSINESS' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='MA-ENGLISH' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='LEGUM MAGISTRI' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M ARCH' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B E D' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B G S' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='ENGINEER' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DR OF BUSINESS ADMINISTRATION' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='ACADEMIC HONORS (PASSED GQE)' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DISTINGUISHED ACHIEVEMENT PROGRAM' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='LLM - INTL & COMPARATIVE LAW' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M B T' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MAED/ECH' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='ADVANCED HONORS' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B.L.A.' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BACHELOR OF SCIENCE, ENGINEERING' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='PM' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='A.B.' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MA-HISTORY' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='DOCTOR OF ENGINEERING' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='ACAD HONORS & CORE 40 (PASSED GQE)' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SPECIAL EDUCATION' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ATA NURSING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='NOT APPLICABLE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M.D.' . COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='B U S' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MHSDE DIMPLOMA' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='M M' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='EDS EDUCATION SPECIALIST' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MAST OF PROF STUDIES' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MAMHROB' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ADULT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='AS IN DENTAL HYGIENE' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='BOE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='HIGH SCHOOL GRADUATE' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='005 SPECIAL' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ME' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SECOND MAJOR' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MIS/M' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MAST OF INDUSTL DES' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='DM' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='TED/E' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DR. OF OSTEOPATHIC MED.' . COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF PHILOSPHY' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='L L M' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='LLM - SEC AND FINANCIAL REG' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MIS' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='A.S. IN DENTAL HYGIENE' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='SIXTH YEAR' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='PHYSICIAN ASSISTANT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MUSB' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BAIS' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ED D' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='B PHYS' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B CHEM' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='ADULT HIGH SCHOOL' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='DOCTOR OF EDUCATION' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='GRADUATED- IN COLLEGE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA-MATHEMATICS' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='COLLEGE PREP/CAREER TECH' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='TYPE/D' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='PRACTICAL NURSING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='AD NURSING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B.G.S.' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M P T' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='EDUCATORS ENDORSEMENT IN' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DIPLOMA/2 YEARS' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='BAC OF SCI IN NURSING' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MA-PUBLIC POLICY & ADMIN' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='SPECIALIST IN EDUCATION DEGREE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF DENTAL SCIENCE' . COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='MA-POLITICAL SCIENCE' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='TRUCK DRIVER TRAINING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B L A' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF PHILOS-THEOLOGY' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='BHA' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='NCATE ACCRED:ST APPRVD PRGM/ICP' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B COMP E' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MM/HRM' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA IN PASTORAL STUDIES' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='EDD' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='FIRST PROFESSIONAL' . COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='BA EDUCATION' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B. S. IN NATURAL HEALTH SCIENCES' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='004 VOCATIONAL' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MACC' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M IND SAFE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MC/MHC' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTORATE OF DENTAL MEDICINE' . COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='ASSICUATE OF ARTS' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='REG WITHOUT HONCOMPUTES' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M P P' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='PROGRAM COMPLETION' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='VOCATIONAL NURSING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='LICENSURE' . COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='BCH ARTS CRIM JUS' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='SP ED 1-6: INITIAL' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA EDUCATION' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='A.ENG. DEGREE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SPECIAL' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='EDD DOCTORATE OF EDUCATION' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='LICENSURE ONLY' . COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='MDIV IN CHRISTIAN EDUC' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M.ENGR' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='COMP IEP' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='TQS' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='PMT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MAED/EDTC' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='009 NORFOLK PREPARATORY HIGH SCH' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='GENERAL STUDIES DEGREE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA ED' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MAST OF ARCHITECTRE' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M.ENGR.' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='TQM' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='OD' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA-BUSINESS' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M.P.A.' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='DOCTOR OF CHIROPRACTIC' . COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='1' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='NON GRADUATE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ISAEP GED' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DMIN (THEOLOGY)' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='AD ARTS & SCIENCE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='TEACHING ENGLISH AS A SECOND L' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CHILDHOOD 1-6:INITIAL' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='VOCATIONAL CREDIT ONLY' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DPT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MAGEO' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='PRACTICAL NURSING (L.P.N.)' . COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='GRAD- REGENTS DIPL. W/ ADV DESIG' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CORE 40' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CORE COMPLETE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M P A' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='A.A. IN BUSINESS ADMIN' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='COMMERCIAL CUSTODIAL TRAINING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='LICENSURE PREPARATION INITIAL' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCT PHYSICAL THERAPY' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='GRAD- REGENTS DIPL. (2001 COHORT OR YOUNGER)' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='CAREER TECHNOLOGY' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MC/MFCC' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B.MUSIC' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DDS'. COMPUTE DEGREE_TITLE_RENAME='PROFESSIONAL'. ELSE IF Degree_Title='DOCTOR OF ENGINEERING SCIENCE' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='MAED/CURR' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M.ARCH' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='AS BUSINESS ADMINISTRATION' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='BPH IN COMMUNICATION' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='ASC ARTS & SCIENCES/PLAN B-DTA' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='M.ARCH.' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='DOCTOR OF SCIENCE IN NURSING' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='DR. OF PHILOSOPHY' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='THM (THEOLOGY SCHOOL)' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='A.S. IN RESPIRATORY THERAPY' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='VSC' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='GCM' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M. S. IN ACUPUNCTURE' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='LEGUM MAGISTER' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M.P.H.' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M LIB STU' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MAST. OF SCI.-COMP & INFO SCISMS CIS' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MAST. OF SCIENCE SPEECH & HEARMS SH' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='SPECIALIZATION GRADUATE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BB' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA-JOURNALISM & MASS COMMUNIC' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B I E' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='B GEO E' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='LLM - INTL LEGAL STUDIES' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='IEP' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='007 G.E.D.' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MCP' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='AS ENGINEERING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MACY' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DIST ACH PRO 9TH 95-96.96-97' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MDIV' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='UNKNOWN' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA-COMMUNICATION ARTS' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='A.TECH. DEGREE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA IN PSYCHOLOGY' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MA IN THEOLOGICAL STUDIES' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='THEMATIC UNDERGRADUATE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CRT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='EDUCATIONAL DOCTORATE' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='ASOC OF ARTS/GEN STUDIES' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='B MAT SCI/E' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='SHRM' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DMIN (GRAHAM SCHOOL)' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='NONE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='COSMETOLOGY' . COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='LLM - LABOR AND EMPLOYMENT LAW' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA-ANTHROPOLOGY' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='DOCTOR OF THE SCIENCE OF LAW' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='MAED/ACE' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M.E.D.' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='ACCOUNTING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CHILD DEVELOPMENT CT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='INITIAL PRINCIPAL' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SPECIALIST IN EDUC' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DAP' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ADVANCED GRADUATE SPECIALIST' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='A/AS NURSING' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='REGENTS W/O HONORS' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='LOCAL DPL WITHOUT REG ENDCOMPUTES' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF BUSINESS ADMINISTRATION' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='EDS' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SPECIALIST IN EDUCATON' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='NURSING - AAAS-T' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='PHARD' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF OCCUPATIONAL THERAPY' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='B AG E' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='MPT' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B.MUS.' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='PROFESSIONAL DEVELOPMENT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='VOCATIONAL SPECIALIST' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='PH.D' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='MC/PR' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MA-ART' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='SP ED 1-6: PROF' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA-SPANISH' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='D M A' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M. S. IN NUTRITION' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MC/MFCT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='A S' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='COMP IEP MASTERY OF EMPLOYBLT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M.F.A.' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='REGENTS DPL WITHOUT HONCOMPUTES' . COMPUTE DEGREE_TITLE_RENAME='DIPLOMA'. ELSE IF Degree_Title='STANDARD SECONDARY SCHOOL TEACHING' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='D P T' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='A/AS BUSINESS MANAGEMENT' . COMPUTE DEGREE_TITLE_RENAME='ASSOCIATES'. ELSE IF Degree_Title='PROFESSIONAL DEGREE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF SOCIAL WELFARE' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='BOTH COLL PREP & TECH/CAR' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MAST OF HLTHCARE ADM' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='V' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M.C.R.P.' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MDT/400' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='M AG' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='SPECIALIST IN ARTS' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF JURIDICAL SCIENCE' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='BMUS' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DUAL/MGT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='TECHNOLOGY/CAREER' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA-PHILOSOPHY' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='M HC A' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='B.ARCH.' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='BA ELEM EDUC/INTER STUDY' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DOCTORATE OF PHYSICAL THERAPY' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='CEERTIFICATE OF ADVANCED GRADUATE STUDY' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CONTINUING STUDIES DEGREE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BASIC VOCATIONAL SPECIALIST' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DISTING ACH PRO 9TH 98-99+' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BAFA' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='N/A' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ASN' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF MUSIC' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='BME' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='B.L.ARCH.' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='NATIONAL SCIENCE FOUNDATION' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='(DNU) B S ENGR TECH' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='LEARNING RESOURCES ENDORSEMENT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA-GERMAN' . COMPUTE DEGREE_TITLE_RENAME='MASTERS'. ELSE IF Degree_Title='MMT' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DR OF PHILOSOPHY' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='BET MECHANICAL ENGINEERING TECH' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. ELSE IF Degree_Title='DOCTOR OF NURSING' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='PHARMD' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='CTF. OF PACE PROGRAM' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DMD' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MCSE' . COMPUTE DEGREE_TITLE_RENAME='CERTIFICATE'. ELSE IF Degree_Title='POST-BACCALAUREATE MAJOR' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MN/E' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='MA-FRENCH' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ADV.' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='ATA HUMAN SERVICES' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='GRAD- REGENTS DIPL. (2000 COHORT OR OLDER)' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='CHILDHOOD 1-6:PROF' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='COLLEGE PREP' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='DOCTOR OF NURSING SCIENCE' . COMPUTE DEGREE_TITLE_RENAME='PH.D.'. ELSE IF Degree_Title='OPTION UNDERGRADUATE' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='REGENTS' . COMPUTE DEGREE_TITLE_RENAME='UNIDENTIFIABLE'. ELSE IF Degree_Title='BA IN EDUC & TECH' . COMPUTE DEGREE_TITLE_RENAME='BACHELORS'. *NOW ABSOLUTE RECODE FOR NON CATEGORIZED TITLES. *for any non dv and a small percentage of DV not classified this will make the assumption. *that a four year school gives a four year degree and a two year school gives a two year degree. ELSE IF Year2Year4=4. COMPUTE DEGREE_TITLE_RENAME='FOUR YEAR'. ELSE IF Year2Year4=2. COMPUTE DEGREE_TITLE_RENAME='TWO YEAR'. END IF. EXE. *************************************************************************************. *************************************************************************************. * NOW MAKE CONDITIONS FOR THE FILE AND SORT IT TO GET ONLY VALID CASES. ***********GRAD FROM ORIGINAL INST 4YEAR. DO IF Enrollment_Status='G' AND SCHL_CODE=SUBMIT_CODE AND ANY(DEGREE_TITLE_RENAME, 'FOUR YEAR','BACHELORS','MASTERS','PH.D.','PROFESSIONAL')>0. COMPUTE CONDITION=1.2. ***********GRAD FROM ORIGINAL INST 2YEAR. ELSE IF Enrollment_Status='G' AND SCHL_CODE=SUBMIT_CODE AND ANY (DEGREE_TITLE_RENAME,'TWO YEAR','ASSOCIATES')>0. COMPUTE CONDITION=1.4. ***********GRAD FROM OTHER FOUR YEAR . ELSE IF Enrollment_Status='G' AND SCHL_CODE ~= SUBMIT_CODE AND ANY(DEGREE_TITLE_RENAME, 'FOUR YEAR','BACHELORS','MASTERS','PH.D.','PROFESSIONAL')>0. COMPUTE CONDITION=2. ************GRAD FROM OTHER TWO YEAR. ELSE IF Enrollment_Status='G' AND ANY (DEGREE_TITLE_RENAME,'TWO YEAR','ASSOCIATES')>0. COMPUTE CONDITION=4. ***********RETAINED WITH ORIGINAL INST. ELSE IF Enrollment_Status ~= 'G' AND SCHL_CODE=SUBMIT_CODE. COMPUTE CONDITION=11. ***********RETAINED WITH OTHER INSTATE 4 YEAR. ELSE IF Enrollment_Status ~= 'G' AND SCHL_CODE ~= SUBMIT_CODE AND Year2Year4=4. COMPUTE CONDITION=22. ***********RETAINED WITH OTHER INSTATE 2 YEAR. ELSE IF Enrollment_Status ~= 'G' AND SCHL_CODE ~= SUBMIT_CODE AND Year2Year4=2. COMPUTE CONDITION=44. ***********ALL CONDITION CHECK. ELSE IF SYSMIS(CONDITION). COMPUTE CONDITION = 99. END IF. EXE. ***********Label the variable 'condition' and provide value labels per response. VARIABLE LABELS CONDITION 'Enrollment/Completion Outcome'. VALUE LABELS CONDITION 1.2 '1A.Graduated from your institution four-year degree' 1.4 '1B.Graduated from your institution two-year degree' 2 '2.Graduated from other four-year' 4. '3.Graduated from other two-year' 11 '4.Retained at your institution' 22 '5.Retained at other four-year' 44 '6. Retained at other two-year' 99 'Missing data'. ******************************************************************************************************************************************. *CREATE ACADEMIC YEARS. *USE SEARCH MONTH AND DAY TO ALLOW DYNAMIC WINDOWING SO THAT INSTITUTIONS MAY CHOOSE WHERE THEIR YEAR. *BEGINS AND ENDS. IDEALLY THIS SHOULD USE THE SEARCH DT IN THE FILE. *ISSUE: WE WILL HAVE TO TRAIN OUR USERS TO USE THE SAME SEARCH DATE FOR A COHORT. *THIS WILL ACCOMODATE INSTITUTIONS WITH A SINGLE COHORT IN MULTIPLE SCHOOLS WITH VARYING ACADEMIC CALENDARS. ******************************************************************************************************************************************. STRING REP_YR (A7). DO IF END_GRAD>= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1990) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1991) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1992) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1993) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1994) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1995) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1996) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1997) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1998) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),1999) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2000) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2001) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2002) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2003) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2004) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2005) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2006) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2007) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2008) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2009) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2010) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2011) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2012) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2013) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2014) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2015) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2016) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2017) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2018) AND END_GRAD= DATE.MDY(XDATE.MONTH(SEARCHDATE),XDATE.MDAY(SEARCHDATE),2019) AND END_GRAD