SAS Users Group for Institutional Researchers (SUGIR)

Reply
This is an open group. Sign in and click the "Join Group" button to become a group member and start posting.
Highlighted
Occasional Contributor
Posts: 5
National Student Clearinghouse

Has anyone come up with SAS code or any business rules to deal with the data that comes back from the National Student Clearinghouse?  It's a bit cumbersome.

Occasional Contributor
Posts: 5
Re: National Student Clearinghouse
Yes, we have done this. Give us a few days to clean up the institution specific coding and we are happy to share it.
Occasional Learner
Posts: 1
Re: National Student Clearinghouse
Any way I can get a copy of this as well? Thank you in advance.
Contributor RVA
Contributor
Posts: 21
Re: National Student Clearinghouse
[ Edited ]

Dear all

 

I have wrote a few programs to handle NSC data.  Those programs allow me to clean up NSC data and then prepare them in the same format so that I can stack them with the student in-house data we have at our institution.  I am going to post all the programs below.  Feel free to use it and let me know if you have any feedback/comments.

 

 

Contributor RVA
Contributor
Posts: 21
NSC program 1 - cleaning up the list of institutions

You may need to get an updated list of institutions from NSC before you run this program.

 

----------------------------------------------------------------


*************************************;
* description:

- this program cleans and checks the list of parent institutions (4-digit codes) participating in NSC.
- this list will be joined with NSC data later in order to replace 6-digit institutions there with
the corresponding 4-digit parent institutions.
*************************************;

* handle some weird characters;

data inst_list; set CollegeList_NSC_2014;
school_name = compress(school_name,"'"); /* delete ' */
school_name = compress(school_name,"'"); /* delete ' */
school_name = tranwrd(school_name,"amp","&"); /* replace amp with & */

school_code = tranwrd(school_code,"'",""); /* replace ' with a blank because some school codes begin with "'" */
school_code = strip(school_code); /* remove leading and trailing blanks */
run;

* keep only parent institutions;

data inst_list_1; set inst_list;
if index(school_code,'.') > 0 then delete;
if index(school_code,'-') > 0 then delete;
if school_code = ' ' then delete;
run;

* check if there are any dups;

proc sort data=inst_list_1; by school_code; run;

data inst_list_2; set inst_list_1;
by school_code;
count + 1;
if first.school_code then count = 1;
run;

proc sql;
create table dups_1 as select distinct *
from inst_list_2
where school_code in (select distinct school_code from inst_list_2 where count > 1)
order by school_code
; quit;

* remove dups;

data inst_list_3; set inst_list_2;
if school_code = '21209' then do; school_name = 'ITT Technical Institute'; state = 'CA'; end;
if school_code = '30764' then do; school_name = 'The Bryman School'; state = 'AZ'; end;
if school_code = '6489' then do; school_name = 'The Christ College of Nursing & Health Sciences'; state = 'OH'; end;
drop count;
run;

proc sort data=inst_list_3 nodupkey out=inst_list_4; by school_code; run;

* turn into 6-digit school codes;

data inst_list_5; set inst_list_4;
if length(school_code) = 1 then school_code = '00000'||strip(school_code);
if length(school_code) = 2 then school_code = '0000' ||strip(school_code);
if length(school_code) = 3 then school_code = '000' ||strip(school_code);
if length(school_code) = 4 then school_code = '00' ||strip(school_code);
if length(school_code) = 5 then school_code = '0' ||strip(school_code);
if length(school_code) = 6 then school_code = strip(school_code);
run;

* insert some more institutions to the list;

