/* 	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. 
*/

*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;

DATA STFILE ;
	LENGTH STPROFIL_TOKEN $85 SCHL_CODE $6. SCHL_BRNCH $2.;
			SUBMIT_CODE='XXXXXX';
		INFILE 'C:\SAS\yourfile.csv'
			DLM=',' DSD FIRSTOBS=2 LRECL=500;
			INFORMAT Enrollment_End Enrollment_Begin SEARCH_DATE Graduation_Date YYMMDD8.;
 				INPUT 
					Your_Unique_Identifier		:$16.
					First_Name					:$20.
					Middle_Initial				:$1.
					Last_Name					:$20.
					Name_Suffix					:$5.
					Requester_Return_Field		:$50.
					RECORD_FOUND				:$1.
					Search_Date					:YYMMDD8.
					College_Code_Branch			:$9.
					College_Name				:$40.
					College_State				:$2.
					Year2Year4					:$1.
					Public_Private				:$7.
					Enrollment_Begin			:YYMMDD8.
					Enrollment_End				:YYMMDD8.
					Enrollment_Status			:$1.
					Graduated					:$1.
					Graduation_Date				:YYMMDD8.
					Degree_Title				:$80.
					Major						:$80.
					College_Sequence			:2.;
					ORIG_ROW = _N_;
*KEEP MATCHED RECORDS FROM 2 YEAR AND 4 YEAR INSTITUTIONS;
			IF RECORD_FOUND='Y' AND Year2Year4 IN ('2','4');
			IF ENROLLMENT_STATUS IN ('F','H','L') OR GRADUATED='Y';
			FORMAT GRADUATION_DATE Enrollment_End Enrollment_Begin  SEARCH_DATE END_GRAD DATE9.;
*CREATE SCHL_CODE AND BRANCH FROM STFILE;
			SCHL_CODE=SUBSTR(COLLEGE_CODE_BRANCH,1,6);
			SCHL_BRNCH=SUBSTR(COLLEGE_CODE_BRANCH,8,2);
*CREATE AN IDENTIFIER FOR ORIGINAL SCHOOL (this should be file based not hard coded);
			ORIG_SCHL=0;
			IF SCHL_CODE=SUBMIT_CODE	THEN ORIG_SCHL=1;
*CREATE A UNIQUE ID (we must have a unique id.  If possible can we use SSN before stripping it?);
			SSN=compress(Your_Unique_Identifier,'_');
			STPROFIL_TOKEN=SSN;
			IF STPROFIL_TOKEN='' THEN 
			STPROFIL_TOKEN=COMPRESS(first_name||middle_initial||last_name||name_suffix||ssn);
*NOW 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 (currently true);
			*this is very important for sorting.  ;
			END_GRAD=ENROLLMENT_END;
			IF 	GRADUATION_DATE NE . THEN END_GRAD=GRADUATION_DATE;
			IF ENROLLMENT_STATUS="" AND GRADUATED='Y' THEN ENROLLMENT_STATUS="G";
*************************************************************************************;
*************************************************************************************;
			/*this code reclassifies degree titles for the dv schools.  
	Non dv's and uncoded degree titles will have to use the 2/4 as an indicator*/