proc sql;
insert into inst_list_5 values ('WASHINGTON BIBLE COLLEGE','MD','001462');
insert into inst_list_5 values ('EVEREST UNIVERSITY','FL','001499');
insert into inst_list_5 values ('GEORGIA REGENTS UNIVERSITY','GA','001552');
insert into inst_list_5 values ('SAINT PAULS COLLEGE','VA','003739');
insert into inst_list_5 values ('MOUNTAIN STATE UNIVERSITY','WV','003807');
insert into inst_list_5 values ('TEXAS A&M HSC','TX','004948');
insert into inst_list_5 values ('UNIVERSITY OF MEDICINE & DENTISTRY OF NEW JERSEY-UMDNJ','NJ','010394');
insert into inst_list_5 values ('COMMUNITY COLLEGE OF THE AIR FORCE','AL','012308');
insert into inst_list_5 values ('THOMAS JEFFERSON UNIVERSITY','PA','012393');
insert into inst_list_5 values ('AMERICAN UNIVERSITY OF THE CARIBBEAN','FO','022444');
insert into inst_list_5 values ('MEDICAL CAREERS INSTITUTE','VA','022472');
insert into inst_list_5 values ('ECPI TECHNICAL COLLEGE AT INNSBROOK','VA','025354');
insert into inst_list_5 values ('UNIVERSITY OF ADVANCING TECHNOLOGY','AZ','025590');
insert into inst_list_5 values ('UNIVERSITY OF ST AUGUSTINE FOR HLTH SCIENCES','FL','031713');
quit;

* check dups for the last time;

proc sort data=inst_list_5 nodupkey out=final_list; by school_code; run;

data final_list; set final_list;
school_name = upcase(school_name);
run;

/* this final list should be updated every time we run the program */

Occasional Contributor
Posts: 5
Re: NSC program 1 - cleaning up the list of institutions

This is why I love IR groups.  Y'all are AWESOME!  I can't thank you enough!

Contributor RVA
Contributor
Posts: 21
NSC program 2 - split NSC data into enrollment data and degree data
[ Edited ]

This program cleans up NSC raw data and split them into 2 data sets--enrollment and degrees awarded.  Those data sets can then be stacked with our in-house enrollment and degree data sets so that we can have a full "picture" of each student.

 

--------------------------------------------------


* the following columns should be defined as character when imported from excel to sas:

- enrollment begin
- enrollment end
- enrollment cip 1
- enrollment cip 2
- graduation date
- degree cip 1
- degree cip 2
- degree cip 3
- degree cip 4
;

*************************************;
* suggestions from Khoi and Mei:

- enr_ready and deg_ready tables have structures similar to those of registration_bio and vcu_degrees_awarded
and should be maintained in ODSSTU schema. This would allow flexible retrieval of data from multiple tables later.
Data in collapsed form (see SAS run "03. reports") should not be maintained in ODSSTU as it would be very hard
to manipulate to meet different data needs in the future. Also, if collapsed data were to be maintained,
the whole table would have to be re-uploaded periodically.

- another SAS program can be written to compare existing data and new data (to be downloaded from NSC periodically),
and only new records will be added into enr_ready and deg_ready tables in ODSSTU.
*************************************;

* CIP problems:
most CIPs have 6 digits, but there are several CIPs with just one, two, or three digits;

data data; set raw;
if record_found_y_n = 'N' or college_name='VIRGINIA COMMONWEALTH UNIVERSITY' then delete;
rename
college_code_branch=college_code
public___private = college_type1
_2_year___4_year = college_type2
enrollment_major_1 = major_desc1
enrollment_cip_1 = program_classification1
enrollment_major_2 = major_desc2
enrollment_cip_2 = program_classification2
enrollment_status = enr_status
graduated_ = graduation_flag
;
id = substr(requester_return_field,1,9);
cohort_num = sum(substr(search_date,1,6),100);
cohort = put(cohort_num,6.);
cohort_desc = 'Fall'||' '||substr(search_date,1,4);

drop your_unique_identifier requester_return_field search_date cohort_num;
run;

* link with registration_bio to get person_uid;

proc sql;
create table data_1 as
select distinct A.*, B.person_uid
from data A
left outer join (select distinct id, person_uid from odsstu.registration_bio) B
on A.id = B.id
; quit;

* just a check;

proc sql;
create table dups_person_uid as
select distinct person_uid, count(distinct id)
from data_1
group by person_uid
having count(distinct id) > 1
; quit;

title 'Duplicated/missing person_uids';
proc print data=dups_person_uid; run;
/* stop and investigate if there are any records printed out */

proc sql;
create table dups_id as
select distinct id, count(distinct person_uid)
from data_1
group by id
having count(distinct person_uid) > 1
; quit;

title 'Duplicated/missing IDs';
proc print data=dups_id; run;
/* stop and investigate if there are any records printed out */

* merge with the list of institutions to get parent institutions;

proc sql;
create table data_2 as
select /* distinct */ A.*, B.school_name as name_b, school_code as code_b, state as state_b
from data_1 A
left outer join final_list B
on substr(A.college_code,1,6) = B.school_code
; quit;

* check if there are any records missing parent institutions;

proc sql;
create table missing as
select distinct college_code, college_name, college_state
from data_2
where code_b = ' '
; quit;

title 'Missing parent institutions';
proc print data=missing; run;
/* stop and investigate if there are any records printed out */

* rename some variables;

data data_3; set data_2;
rename college_name = old_name;
rename college_code = old_code;
rename college_state = old_state;

rename name_b = college_name;
rename code_b = college_code;
rename state_b = college_state;
run;

data enr deg error; set data_3;
if graduation_flag = 'N' then output enr;
else if graduation_flag = 'Y' then output deg;
else output error; /* should have no records */
run;

title 'Records with no graduation_flag';
proc print data=error; run;
/* stop and investigate if there are any records printed out */

*************************************;
* ENROLLMENT DATA;
*************************************;

proc sort data=enr; by cohort id college_code enrollment_begin; run;

data enr_1; set enr;
length academic_period $20.;
format academic_period $20.;

begin_month = substr(enrollment_begin,5,2);
begin_year = substr(enrollment_begin,1,4);
end_month = substr(enrollment_end,5,2);
end_year = substr(enrollment_end,1,4);

if begin_month in ('08','09','10','11','12') then term = '10';
else if begin_month in ('01','02','03','04') then term = '20';
else if begin_month in ('05','06','07' ) then term = '30';

if term = '10' then acad_year_num = sum(begin_year,1);
else acad_year_num = sum(begin_year,0);

acad_year = put(acad_year_num,4.);
academic_period = strip(acad_year)||strip(term);
if term = '10' then academic_period_desc = 'Fall' ||' '||strip(begin_year);
else if term = '20' then academic_period_desc = 'Spring'||' '||strip(begin_year);
else if term = '30' then academic_period_desc = 'Summer'||' '||strip(begin_year);
run;

* check duplicates by academic period;

proc sql;
create table dups1 as
select distinct cohort, id, college_code, academic_period, count(*) as count
from enr_1
group by cohort, id, college_code, academic_period
having count(*) > 1
; quit;

proc sql;
create table dups2 as
select distinct cohort, id, last_name, first_name
, college_code, college_name
, academic_period, enrollment_begin, enrollment_end
from enr_1
where id in (select distinct id from dups1)
order by cohort, id, last_name, first_name, college_code, college_name, academic_period
; quit;

* remove duplicates by academic period;

proc sort data=enr_1 nodupkey out=enr_2;
by cohort id college_code academic_period;
run;
/* there may be dual enrollment (a student enrolling at two different institutions in one academic term) */

* some more coding on enrollment status and class level;

data enr_2; set enr_2;
length enr_status_desc class_level_desc $100.;
format enr_status_desc class_level_desc $100.;

if enr_status = 'F' then enr_status_desc = 'Full Time';
if enr_status = 'H' then enr_status_desc = 'Half Time';
if enr_status = 'L' then enr_status_desc = 'Less Than Half Time';
if enr_status = 'A' then enr_status_desc = 'Leave Of Absence';
if enr_status = 'W' then enr_status_desc = 'Withdrawn';
if enr_status = 'D' then enr_status_desc = 'Deceased';
if enr_status = 'Q' then enr_status_desc = '3/4 Time';

if class_level = 'F' then class_level_desc = 'Freshman';
if class_level = 'S' then class_level_desc = 'Sophomore';
if class_level = 'J' then class_level_desc = 'Junior';
if class_level = 'R' then class_level_desc = 'Senior';
if class_level = 'C' then class_level_desc = 'Undergrad Certificate';
if class_level = 'N' then class_level_desc = 'Undergrad Unspecified';
if class_level = 'M' then class_level_desc = "Master's";
if class_level = 'D' then class_level_desc = 'Doctoral';
if class_level = 'P' then class_level_desc = 'Postdoctorate';
if class_level = 'L' then class_level_desc = 'First Professional';
if class_level = 'G' then class_level_desc = 'Graduate Unspecified';
if class_level = 'A' then class_level_desc = "Associate's";
if class_level = 'T' then class_level_desc = 'Undergrad Post-Baccalaureate';
if class_level = 'B' then class_level_desc = 'Baccalaureate';
run;