*************************************************************************************;
*************************************************************************************;
			*TIER 1: VERY CERTAIN RECODES USING SUBSTR COMMAND WHICH IS FASTER;
		IF 		SUBSTR(degree_title,1,5)='ASSOC' 			THEN DEGREE_TITLE_RENAME='ASSOCIATES';
		ELSE IF SUBSTR(degree_title,1,2)='AA' 				THEN DEGREE_TITLE_RENAME='ASSOCIATES';
		ELSE IF degree_title='AS'							THEN DEGREE_TITLE_RENAME='ASSOCIATES';

		ELSE IF SUBSTR(degree_title,1,4)='BACH' 			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF SUBSTR(degree_title,1,5)='BA IN' 			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF SUBSTR(degree_title,1,4)='B.S.' 			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF SUBSTR(degree_title,1,2)='BS' 				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF SUBSTR(degree_title,1,4)='B S '				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF SUBSTR(degree_title,1,5)='B SCI'			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF SUBSTR(degree_title,1,4)='B OF'				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF SUBSTR(degree_title,1,4)='B.A.' 			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF SUBSTR(degree_title,1,4)='B A ' 			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF degree_title='BA' 							THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF degree_title='B A' 							THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF degree_title='BA NONTEACHING' 				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF degree_title='BA  LIBERAL ARTS AND SCIENCE' THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF SUBSTR(degree_title,1,4)='BACCA'			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF degree_title='AB' 							THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF degree_title='B S'							THEN DEGREE_TITLE_RENAME='BACHELORS';

		ELSE IF SUBSTR(degree_title,1,5)='MASTE' 			THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF SUBSTR(degree_title,1,3)='MBA' 				THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF SUBSTR(degree_title,1,6)='M.B.A.' 			THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF SUBSTR(degree_title,1,4)='M.S.' 			THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF SUBSTR(degree_title,1,4)='M.A.' 			THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF SUBSTR(degree_title,1,2)='MS' 				THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF SUBSTR(degree_title,1,4)='M S ' 			THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF degree_title='MA' 							THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF degree_title='M S' 							THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF degree_title='M A' 							THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF degree_title='M.S.' 						THEN DEGREE_TITLE_RENAME='MASTERS';

		ELSE IF degree_title='MED'	 						THEN DEGREE_TITLE_RENAME='PROFESSIONAL';
		
		ELSE IF degree_title='DOCTOR OF EDUCATION'			THEN DEGREE_TITLE_RENAME='PH.D.';
		ELSE IF SUBSTR(degree_title,1,3)='PHD' 				THEN DEGREE_TITLE_RENAME='PH.D.';
		ELSE IF SUBSTR(degree_title,1,5)='PH.D.'			THEN DEGREE_TITLE_RENAME='PH.D.';
		ELSE IF SUBSTR(degree_title,1,5)='PH D'				THEN DEGREE_TITLE_RENAME='PH.D.';
		ELSE IF SUBSTR(degree_title,1,5)='CERTI'			THEN DEGREE_TITLE_RENAME='CERTIFICATE';
		ELSE IF SUBSTR(degree_title,1,5)='HONOR' 			THEN DEGREE_TITLE_RENAME='HONOR';

		ELSE IF SUBSTR(degree_title,1,5)='DIPLOMA' 			THEN DEGREE_TITLE_RENAME='DIPLOMA';
		ELSE IF SUBSTR(degree_title,1,5)='DIMPLOMA' 		THEN DEGREE_TITLE_RENAME='DIPLOMA';

			*TIER 2: VERY CERTAIN RECODES USING INDEX COMMANDS WHICH IS SLOWER;
			*INDEXW LOOKS FOR WHOLE WORD;
			*INDEX LOOKS FOR COMBINATION OF LETTERS WITHIN WORDS OR INDEPENDENT;
		ELSE IF INDEX(degree_title ,'DIPLOMA')>0 			THEN DEGREE_TITLE_RENAME="HIGH SCHOOL DIPLOMA";

		ELSE IF INDEX(degree_title ,'CERT')>0 			THEN DEGREE_TITLE_RENAME="CERTIFICATE";
		
		
		ELSE IF INDEX(degree_title ,'ASSOCIATE') >0		THEN DEGREE_TITLE_RENAME='ASSOCIATES';
		ELSE IF INDEX(degree_title ,'ASSOC') >0			THEN DEGREE_TITLE_RENAME='ASSOCIATES';
		ELSE IF INDEX(degree_title ,'A.A.S') >0			THEN DEGREE_TITLE_RENAME='ASSOCIATES';
	
		ELSE IF INDEX(degree_title ,'MASTER') >0			THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF SUBSTR(DEGREE_TITLE,1,5)='M B A' 			THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF INDEXW(degree_title ,'MBA') >0				THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF INDEXW(degree_title ,'MSN') >0				THEN DEGREE_TITLE_RENAME='MASTERS';
		ELSE IF INDEXW(degree_title ,'M.S.') >0				THEN DEGREE_TITLE_RENAME='MASTERS';

		ELSE IF INDEXW(degree_title ,'BACHELOR') >0			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'BSB/M') >0			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'BACH') >0				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'B.S.') >0				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'BSN') >0				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'BS') >0				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'BSB/A') >0			THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'B.A.') >0				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'BBA') >0				THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'BACCALAURI') >0		THEN DEGREE_TITLE_RENAME='BACHELORS';
		ELSE IF INDEXW(degree_title ,'BACCALAUREI') >0		THEN DEGREE_TITLE_RENAME='BACHELORS';

		ELSE IF INDEXW(degree_title ,'DOCTOR OF PHILOSOPHY') >0			THEN DEGREE_TITLE_RENAME='PH.D.';
		ELSE IF INDEXW(degree_title ,'DOCTOR OF PHYSICAL THERAPY') >0	THEN DEGREE_TITLE_RENAME='PH.D.';
		
		ELSE IF INDEXW(degree_title ,'JURIS DOCTOR') >0					THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF INDEXW(degree_title ,'DOCTOR OF JURISPRUDENCE') >0		THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF INDEXW(degree_title ,'DOCTOR OF MEDICINE') >0			THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='DOCTOR OF DENTAL SURGERY' 				THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='DOCTOR OF VETERINARY MEDICINE' 			THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='DOCTOR OF LAW' 							THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF INDEXW(degree_title ,'DOCTOR OF PHARMACY') >0			THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='DOCTOR OF OSTEOPATHIC MEDICINE' 			THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='DOCTOR OF DENTAL MEDICINE' 				THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='J D' 										THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='DOCTOR OF LAW (JURIS DOCTOR)' 			THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='M D' 										THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='D D S' 									THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='D V M' 									THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='JD' 										THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='DOCTOR OF PODIATRIC MEDICINE' 			THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='DOCTOR IN DENTAL SURGERY' 				THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='DOCTOR OF DENTISTRY' 						THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='MD' 										THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
		ELSE IF DEGREE_TITLE='JURIS DOCTORATE' 							THEN DEGREE_TITLE_RENAME= 'PROFESSIONAL';
	
	