* just a check;

data blank_status_level; set enr_2;
where (enr_status ^= ' ' and enr_status_desc = ' ')
or (class_level ^= ' ' and class_level_desc = ' ')
; run;

title 'Blank status level';
proc print data=blank_status_level; run;
/* stop and investigate if there are any records printed out */

* keep only needed variables;

proc sql;
create table enr_ready as
select distinct cohort, cohort_desc, id, person_uid, last_name, middle_initial, first_name
, academic_period, academic_period_desc
, major_desc1, program_classification1, major_desc2, program_classification2
, college_state
, college_type1, college_type2
, college_code, college_name
, enr_status as current_time_status
, enr_status_desc as current_time_status_desc
, class_level as student_classification1
, class_level_desc as student_classification_desc1
from enr_2
; quit;

*************************************;
* DEGREE DATA;
*************************************;

data deg_1; set deg;
length academic_period_grad_desc $20.;
format academic_period_grad_desc $20.;

grad_month = substr(graduation_date,5,2);
grad_year_raw = substr(graduation_date,1,4);

if grad_month in ('09','10','11','12') then grad_term = '10';
else if grad_month in ('01','02','03','04','05') then grad_term = '20';
else if grad_month in ('06','07','08' ) then grad_term = '30';
/* different from enrollment data */

if grad_term = '10' then grad_year_num = sum(grad_year_raw,1);
else grad_year_num = sum(grad_year_raw,0);

grad_year = put(grad_year_num,4.);
academic_period_graduation = strip(grad_year)||strip(grad_term);
if grad_term = '10' then academic_period_grad_desc = 'Fall' ||' '||strip(grad_year);
else if grad_term = '20' then academic_period_grad_desc = 'Spring'||' '||strip(grad_year);
else if grad_term = '30' then academic_period_grad_desc = 'Summer'||' '||strip(grad_year);
run;

proc sort data=deg_1 out=deg_2; by cohort id college_code degree_title degree_major_1; run;
/* bring to the top records that have blank degree_title */

* count the order of degrees per student per school;

data deg_3; set deg_2;
by cohort id college_code;
count + 1;
if first.college_code then count = 1;
run;

* count the total number of degrees per student per school;

proc sql;
create table total_deg as
select distinct cohort, id, college_code, count(*) as total
from deg_2
group by cohort, id, college_code
; quit;

* merge data together;

proc sql;
create table deg_4 as
select distinct A.*, B.total
from deg_3 A
left outer join total_deg B
on A.cohort = B.cohort
and A.id = B.id
and A.college_code = B.college_code
order by cohort, id, college_code
; quit;

* if there are blank and non-blank degree records (per institution), keep the non-blank ones;
* if there are only blank degree records (per institution), keep the last one;

data deg_5 deg_errors; set deg_4;
if degree_title = ' ' and count < total then output deg_errors; /* errors */
else output deg_5; /* ligitimate records */
run;

* check to make sure all students in "deg_errors" do exist in "deg_5";

proc sql;
create table deg_errors_1 as
select distinct *
from deg_errors A
where not exists (select distinct *
from deg_5 B
where A.cohort = B.cohort
and A.id = B.id
and A.college_code = B.college_code)
; quit;

title 'Degree errors';
proc print data=deg_errors_1; run;
/* stop and investigate if there are any records printed out */

* delete remaining duplicates, if any;

proc sort data=deg_5 nodupkey out=deg_6;
by cohort id college_code academic_period_graduation degree_title degree_major_1;
run;
/* a student may graduate from one institution in one academic term with more than one degree */

* recode degree from degree title;

data deg_7; set deg_6;
format degree $20.;
length degree $20.;

* TIER 1: VERY CERTAIN RECODES USING SUBSTR COMMAND WHICH IS FASTER;
IF SUBSTR(degree_title,1,5)='ASSOC' THEN DEGREE='ASSOCIATES';
ELSE IF SUBSTR(degree_title,1,2)='AA' THEN DEGREE='ASSOCIATES';
ELSE IF degree_title='AS' THEN DEGREE='ASSOCIATES';

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

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

ELSE IF degree_title='MED' THEN DEGREE='PROFESSIONAL';

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

ELSE IF SUBSTR(degree_title,1,5)='DIPLOMA' THEN DEGREE='DIPLOMA';
ELSE IF SUBSTR(degree_title,1,5)='DIMPLOMA' THEN DEGREE='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="DIPLOMA"; *DEGREE="HIGH SCHOOL DIPLOMA";

ELSE IF INDEX(degree_title ,'CERT')>0 THEN DEGREE="CERTIFICATE";

ELSE IF INDEX(degree_title ,'ASSOCIATE') >0 THEN DEGREE='ASSOCIATES';
ELSE IF INDEX(degree_title ,'ASSOC') >0 THEN DEGREE='ASSOCIATES';
ELSE IF INDEX(degree_title ,'A.A.S') >0 THEN DEGREE='ASSOCIATES';

ELSE IF INDEX(degree_title ,'MASTER') >0 THEN DEGREE='MASTERS';
ELSE IF SUBSTR(DEGREE_TITLE,1,5)='M B A' THEN DEGREE='MASTERS';
ELSE IF INDEXW(degree_title ,'MBA') >0 THEN DEGREE='MASTERS';
ELSE IF INDEXW(degree_title ,'MSN') >0 THEN DEGREE='MASTERS';
ELSE IF INDEXW(degree_title ,'M.S.') >0 THEN DEGREE='MASTERS';

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

ELSE IF INDEXW(degree_title ,'DOCTOR OF PHILOSOPHY') >0 THEN DEGREE='PH.D.';
ELSE IF INDEXW(degree_title ,'DOCTOR OF PHYSICAL THERAPY') >0 THEN DEGREE='PH.D.';

ELSE IF INDEXW(degree_title ,'JURIS DOCTOR') >0 THEN DEGREE= 'PROFESSIONAL';
ELSE IF INDEXW(degree_title ,'DOCTOR OF JURISPRUDENCE') >0 THEN DEGREE= 'PROFESSIONAL';
ELSE IF INDEXW(degree_title ,'DOCTOR OF MEDICINE') >0 THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='DOCTOR OF DENTAL SURGERY' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='DOCTOR OF VETERINARY MEDICINE' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='DOCTOR OF LAW' THEN DEGREE= 'PROFESSIONAL';
ELSE IF INDEXW(degree_title ,'DOCTOR OF PHARMACY') >0 THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='DOCTOR OF OSTEOPATHIC MEDICINE' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='DOCTOR OF DENTAL MEDICINE' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='J D' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='DOCTOR OF LAW (JURIS DOCTOR)' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='M D' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='D D S' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='D V M' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='JD' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='DOCTOR OF PODIATRIC MEDICINE' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='DOCTOR IN DENTAL SURGERY' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='DOCTOR OF DENTISTRY' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='MD' THEN DEGREE= 'PROFESSIONAL';
ELSE IF DEGREE_TITLE='JURIS DOCTORATE' THEN DEGREE= 'PROFESSIONAL';

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

* Khoi and Mei added;

IF DEGREE_TITLE="UCRT" THEN DEGREE="CERTIFICATE";
IF DEGREE_TITLE="DOCTOR PHYSICAL THERAPY" THEN DEGREE="PH.D.";
IF DEGREE_TITLE="COMBINED MS AND EDS" THEN DEGREE="MASTERS";
IF DEGREE_TITLE="JD-JURIS DOCTOR" THEN DEGREE="PROFESSIONAL";

IF ID = 'V00354374' AND DEGREE_TITLE="A" THEN DEGREE="BACHELORS";
IF ID = 'V00415806' AND DEGREE_TITLE="S" THEN DEGREE="BACHELORS";

* Khoi added on 02/18/2015;