*TIER 3: PROMINENT MATCHES THAT MUST BE EXACT ORDERED BY PREVALENCE IN DV SYSTEM;	
ELSE IF DEGREE_TITLE="STANDARD" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="RECOMMENDED" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="GENERAL" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MINIMUM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SPECIALIST IN EDUCATION" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BOE - CUM LAUDE" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DIMPLOMA" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="REGULAR" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CREDENTIAL" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B S B" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MAOM" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M ED" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="BASIC" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ADVANCED" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="A.AP.S. DEGREE" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="SSOCIATE OF ARTS" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="BACH. OF BUSINESS ADMIN." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="CANDIDATE IN PHILOSOPHY" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="EDUCATIONAL SPECIALIST" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BA TEACHING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="GRADUATED" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BOE - MAGNA CUM LAUDE" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="RECOMMENDED HS PRO 9TH 98-99+" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B OF ELECTRICAL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="ADDITIONAL MAJOR" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BA IN EDUCATION" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B B A" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B.B.A." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B OF INDUSTRIAL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="EDUCATION SPECIALIST" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B OF MECHANICAL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="M OF INTL MGT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MINIM HS PROG 9TH 95-96;96-97" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="STANDARD HS DIPLOMAT" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="BOE - SUMMA CUM LAUDE" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DOCTOR OF OSTEOPATHY" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="A.A. DEGREE" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="BAC OF SCI IN EDUCATION" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="ADVANCED STUDIES" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="A.A.S." THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="BFA" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BAC OF SCI" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="AGRICULTURE SHORT COURSE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B S IN BUSINESS & ECONOMICS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="CANDIDATE IN PHILOSOPHY (PH C)" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B M E" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B A SC" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DOCTOR OF MUSICAL ARTS" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="BAM" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="RECOMMENDED HS PROGRAM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BA-JOURNALISM" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DOCTOR OF OPTOMETRY" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="DOCTOR OF PSYCHOLOGY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="B S N" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MAED/CI" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="JURIS DOCTORIS" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="BAAS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B E E" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="ARTIUM MAGISTRI" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B OF CIVIL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="APPLIED AND LIBERAL ARTS STUDIES" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SPECIALIZATION UNDERGRADUATE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SSOCIATE OF ARTS" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="MAED/TED-E" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="DISTINGUISHED" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="EDUCATION" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="AWARD OF ACHIEVEMENT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MAED/ADM" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="ADDITIONAL MAJOR OR MINOR" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="A.S." THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="A.A." THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="RHSP" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BAC OF SCI IN BUS ADMIN" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="A A" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="B OF CHEMICAL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MAT" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="G22 RECOMMENDED HS PROG SE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BA IN BUSINESS ADMINISTRATION" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="A A S" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="MA IN EDUCATION" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="PHILOSOPHIAE DOCTORIS" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="RECOMMENDED H S PROG 9TH 97-98" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MPA" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M S W" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="RECOM HS PROG 95-96;96-97" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M P H" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="BAC OF ARTS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BA IN INTERDIS STDS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="M.A. IN LIBERAL STUDIES" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="DIP" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="B C E" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B CH E" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MEDICINAE DOCTORIS" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="15" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M.ED." THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B.F.A." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BM" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="LLM - TAXATION" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MPH" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="1" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BESS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MINIMUM HS 9TH 98-99+" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BA APPL" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BACH/SCI-BUSINESS ADMIN" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="002 TECH PREP" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B ACC" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MA IN TEACHING" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B F A" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="INDIVIDUAL PRESCRIBED PROGRAM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MAED/TED-S" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="D.V.M." THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="GED" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="APPRENTICE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF MINISTRY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="001 ADVANCED STUDIES" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B S ED" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MINIMUM HS PROGRAM" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="HIGH SCHOOL" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="APPLIED SCIENCE DEGREE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BAC OF FINE ARTS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="A.SCI. DEGREE" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="PHILOSOPHIAE DOCTOR" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="M.A." THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="OCCUPATIONAL CERT-31CR OR MORE" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="RECOMMENDED HIGH SCHOOL PROGRAM" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="MFA" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="REGULAR GRAD 94-95 OR BEFORE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF AUDIOLOGY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="GRD" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MM" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="#ASSOCIATE IN ARTS" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="GRAD_PCDE22" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BGS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="PHARM D" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="M.B.A." THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="CONCENTRATION GRADUATE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BVSC" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MINIMUM H S 9TH 97-98" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B S IN MECHANICAL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MA-LIBRARY & INFORMATION STDYS" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="AS IN NURSING" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="B S PHARM" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MAED/AS" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B OF AEROSPACE ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BA IN LIBERAL STUDIES" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MHSP" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="HRM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MULTIPLE SUBJECT TEACHING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MAED/COUN" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MA IN CHRISTIAN ED" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B ARCH" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MINOR" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTORATE" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="ASC IN ARTS & SCIENCES-PLAN B#" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="LETTER OF RECOGNITION" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DR OF OSTEOPATHIC MEDICINE" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="BCH SCI CRIM JUST" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="SINGLE SUBJECT TEACHING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B COMP SC" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="M S E E" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B A E M" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="CERTFICATE OF COMPLETION" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="A.G.S. DEGREE" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="REGULAR DIPLOMA, NO CIM" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="NURSING (LPN)" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="MAED/CT" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M.A. IN TEACHING" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B I S" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="J.D." THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="ADV" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MAED/ECN" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MAED/AEDL" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B.L.S." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MEL" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="SIXTH YEAR PROGRAM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DIPLOMA(IPEDS PROGRAM LENGTH)" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="003 ADV. STUDIES & TECH PREP" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="PRACTICAL NURSING CERT." THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="COURSEWORK COMPLETED" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="A.B. INTERNATIONAL STUDIES" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BA IN JOURNALISM" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BACH. OF SCI. IN ELEC. ENG." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B S IN ELECTRICAL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="CTF. OF ADVANCED STUDY" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B A A" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BACHELOR OF SCIENCE, NURSING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="A L A" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ASOC IN SEC SCIENCES" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="B S IN INDUSTRIAL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DMIN (THEOLOGY SCHOOL)" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="POST-BACCALAUREATE PROGRAM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MAED/DL" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B S A S" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DOCTOR OF NATUROPATHIC MEDICINE" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="MHA" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MC" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="SHORT-TERM CERTIFICATE<26" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="GRADUATE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ADVANCED TECHNICAL CERT." THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="B A S" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DPH" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="RN COMPLETION" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CORE 40 ONLY (PASSED GQE)" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BACH. OF ENGR. TECH." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B MUS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="TED/S" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MDIV IN MISSIONS" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="TECHNICAL/CAREER" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SECOND MAJOR COMPLETION" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="G D H" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ASOC IN BUS ADMINIS" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="DOCTOR OF ARTS" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="TED/CLAD" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="REG" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M H A" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="BA/ED" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B S IN CIVIL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="M F A" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="NURSING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M S M E" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="COLLEGE PREPARATORY" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SPECIALIST IN SCHOOL PSYCHOLOGY" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MDIV IN CHRISTIAN ED" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M.EDUC" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="A.S. IN NURSING" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="DOCTOR OF SCIENCE" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="DOCTOR IN EDUCATION" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="ADJUSTED" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B S IN CHEMICAL ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B.ARCH" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DOCTOR OF PUBLIC HEALTH" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="B S IN ENGINEERING TECHNOLOGY" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="G23 DISTINGUISHED AP SE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BUS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DOCTOR OF DENISTRY" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="DIPLOMA, 2-YEAR" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="B OF SCIENCE" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DOCTORATE OF PHILOSOPHY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="DIPLOMA(IPEDS PRG LENGTH)" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="OPTION UNDERGRADUATE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="REGENTS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BA IN EDUC & TECH" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="13" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MOD GRAD REQ" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA IN CHRISTIAN EDUCATION" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="REQUIREMENTS MET" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M. A. IN APPLIED BEHAVIORAL SCIENCE" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B MATH" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MAED/SPE" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="SECOND BACHELOR'S" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="M.ED" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B E S" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="G21 MINIMUM HS PROGRAM SE" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="CANDIDATE IN PHILOSOPHY (PHC)" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR IN DENTAL SURGERY      DENTISTRY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="AET" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="REGULAR (PASSED GQE)" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SPECIALIST" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="INITIAL LICENSURE" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="A.S.IN BUSINESS" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="MA-ENGLISH" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="LEGUM MAGISTRI" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M ARCH" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B E D" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B G S" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="ENGINEER" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DR OF BUSINESS ADMINISTRATION" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="ACADEMIC HONORS (PASSED GQE)" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DISTINGUISHED ACHIEVEMENT PROGRAM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="LLM - INT'L & COMPARATIVE LAW" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M B T" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MAED/ECH" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="ADVANCED HONORS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B.L.A." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BACHELOR OF SCIENCE, ENGINEERING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="PM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="A.B." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MA-HISTORY" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="DOCTOR OF ENGINEERING" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="ACAD HONORS & CORE 40 (PASSED GQE)" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SPECIAL EDUCATION" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ATA NURSING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="NOT APPLICABLE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M.D." THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="B U S" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MHSDE DIMPLOMA" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="M M" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="EDS   EDUCATION SPECIALIST" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MAST OF PROF STUDIES" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MAMHROB" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ADULT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="AS IN DENTAL HYGIENE" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="BOE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="HIGH SCHOOL GRADUATE" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="005 SPECIAL" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ME" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SECOND MAJOR" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MIS/M" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MAST OF INDUSTL DES" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="DM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="TED/E" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DR. OF OSTEOPATHIC MED." THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="DOCTOR OF PHILOSPHY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="L L M" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="LLM - SEC AND FINANCIAL REG" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MIS" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="A.S. IN DENTAL HYGIENE" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="SIXTH YEAR" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="PHYSICIAN ASSISTANT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MUSB" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BAIS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ED D" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="B PHYS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B CHEM" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="ADULT HIGH SCHOOL" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="DOCTORATE OF EDUCATION" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="GRADUATED- IN COLLEGE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA-MATHEMATICS" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="COLLEGE PREP/CAREER TECH" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="TYPE/D" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="PRACTICAL NURSING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="AD NURSING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B.G.S." THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M P T" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="EDUCATOR'S ENDORSEMENT IN" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DIPLOMA/2 YEARS" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="BAC OF SCI IN NURSING" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MA-PUBLIC POLICY & ADMIN" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="SPECIALIST IN EDUCATION DEGREE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF DENTAL SCIENCE" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="MA-POLITICAL SCIENCE" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="TRUCK DRIVER TRAINING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B L A" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF PHILOS-THEOLOGY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="BHA" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="NCATE ACCRED:ST APPRVD PRGM/ICP" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B COMP E" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MM/HRM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA IN PASTORAL STUDIES" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="EDD" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="FIRST PROFESSIONAL" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="BA EDUCATION" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B. S. IN NATURAL HEALTH SCIENCES" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="004 VOCATIONAL" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MACC" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M IND SAFE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MC/MHC" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTORATE OF DENTAL MEDICINE" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="ASSICUATE OF ARTS" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="REG WITHOUT HONORS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M P P" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="PROGRAM COMPLETION" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="VOCATIONAL NURSING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="LICENSURE" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="BCH ARTS CRIM JUS" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="SP ED 1-6: INITIAL" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA EDUCATION" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="A.ENG. DEGREE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SPECIAL" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="EDD   DOCTOR OF EDUCATION" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="LICENSURE ONLY" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="MDIV IN CHRISTIAN EDUC" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M.ENGR" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="COMP IEP" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="TQS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="PMT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MAED/EDTC" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="009 NORFOLK PREPARATORY HIGH SCH" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="GENERAL STUDIES DEGREE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA ED" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MAST OF ARCHITECTRE" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M.ENGR." THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="TQM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="OD" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA-BUSINESS" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M.P.A." THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="DOCTOR OF CHIROPRACTIC" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="1" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="NON GRADUATE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ISAEP GED" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DMIN (THEOLOGY)" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="AD ARTS & SCIENCE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="TEACHING ENGLISH AS A SECOND L" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CHILDHOOD 1-6:INITIAL" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="VOCATIONAL CREDIT ONLY" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DPT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MAGEO" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="PRACTICAL NURSING (L.P.N.)" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="GRAD- REGENTS DIPL. W/ ADV DESIG" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CORE 40" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CORE COMPLETE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M P A" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="A.A. IN BUSINESS ADMIN" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="COMMERCIAL CUSTODIAL TRAINING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="LICENSURE PREPARATION INITIAL" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCT PHYSICAL THERAPY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="GRAD- REGENTS DIPL. (2001 COHORT OR YOUNGER)" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="CAREER TECHNOLOGY" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MC/MFCC" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B.MUSIC" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DDS" THEN DEGREE_TITLE_RENAME="PROFESSIONAL";
ELSE IF DEGREE_TITLE="DOCTOR OF ENGINEERING SCIENCE" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="MAED/CURR" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M.ARCH" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="AS BUSINESS ADMINISTRATION" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="BPH IN COMMUNICATION" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="ASC ARTS & SCIENCES/PLAN B-DTA" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="M.ARCH." THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="DOCTOR OF SCIENCE IN NURSING" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="DR. OF PHILOSOPHY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="THM (THEOLOGY SCHOOL)" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="A.S. IN RESPIRATORY THERAPY" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="VSC" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="GCM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M. S. IN ACUPUNCTURE" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="LEGUM MAGISTER" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M.P.H." THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M LIB STU" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MAST. OF SCI.-COMP & INFO SCISMS CIS" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MAST. OF SCIENCE SPEECH & HEARMS SH" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="SPECIALIZATION GRADUATE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BB" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA-JOURNALISM & MASS COMMUNIC" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B I E" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="B GEO E" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="LLM - INTL LEGAL STUDIES" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="IEP" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="007 G.E.D." THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MCP" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="AS ENGINEERING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MACY" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DIST ACH PRO 9TH 95-96;96-97" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MDIV" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="UNKNOWN" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA-COMMUNICATION ARTS" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="A.TECH. DEGREE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA IN PSYCHOLOGY" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MA IN THEOLOGICAL STUDIES" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="THEMATIC UNDERGRADUATE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CRT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="EDUCATIONAL DOCTORATE" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="ASOC OF ARTS/GEN STUDIES" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="B MAT SCI/E" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="SHRM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DMIN (GRAHAM SCHOOL)" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="NONE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="COSMETOLOGY" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="LLM - LABOR AND EMPLOYMENT LAW" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA-ANTHROPOLOGY" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="DOCTOR OF THE SCIENCE OF LAW" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="MAED/ACE" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M.E.D." THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="ACCOUNTING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CHILD DEVELOPMENT CT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="INITIAL PRINCIPAL" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SPECIALIST IN EDUC" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DAP" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ADVANCED GRADUATE SPECIALIST" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="A/AS NURSING" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="REGENTS W/O HONORS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="LOCAL DPL WITHOUT REG ENDORS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF BUSINESS ADMINISTRATION" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="EDS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SPECIALIST IN EDUCATON" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="NURSING - AAAS-T" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="PHARD" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF OCCUPATIONAL THERAPY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="B AG E" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="MPT" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B.MUS." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="PROFESSIONAL DEVELOPMENT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="VOCATIONAL SPECIALIST" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="PH.D" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="MC/PR" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MA-ART" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="SP ED 1-6: PROF" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA-SPANISH" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="D M A" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M. S. IN NUTRITION" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MC/MFCT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="A S" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="COMP IEP MASTERY OF EMPLOYBLT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M.F.A." THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="REGENTS DPL WITHOUT HONORS" THEN DEGREE_TITLE_RENAME="DIPLOMA";
ELSE IF DEGREE_TITLE="STANDARD SECONDARY SCHOOL TEACHING" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="D P T" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="A/AS BUSINESS MANAGEMENT" THEN DEGREE_TITLE_RENAME="ASSOCIATES";
ELSE IF DEGREE_TITLE="PROFESSIONAL DEGREE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF SOCIAL WELFARE" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="BOTH COLL PREP & TECH/CAR" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MAST OF HLTHCARE ADM" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="V" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M.C.R.P." THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MDT/400" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="M AG" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="SPECIALIST IN ARTS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF JURIDICAL SCIENCE" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="BMUS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DUAL/MGT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="TECHNOLOGY/CAREER" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA-PHILOSOPHY" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="M HC A" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="B.ARCH." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="BA ELEM EDUC/INTER STUDY" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DOCTORATE OF PHYSICAL THERAPY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="CEERTIFICATE OF ADVANCED GRADUATE STUDY" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CONTINUING STUDIES DEGREE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BASIC VOCATIONAL SPECIALIST" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DISTING ACH PRO 9TH 98-99+" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BAFA" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="N/A" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ASN" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF MUSIC" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="BME" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="B.L.ARCH." THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="NATIONAL SCIENCE FOUNDATION" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="(DNU) B S ENGR TECH" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="LEARNING RESOURCES ENDORSEMENT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA-GERMAN" THEN DEGREE_TITLE_RENAME="MASTERS";
ELSE IF DEGREE_TITLE="MMT" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DR OF PHILOSOPHY" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="BET MECHANICAL ENGINEERING TECH" THEN DEGREE_TITLE_RENAME="BACHELORS";
ELSE IF DEGREE_TITLE="DOCTOR OF NURSING" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="PHARMD" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="CTF. OF PACE PROGRAM" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DMD" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MCSE" THEN DEGREE_TITLE_RENAME="CERTIFICATE";
ELSE IF DEGREE_TITLE="POST-BACCALAUREATE MAJOR" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MN/E" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="MA-FRENCH" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ADV." THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="ATA HUMAN SERVICES" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="GRAD- REGENTS DIPL. (2000 COHORT OR OLDER)" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="CHILDHOOD 1-6:PROF" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="COLLEGE PREP" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="DOCTOR OF NURSING SCIENCE" THEN DEGREE_TITLE_RENAME="PH.D.";
ELSE IF DEGREE_TITLE="OPTION UNDERGRADUATE" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="REGENTS" THEN DEGREE_TITLE_RENAME="UNIDENTIFIABLE";
ELSE IF DEGREE_TITLE="BA IN EDUC & TECH" THEN 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' THEN DEGREE_TITLE_RENAME='FOUR YEAR';
ELSE IF Year2YEar4='2' THEN DEGREE_TITLE_RENAME='TWO YEAR';
RUN;
*************************************************************************************;
*************************************************************************************;
		/* NOW MAKE CONDITIONS FOR THE FILE AND SORT IT TO GET ONLY VALID CASES*/