IF INDEX(degree_title ,'MAED') >0 THEN DEGREE='MASTERS';
IF INDEX(degree_title ,'DVM') >0 THEN DEGREE='PROFESSIONAL';
IF substr(degree_title,1,3) = 'M A' THEN DEGREE='MASTERS';
IF degree_title = 'DOC. PODIATRIC MED.' THEN DEGREE='PROFESSIONAL';
IF degree_title = 'AS DEGREE' THEN DEGREE='ASSOCIATES';
IF degree_title = 'MAC' THEN DEGREE='MASTERS';
IF degree_title = 'DOCTOR' and degree_major_1 = 'PODIATRIC MEDICINE' THEN DEGREE='PROFESSIONAL';
IF degree_title = 'DOCTOR OF PHYS THERAPY' THEN DEGREE='PH.D.'; /* considered by NSC as PhD, not Professional */
IF INDEX(degree_title ,'VMD') >0 THEN DEGREE='PROFESSIONAL';
IF degree_title = 'DOCTOR OF NURSING PRACTICE' THEN DEGREE='PROFESSIONAL';
IF INDEX(degree_title ,'MHA') >0 THEN DEGREE='MASTERS';
IF INDEX(degree_title ,'MASTR') >0 THEN DEGREE='MASTERS';
IF INDEX(degree_title ,'O.D.') >0 THEN DEGREE='PROFESSIONAL';
IF substr(degree_title,1,9) = 'POST BACC' THEN DEGREE='CERTIFICATE';
IF degree_title = 'ASTER OF SCIENCE IN NURSING' THEN DEGREE='MASTERS';
IF degree_title = 'S' and degree_major_1 = 'INFORMATION SYST - ONLINE MS' THEN DEGREE='MASTERS';
IF degree_major_1 = 'GRADUATE HUMAN RESOURCES MANAGEMENT CERTIFICATE' THEN DEGREE='CERTIFICATE';
IF degree_major_1 = 'GRAD PROFESSIONAL ENDORSEMENT' THEN DEGREE='UNIDENTIFIABLE';
run;

* just a check;

data check_deg; set deg_7;
if degree_title ^= ' ' and degree = ' ' then output;
run;

title 'Mismatch between degree titles and degrees';
proc print data=check_deg; var person_uid id college_name degree_title degree; run;
/* stop and investigate if there are any records printed out */

data check_deg; set deg_7;
if degree_title = ' ' then output;
run;

title 'Blank degree titles';
proc print data=check_deg; var person_uid id college_name degree_title degree; run;
/* stop and investigate if there are any records printed out */

* remove duplicates;

proc sort data=deg_7 nodupkey out=deg_8;
by cohort id college_code academic_period_graduation
degree degree_major_1 degree_major_2 degree_major_3 degree_major_4;
run;

proc sql;
create table deg_ready as
select distinct cohort, cohort_desc, id, person_uid, last_name, middle_initial, first_name
, academic_period_graduation, academic_period_grad_desc
, college_state
, college_type1
, college_type2
, college_code
, college_name
, degree as award_category_desc
, degree_title as degree_desc
, degree_major_1 as major_desc1, degree_cip_1 as program_classification1
, degree_major_2 as major_desc2, degree_cip_2 as program_classification2
, degree_major_3 as major_desc3, degree_cip_3 as program_classification3
, degree_major_4 as major_desc4, degree_cip_4 as program_classification4
from deg_8
; quit;

 

 

Contributor RVA
Contributor
Posts: 21
NSC program 3 (optional) - comparing old and new NSC data

Suppose that you still have some NSC data from last year.  Now you just downloaded some extra data from NSC, and you want to compare the old NSC data (you already have them) and the new NSC data (you just downloaded them) to see which records are new records.  In order to do so, after running programs 1 and 2 above, you can run the following program 3 to get the new records only.

 

-----------------------------------------------


* bring in current ODS data;

data current_enr; set odsstu.nsc_registration_bio; run;

data current_deg; set odsstu.nsc_degrees_awarded; run;

*********************************************;
* COMPARE ENROLLMENT DATA AND GET NEW RECORDS;
*********************************************;

* get records in the NSC data that do not exist in current ODS data;

proc sql;
create table new_enr as
select distinct
from enr_ready A
where not exists (select distinct *
from current_enr B
where A.cohort = B.cohort
and A.person_uid = B.person_uid
and A.academic_period = B.academic_period
and A.college_code = B.college_code)
; quit;

 

*********************************************;
* COMPARE DEGREE DATA AND GET NEW RECORDS;
*********************************************;

* get records in the NSC data that do not exist in current ODS data;

proc sql;
create table new_deg as
select distinct
from deg_ready A
where not exists (select distinct *
from current_deg B
where A.cohort = B.cohort
and A.person_uid = B.person_uid
and A.academic_period_graduation = B.academic_period_graduation
and A.college_code = B.college_code)
; quit;

Occasional Contributor
Posts: 5
Re: National Student Clearinghouse

/*XSF: 5/27/2016.

File: Manipulate files from NSC.SAS.

This is a general SAS code to manipulate the raw files received from National Student Clearinghouse
especially for the inquiry type = SE or CO type of queries that contains the enrollment and graduation information of
current or previously enrolled students.

Specifically, the file we submit to NSC is an EXCEL file of our non-completers with inquiry type = SE file containing the following data information:
"ID,    LAST_NAME,    FIRST_NAME,    MIDDLE_INITIA,L    NAME_SUFFIX,    birth_date,    ssn (blank),    searchbegindate,    columni(blank),    ficecode,
branchcode,    rectype".
Please refer to NSC's manuals of 'Creating StudentTracker Research Files Using Excel' for the file format and requirements.

The raw file received back from NSC is a .csv file (everything is in text) containing the following data fields:
"Your Unique Identifier,    First Name,    Middle Initial,    Last Name,    Name Suffix,    Requester Return Field,    Record Found Y/N,    Search Date,    College Code/Branch,
College Name,    College State,    2-year / 4-year,    Public / Private,    Enrollment Begin,    Enrollment End,    Enrollment Status,    Class Level,
Enrollment Major 1,    Enrollment CIP 1,    Enrollment Major 2,    Enrollment CIP 2,    Graduated?,    Graduation Date,    Degree Title,    Degree Major 1,    Degree CIP 1,
Degree Major 2,    Degree CIP 2,    Degree Major 3,    Degree CIP 3,    Degree Major 4,    Degree CIP 4,    College Sequence"
Please refer to NSC's manuals of 'Reading the StudentTracker Detail Report' for the definition of each data field.

*/

/* - Find out the transfer out students. */
*Import NSC data from NSC;
*NOTE we only send the noncompleters to NSC which EXCLUDES the 4 exclusions;
PROC IMPORT OUT= WORK.NSC150
            DATAFILE= "G:\esd\From XSF\Manipulating NSC files\Cohort2009Nongrad_150.csv"
            DBMS=CSV REPLACE;
     GETNAMES=YES;
     DATAROW=2;
RUN;

data nsc150a (drop= Your_Unique_Identifier enrollment_status) ;
set nsc150;
id= substr(Requester_Return_Field, 1, 9);
rename enrollment_status = enrollment_status_nsc;
label enrollment_status = 'enrollment_status_nsc';
run;/* Originally from NSC 1407 records.*/

/*Note: the records in the NSC file could include those reasonable exclusions (deaths,army, official duties, official
church missions) and those who are still enrolled at your own institution. So if you are only looking for those non-completers AND
transfer-outs, you may want to join your own institution's pre-manipulated file here to exclude those records. Or you also leave them
to the very end to exclude after manipulating the NSC file here.
*/


/***** Below I am trying to transpose the NSC data set which contains multiple rows/records for each student
to a data set which contains only one record for each student but with multiple columns for each college he/she attended.
Uust trying to save tons of time by doing this in SAS so that no need to do it manually EVERY YEAR FOR BOTH COHORTS!! *******/

proc sort data=nsc150a ; by id; run;

*Assign each record a college_sequence number, re-format the Enrollment_Begin and _End dates;
data nsc150b;
    set nsc150a(
        rename=(Enrollment_Begin=eb Enrollment_End=ee Graduation_Date=gd)
    );
    by id;
    if eb ne . then
        Enrollment_Begin = mdy(floor(mod(eb,10000)/100), mod(eb, 100),floor(eb/10000));
    if ee ne . then
        Enrollment_End = mdy(floor(mod(ee,10000)/100), mod(ee, 100),floor(ee/10000));
    if gd ne . then
        Graduation_Date = mdy(floor(mod(gd,10000)/100), mod(gd, 100),floor(gd/10000));
        
    if not first.ID and College_Sequence=. then College_Sequence=prev_seq;
    output;
    retain prev_seq;
    prev_seq = College_Sequence;
    drop eb ee gd prev_seq;
    format Enrollment_Begin Enrollment_End Graduation_Date yymmdd10.;
run; /* n=1407. Assign each record a college_sequence number, re-format the Enrollment_Begin and _End dates.*/