*NOW ORIGINAL FILE CALLED IMPORT WE ARE NOW MANIPULATING A FILE CALL ANA ;
*(NOT NECESARY TO DO THIS IN SQL);
*NOW MANIPULATE IMPORTED FILE AND CREATE NEW VARIABLES FOR COUNTING;
		DATA ANA;
			SET STFILE;
*GRAD FROM ORIGINAL INST 4year;
	IF ENROLLMENT_STATUS="G" AND SCHL_CODE=SUBMIT_CODE
		AND DEGREE_TITLE_RENAME IN ('FOUR YEAR','BACHELORS','MASTERS','PH.D.','PROFESSIONAL')
																							THEN CONDITION=1.2;
*GRAD FROM ORIGINAL INST 2year;
		ELSE IF ENROLLMENT_STATUS="G" AND SCHL_CODE=SUBMIT_CODE
					AND DEGREE_TITLE_RENAME IN ('TWO YEAR','ASSOCIATES')					THEN CONDITION=1.4;
*GRAD FROM OTHER 4 YEAR;
		ELSE IF ENROLLMENT_STATUS="G" AND SCHL_CODE NE SUBMIT_CODE 
			AND DEGREE_TITLE_RENAME IN ('FOUR YEAR','BACHELORS','MASTERS','PH.D.','PROFESSIONAL')	
																							THEN CONDITION=2;