*combining records of the same college for each student ;
data nsc150c;
    do until(last.College_Sequence);
        set nsc150b;
        by ID College_Sequence;
        if first.College_Sequence then do;
            Days = 0;
            Graduated_NSC = 'N';
            Degree_NSC = repeat(' ', 100);
            Clevel = repeat(' ', 9);
        end;
        if Enrollment_Begin ne . and Enrollment_End ne . then Days=Days+Enrollment_End-Enrollment_Begin;
        if Class_Level ne ' ' then
            if indexw(Clevel, Class_Level)=0 then Clevel = catx(' ', Clevel, CLass_Level);
        if Graduated_='Y' then do;
            Graduated_NSC = 'Y';
            Degree_NSC = catx(' | ', Degree_nsc, Degree_Title);
        end;
           first_enrollment_begin = min(first_enrollment_begin, enrollment_begin); /*add these dates on 7/17/2014*/
           last_enrollment_end =max(last_enrollment_end, enrollment_end);         /*add these dates on 7/17/2014*/
    end;
* if EE ne . and EB ne . then Days = EE-EB;
  *keep ID Record_Found_Y_N College_Sequence College_Name DAYS Graduated_nsc __year___4_year Degree_nsc Clevel;
format first_enrollment_begin last_enrollment_end yymmddn8.;
run;/*n=319. Above is combining records of the same college for each student .*/

*transpose the data to 136 unique records of non-completers, including transfer-outs,exclusions, still-enrolls
data nsc150d;
    do until(last.ID);
        set nsc150c;
        by ID;
        array Coll_Name[5] $50.;
        array Coll_Year[5];
        array Coll_Days[5];
        array Coll_Grad[5] $1.;
        array Coll_Degr[5] $40.;
        array Coll_Clev[5] $9.;
        array Coll_EnrollBeg[5]; /*add these dates on 7/17/2014*/
        array Coll_EnrollEnd[5]; /*add these dates on 7/17/2014*/
        array Coll_State[5] $50.; /*Add these inst info on 12/5/2015, used for creating cohort grs150 file*/
        array Coll_PubPri[5] $10.;  /*Add these inst info on 12/5/2015*/
        if College_Sequence ne . then do;
            Coll_Name[College_sequence] = College_Name;
            Coll_Year[College_sequence] = /*__Year___4_year*/_2_year___4_year;
            Coll_Days[College_sequence] = Days;
            Coll_Grad[College_sequence] = Graduated_nsc;
            Coll_Degr[College_sequence] = Degree_nsc;
            Coll_Clev[COllege_sequence] = Clevel;
            Coll_EnrollBeg[College_sequence] = first_Enrollment_Begin; /*add these dates on 7/17/2014*/
             Coll_EnrollEnd[College_sequence] = last_Enrollment_End;   /*add these dates on 7/17/2014*/
            Coll_State[College_sequence] = College_State; /*Add these inst info on 12/5/2015*/
            Coll_PubPri[College_sequence] = Public___Private;  /*Add these inst info on 12/5/2015*/
        end;
    end;
    drop College_Name College_Sequence Days Graduated_nsc Degree_nsc /*__Year___4_year*/ _2_year___4_year Class_level clevel
college_code_branch  Graduated_ degree_title first_enrollment_begin last_enrollment_end
 enrollment_begin enrollment_end graduation_date ;
 format Coll_EnrollBeg1 Coll_EnrollBeg2 Coll_EnrollBeg3 Coll_EnrollBeg4 Coll_EnrollBeg5
        Coll_EnrollEnd1 Coll_EnrollEnd2 Coll_EnrollEnd3 Coll_EnrollEnd4 Coll_EnrollEnd5  Graduation_Date yymmddn8.;
run;  /*n=136; transpose the data to 136 unique records of non-completers, including transfer-outs,exclusions, still-enrolls. */

/*Now everything is transposed and enrollment days in each institution are also calculated out. It contains, for each non-completer at your own institution,
his/her enrollment/graduation information of each college starting from your own defined search-begin-date.
 
You may just use it for any other purpose, i.e., join in with your own institution's degrees data to find out the completers
at your own institution, non-completers at your own institution - transfer-outs and compelters anywhere else, non-completers anywhere at all, enrolled
at your own institution, non-enrolled anywhere else in NSC data base etc. Also for those transfer-outs, you can also define indicators of when they transferred out
and different types of transfer-outs (to 2-year/4-year, public/private, in/out of state etc.) depending your purposes of study.*/