*GRAD FROM A 2-YEAR;
		ELSE IF ENROLLMENT_STATUS="G" 
					AND DEGREE_TITLE_RENAME IN ('TWO YEAR','ASSOCIATES')					THEN CONDITION=4;
*RETAINED WITH ORIGINAL INST;
		ELSE IF ENROLLMENT_STATUS NE "G" AND SCHL_CODE=SUBMIT_CODE							THEN CONDITION=11;
*RETAINED WITH OTHER INSTATE 4 YEAR;
		ELSE IF ENROLLMENT_STATUS NE "G" AND SCHL_CODE NE SUBMIT_CODE	AND Year2Year4='4'	THEN CONDITION=22;
*RETAINED WITH OTHER INSTATE 2 YEAR;
		ELSE IF ENROLLMENT_STATUS NE "G" AND Year2Year4='2'									THEN CONDITION=44;
*ALL CONDITION CHECK;
												ELSE CONDITION=99;

/*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
*/

			IF 		END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1990) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1991) THEN  REP_YR='1990-91';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1991) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1992) THEN  REP_YR='1991-92';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1992) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1993) THEN  REP_YR='1992-93';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1993) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1994) THEN  REP_YR='1993-94';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1994) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1995) THEN  REP_YR='1994-95';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1995) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1996) THEN  REP_YR='1995-96';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1996) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1997) THEN  REP_YR='1996-97';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1997) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1998) THEN  REP_YR='1997-98';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1998) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1999) THEN  REP_YR='1998-99';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),1999) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2000) THEN  REP_YR='1999-00';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2000) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2001) THEN  REP_YR='2000-01';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2001) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2002) THEN  REP_YR='2001-02';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2002) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2003) THEN  REP_YR='2002-03';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2003) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2004) THEN  REP_YR='2003-04';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2004) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2005) THEN  REP_YR='2004-05';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2005) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2006) THEN  REP_YR='2005-06';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2006) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2007) THEN  REP_YR='2006-07';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2007) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2008) THEN  REP_YR='2007-08';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2008) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2009) THEN  REP_YR='2008-09';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2009) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2010) THEN  REP_YR='2009-10';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2010) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2011) THEN  REP_YR='20010-11';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2011) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2012) THEN  REP_YR='20011-12';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2012) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2013) THEN  REP_YR='20012-13';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2013) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2014) THEN  REP_YR='20013-14';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2014) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2015) THEN  REP_YR='20014-15';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2015) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2016) THEN  REP_YR='20015-16';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2016) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2017) THEN  REP_YR='20016-17';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2017) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2018) THEN  REP_YR='20017-18';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2018) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2019) THEN  REP_YR='20018-19';
			ELSE IF END_GRAD>= MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2019) AND END_GRAD<MDY(MONTH(SEARCH_DATE),DAY(SEARCH_DATE),2020) THEN  REP_YR='20019-20';
			ELSE REP_YR='ERROR';
RUN;
	*SORT AND SELECT ONE RECORD PER PERSON PER YEAR;
		*CANNOT USE NODUPKEY COMMAND BECAUSE OF MULTIPLE CONDITIONS IN A TERM;
			PROC SORT DATA=ANA SORTSIZE=MAX;
				BY STPROFIL_TOKEN REP_YR CONDITION DESCENDING ORIG_SCHL;
*OPEN DATA FILE USE LAG TO ID FIRST ROW PER PERSON PER REP_YR;
					DATA ANA;
						SET ANA;
						LAG_ST=LAG(STPROFIL_TOKEN);
						LAG_YR=LAG(REP_YR);
						KEEP=1;
						IF STPROFIL_TOKEN=LAG_ST 
						AND REP_YR=LAG(REP_YR)	THEN KEEP=0;
						IF KEEP=1;
						DROP KEEP;
						RUN;
					QUIT;
*SORT AND REMOVED ROWS POST BACHELORS DEGREE ;
		PROC SORT DATA=ANA SORTSIZE=MAX;
			BY STPROFIL_TOKEN REP_YR CONDITION;
		RUN;
	QUIT;
* NOTE: LAG COMMAND LOOKS UP ONE ROW IN THE DATA FILE;
* IN OTHER LANGUAGES PROGRAMMER MAY HAVE TO DO A _N_-1 OR ROW-1 COMMAND;
DATA ANA;
	SET ANA;
		LAG1_COND=LAG1(CONDITION);
		LAG2_COND=LAG2(CONDITION);
		LAG3_COND=LAG3(CONDITION);
		LAG4_COND=LAG4(CONDITION);
		LAG5_COND=LAG5(CONDITION);
		LAG6_COND=LAG6(CONDITION);
		LAG7_COND=LAG7(CONDITION);
		LAG8_COND=LAG8(CONDITION);
		LAG9_COND=LAG9(CONDITION);
		LAG10_COND=LAG10(CONDITION);
		LAG11_COND=LAG11(CONDITION);
		LAG12_COND=LAG12(CONDITION);
		LAG13_COND=LAG13(CONDITION);
		LAG14_COND=LAG14(CONDITION);
		LAG15_COND=LAG15(CONDITION);
		LAG16_COND=LAG16(CONDITION);
		LAG17_COND=LAG17(CONDITION);
		LAG18_COND=LAG18(CONDITION);
		LAG19_COND=LAG19(CONDITION);
		LAG20_COND=LAG20(CONDITION);
		LAG1_ST=LAG1(STPROFIL_TOKEN);
		LAG2_ST=LAG2(STPROFIL_TOKEN);
		LAG3_ST=LAG3(STPROFIL_TOKEN);
		LAG4_ST=LAG4(STPROFIL_TOKEN);
		LAG5_ST=LAG5(STPROFIL_TOKEN);
		LAG6_ST=LAG6(STPROFIL_TOKEN);
		LAG7_ST=LAG7(STPROFIL_TOKEN);
		LAG8_ST=LAG8(STPROFIL_TOKEN);
		LAG9_ST=LAG9(STPROFIL_TOKEN);
		LAG10_ST=LAG10(STPROFIL_TOKEN);
		LAG11_ST=LAG11(STPROFIL_TOKEN);
		LAG12_ST=LAG12(STPROFIL_TOKEN);
		LAG13_ST=LAG13(STPROFIL_TOKEN);
		LAG14_ST=LAG14(STPROFIL_TOKEN);
		LAG15_ST=LAG15(STPROFIL_TOKEN);
		LAG16_ST=LAG16(STPROFIL_TOKEN);
		LAG17_ST=LAG17(STPROFIL_TOKEN);
		LAG18_ST=LAG18(STPROFIL_TOKEN);
		LAG19_ST=LAG19(STPROFIL_TOKEN);
		LAG20_ST=LAG20(STPROFIL_TOKEN);
		LAG1_DEG=LAG1(DEGREE_TITLE_RENAME);
		LAG2_DEG=LAG2(DEGREE_TITLE_RENAME);
		LAG3_DEG=LAG3(DEGREE_TITLE_RENAME);
		LAG4_DEG=LAG4(DEGREE_TITLE_RENAME);
		LAG5_DEG=LAG5(DEGREE_TITLE_RENAME);
		LAG6_DEG=LAG6(DEGREE_TITLE_RENAME);
		LAG7_DEG=LAG7(DEGREE_TITLE_RENAME);
		LAG8_DEG=LAG8(DEGREE_TITLE_RENAME);
		LAG9_DEG=LAG9(DEGREE_TITLE_RENAME);
		LAG10_DEG=LAG10(DEGREE_TITLE_RENAME);
		LAG11_DEG=LAG11(DEGREE_TITLE_RENAME);
		LAG12_DEG=LAG12(DEGREE_TITLE_RENAME);
		LAG13_DEG=LAG13(DEGREE_TITLE_RENAME);
		LAG14_DEG=LAG14(DEGREE_TITLE_RENAME);
		LAG15_DEG=LAG15(DEGREE_TITLE_RENAME);
		LAG16_DEG=LAG16(DEGREE_TITLE_RENAME);
		LAG17_DEG=LAG17(DEGREE_TITLE_RENAME);
		LAG18_DEG=LAG18(DEGREE_TITLE_RENAME);
		LAG19_DEG=LAG19(DEGREE_TITLE_RENAME);
		LAG20_DEG=LAG20(DEGREE_TITLE_RENAME);
		*ID 4 YEAR COMPLETERS AND DELETE SUBSEQUENT ROWS;
			*CODE ASSUMES THAT A 4 YEAR COMPLETER WON'T HAVE MORE THAN 20 SUBSEQUENT ENROLLMENTS;
			*MAY WANT TO GO FURTHER IN THE FUTURE;
		* RECALL THAT CONDITION 1 IS AMBIGUOUS TO 2/4 YEAR INSTITUTION;
		*GET RID OF SUBSEQUENT ENROLLMENTS AFTER FOUR-YEAR DEGREE;
			IF STPROFIL_TOKEN=LAG1_ST AND (LAG1_COND=2 OR (LAG1_COND IN (1.2)))		THEN DELETE;
			IF STPROFIL_TOKEN=LAG2_ST AND (LAG2_COND=2 OR (LAG2_COND IN (1.2)))		THEN DELETE;
			IF STPROFIL_TOKEN=LAG3_ST AND (LAG3_COND=2 OR (LAG3_COND IN (1.2)))		THEN DELETE;
			IF STPROFIL_TOKEN=LAG4_ST AND (LAG4_COND=2 OR (LAG4_COND IN (1.2)))		THEN DELETE;
			IF STPROFIL_TOKEN=LAG5_ST AND (LAG5_COND=2 OR (LAG5_COND IN (1.2)))		THEN DELETE;
			IF STPROFIL_TOKEN=LAG6_ST AND (LAG6_COND=2 OR (LAG6_COND IN (1.2)))		THEN DELETE;
			IF STPROFIL_TOKEN=LAG7_ST AND (LAG7_COND=2 OR (LAG7_COND IN (1.2)))		THEN DELETE;
			IF STPROFIL_TOKEN=LAG8_ST AND (LAG8_COND=2 OR (LAG8_COND IN (1.2)))		THEN DELETE;
			IF STPROFIL_TOKEN=LAG9_ST AND (LAG9_COND=2 OR (LAG9_COND IN (1.2)))		THEN DELETE;
			IF STPROFIL_TOKEN=LAG10_ST AND (LAG10_COND=2 OR (LAG10_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG11_ST AND (LAG11_COND=2 OR (LAG11_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG12_ST AND (LAG12_COND=2 OR (LAG12_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG13_ST AND (LAG13_COND=2 OR (LAG13_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG14_ST AND (LAG14_COND=2 OR (LAG14_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG15_ST AND (LAG15_COND=2 OR (LAG15_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG16_ST AND (LAG16_COND=2 OR (LAG16_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG17_ST AND (LAG17_COND=2 OR (LAG17_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG18_ST AND (LAG18_COND=2 OR (LAG18_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG19_ST AND (LAG19_COND=2 OR (LAG19_COND IN (1.2)))	THEN DELETE;
			IF STPROFIL_TOKEN=LAG20_ST AND (LAG20_COND=2 OR (LAG20_COND IN (1.2)))	THEN DELETE;

				

			* ID 2 YEAR COMPLETERS AND CREATE AN INDICATOR FOR ALL SUBSEQUENT ROWS;
			* MUST HAVE CONDITION THAT A 2 YEAR COMPLETER COULD BE FROM A 4 YEAR INSTITUTION;
			* ALSO, CONDITION 1 IS AMBIGOUS TO 2/4 OF THE INSTITUTION SO IT CAN'T BE USED IN LOGIC ALONE;
			PRIOR_AA=0;
			IF STPROFIL_TOKEN=LAG1_ST AND (LAG1_COND=4 OR (LAG1_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG2_ST AND (LAG2_COND=4 OR (LAG2_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG3_ST AND (LAG3_COND=4 OR (LAG3_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG4_ST AND (LAG4_COND=4 OR (LAG4_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG5_ST AND (LAG5_COND=4 OR (LAG5_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG6_ST AND (LAG6_COND=4 OR (LAG6_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG7_ST AND (LAG7_COND=4 OR (LAG7_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG8_ST AND (LAG8_COND=4 OR (LAG8_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG9_ST AND (LAG9_COND=4 OR (LAG9_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG10_ST AND (LAG10_COND=4 OR (LAG10_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG11_ST AND (LAG11_COND=4 OR (LAG11_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG12_ST AND (LAG12_COND=4 OR (LAG12_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG13_ST AND (LAG13_COND=4 OR (LAG13_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG14_ST AND (LAG14_COND=4 OR (LAG14_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG15_ST AND (LAG15_COND=4 OR (LAG15_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG16_ST AND (LAG16_COND=4 OR (LAG16_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG17_ST AND (LAG17_COND=4 OR (LAG17_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG18_ST AND (LAG18_COND=4 OR (LAG18_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG19_ST AND (LAG19_COND=4 OR (LAG19_COND IN (1.4))) THEN PRIOR_AA=1;
			IF STPROFIL_TOKEN=LAG20_ST AND (LAG20_COND=4 OR (LAG20_COND IN (1.4))) THEN PRIOR_AA=1;
*NOW RETAIN CONDITIONS FOR THOSE WITH PRIOR_AA TO COUNT THE ENROLLMENTS OF PRIOR_AA STUDENTS;
	* NOTE THAT 1 TIMES CONDITION EQUALS CONDITION;

				PRIOR_AA_COND=PRIOR_AA*CONDITION;
*DROP CREATED VARIABLES;
DROP 	LAG1_ST 	LAG2_ST 	LAG3_ST 	LAG4_ST 	LAG5_ST 	
			LAG6_ST 	LAG7_ST 	LAG8_ST 	LAG9_ST 	LAG10_ST
			LAG11_ST 	LAG12_ST 	LAG13_ST 	LAG14_ST 	LAG15_ST 	
			LAG16_ST 	LAG17_ST 	LAG18_ST 	LAG19_ST 	LAG20_ST
			LAG1_COND 	LAG2_COND 	LAG3_COND 	LAG4_COND 	LAG5_COND 	
			LAG6_COND 	LAG7_COND 	LAG8_COND 	LAG9_COND 	LAG10_COND
			LAG11_COND 	LAG12_COND 	LAG13_COND 	LAG14_COND 	LAG15_COND 	
			LAG16_COND 	LAG17_COND 	LAG18_COND 	LAG19_COND 	LAG20_COND
			LAG_YR 		LAG_ST		
			LAG1_DEG	LAG2_DEG	LAG3_DEG	LAG4_DEG	LAG5_DEG
			LAG6_DEG	LAG7_DEG	LAG8_DEG	LAG9_DEG	LAG10_DEG
			LAG11_DEG	LAG12_DEG	LAG13_DEG	LAG14_DEG	LAG15_DEG
			LAG16_DEG	LAG17_DEG	LAG18_DEG	LAG19_DEG	LAG20_DEG
;
RUN;
*THESE TITLES WILL BE CHANGED BASED ON RECCOMENDATIONS FROM VSA WORKING COMMITTEE (TO CONVENE ON 2/15/2008;
PROC FORMAT;
	VALUE COND_nm
	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'
;
RUN;

DATA CLASSES;
	DO CONDITION=1.2, 1.4, 2,4,11,44;
	OUTPUT;
	END;
	DO REP_YR='2008-09' ;
	OUTPUT;
	END;
RUN;

TITLE;
TITLE1 		font=COURIER  bold color=black h=3  "NSC Retention and Completion Table-Beta Version";
FOOTNOTE;
FOOTNOTE1 	font=times  color=black h=2.5  JUSTIFY=LEFT "Data created using the National Student Clearinghouse StudentTracker Service.  
			Depending on the size of the cohort submitted and student propensities the 
			counts in this table could be small enough to allow for individual identifiable data.";
FOOTNOTE2  font=times italic color=black h=2.5 JUSTIFY=LEFT  "*Please exercise caution when publicly reporting this data.";
FOOTNOTE3  font=times italic color=black h=2.5 JUSTIFY=LEFT "**If your institution lines are blank you need to go to the top of the code and update the submit code.";
FOOTNOTE4  font=times italic color=black h=2.5 JUSTIFY=LEFT	"***Year 2008-09 will ALWAYS show in the report.";
		* Final Output Table for all students;
PROC TABULATE
DATA=WORK.ANA	CLASSDATA=CLASSES MISSING;
	CLASS CONDITION /	ORDER=UNFORMATTED MISSING MLF;
	CLASS REP_YR /	ORDER=UNFORMATTED MISSING;
	TABLE /* Row Dimension */
		CONDITION={LABEL='Enrollment/Completion Outcome' 
				STYLE={FONT_SIZE=2  
				FONT_FACE='Arial Black' 
				FONT_WEIGHT=BOLD 
				FONT_STYLE=ROMAN}
				STYLE(CLASSLEV)={FONT_SIZE=2 
								FONT_WEIGHT=MEDIUM 
								FONT_STYLE=ROMAN}}
				* N 
				ALL* N,
/* Column Dimension */
		REP_YR={LABEL='Academic Year Based on Search Date in StudentTracker Submission'} 		;
	;
	FORMAT CONDITION COND_NM.;
RUN;

* Final Output Table for students who had a previous AA (condition=4);
TITLE ;
TITLE1 font=COURIER  bold color=black h=3 " Previouse AA Completers Only: NSC Retention and Completion Table";

FOOTNOTE;
FOOTNOTE1 	font=times  color=black h=2.5  JUSTIFY=LEFT "Data created using the National Student Clearinghouse StudentTracker Service.  
			Depending on the size of the cohort submitted and student propensities the 
			counts in this table could be small enough to allow for individual identifiable data.";
FOOTNOTE2  font=times italic color=black h=2.5 JUSTIFY=LEFT  "*Please exercise caution when publicly reporting this data.";
FOOTNOTE3  font=times italic color=black h=2.5 JUSTIFY=LEFT "**If your institution lines are blank you need to go to the top of the code and update the submit code.";
FOOTNOTE4  font=times italic color=black h=2.5 JUSTIFY=LEFT	"***Year 2008-09 will ALWAYS show in the report.";

PROC TABULATE
DATA=WORK.ANA(WHERE=(PRIOR_AA=1))	CLASSDATA=CLASSES MISSING;
	CLASS CONDITION /	ORDER=UNFORMATTED MISSING MLF;
	CLASS REP_YR /	ORDER=UNFORMATTED MISSING;
	TABLE /* Row Dimension */
		CONDITION={LABEL='Enrollment/Completion Outcome' 
				STYLE={FONT_SIZE=2  
				FONT_FACE='Arial Black' 
				FONT_WEIGHT=BOLD 
				FONT_STYLE=ROMAN}
				STYLE(CLASSLEV)={FONT_SIZE=2 
								FONT_WEIGHT=MEDIUM 
								FONT_STYLE=ROMAN}}
				* N 
				ALL* N,
/* Column Dimension */
		REP_YR={LABEL='Academic Year Based on Search Date in StudentTracker Submission'} 		;
	;
	FORMAT CONDITION COND_NM.;
RUN;