Enrollment Status and Highest Grade/Degree - Appendix 1

Enrollment Status and Highest Grade/Degree - Appendix 1

Variables Created

CV_ENROLLSTAT (ENCAT)--enrollment status as of the survey date. Use the revised CV_ENROLLSTAT_EDT series for rounds 2-8.

CV_HGC_EVER_EDT (GRSURV)--single-round variable for highest grade completed by all respondents interviewed in that round

CVC_HGC_EVER (GRSURV_CVC)--cross-round variable for highest grade completed by all respondents as of most recent interview

CV_HIGHEST_DEGREE_EVER_EDT (DEGSURV)--single-round variable for highest degree received by all respondents interviewed in that round

CVC_HIGHEST_DEGREE_EVER (DEGSURV_CVC)--cross-round variable for highest degree received by all respondents as of most recent interview

CV_HGC_1011 (GRAUG)--highest grade completed prior to the 10/11 academic year

CV_HIGHEST_DEGREE_1011 (DEGAUG)--highest degree received prior to the 10/11 academic year

This program first creates an enrollment status variable for each respondent. It then identifies the highest grade completed by the respondent as of the current round interview date and at the start of the new academic year prior to the survey round. It determines the highest degree or diploma received by the respondent as of the same two dates. Finally, it creates collapsed versions of the highest grade completed and highest degree received as cross-round variables.

The following decision rules are used to resolve conflicts in the data.

Rs who report receiving both a GED and a H. S. Diploma are coded as receiving a H. S. Diploma

Rs who report completing 12th grade but do not report receiving a H. S. Diploma or GED are coded as having completed 12th grade (in GRSURV and GRAUG, if applicable) but are not credited with a H. S. Diploma/GED on ENCAT, DEGSURV, or DEGAUG. Researchers interested in diploma receipt should use the DEGSURV or ENCAT variables, not HGC as of survey date since 12th grade completion does not necessarily signify H.S. Diploma completion.

Due to conflicting reports from a small number of Rs regarding their school attendance in the loops versus in single items, invalid skips (-3) have been filled in since no reasonable determination on the enrollment and grades completed can be made (ENCAT, GRSURV, GRAUG). Specifically, Rs are assigned a -3 if they:

report being not enrolled and

report a HGC on the single items (e3112) that is greater than the cv_highest_degree_ever for the prior round (but do not indicate completing this grade in a loop) and

report that their HGA (e2857) is two or more greater than the HGC reported in the prior round. Since these Rs provide inconsistent information multiple times, they have been assigned a -3. If they provide valid information on degrees earned, that variable will have a value.

Some respondents provide conflicting information of grades attended/completed in the schooling loops (e8416 and e9589) versus the single items (e3112, e2857). These Rs were identified as below where (ENROLL=0 and 12>=e3112^=GRSURV>0 and DEGSURV not in (1,2) and GRSURV^=95) or (0<maxgrade=GRSURV<95 and GRSURV^=e3112 and e3112<=12).

This program gives priority to information provided in the schooling loops over that provided on single item questions. Users may wish to check the CV_HGC_EVER variable against student single item self-reports of HGC (e3112), which in many cases indicates a higher grade was completed than that reported in the loops.

Even if we do not have a date for the degree received (or we have an invalid date) we code the DEGSURV for that degree.

If R reports being in a 4year college or university (this is one category) and pursuing a degree higher than a bachelor's we code their enrollment status as enrolled in a graduate program (ENCAT=11). The problem here is that since we are not sure whether they are in a 4-year college or a university, we are not sure whether their they are actually in a graduate program or in a bachelor's program but their ultimate academic goal is a graduate program. There are 54 cases in this category who do not have an Associates or Bachelor's degree. We could have used that criterion to identify those actually in a graduate program. The problem is that there are programs which give only a graduate degree without a bachelor's degree. So we code all these as ENCAT=11. If the questionnaire is changed to accommodate the graduate program option, these may be recoded in later rounds.

flagcoll=0; * Indicates if Rs currently attending grades 1-12, no HSD or GED but enrolled in college and working towards a grad or undergrad degree;

flaghs=0; * Indicates if Rs who have a H.S. Diploma and HGC=12 but still report enrollment in school;

somecoll=0; * Indicates if Rs have attended a college (in a degree program) in current or previous rounds;

prevcoll=0; * Indicates if Rs have attended a college (in a degree program) in previous rounds. This pertains to those actually enrolled in a degree program in college only;

currcoll=0; * Indicates if Rs have attended a college (in a degree program) in current round. This pertains to those enrolled in a college and reporting to be working towards a degree program. They may or may not be enrolled in a degree program.;

clg_ok=-4; * Indicates if R being in college (as reported in this round) w/o GED/HSD is OK. That is if R is actually enrolled in a degree program. This pertains to currcoll and not prevcoll.;

last_enr=0; * Identifies the last round when R was enrolled;

ungraded=0; * Indicates Rs with no H.S. Diploma or GED have HGA=95 (ungraded);

same_mth=0; * Indicates Rs who received a degree in the same month as the interview.;

rosprb3=0; * Indicates cases where start and stop dates of enrollment and school codes are missing from Roster although information is available in the data;rosprb4=0; * Indicates cases wherer stop dates of enrollment in the Roster is not the date of current interview although R reports being continuously enrolled in that school;

rosprb5=0; * Indicates a few special cases where the reason for leaving school were interchanged between school loops 1 and 2;

fill=-4; * These are filler variables that are used in arrays to match the number of elements.;

chk_comm=0; * Indicates if R reports college in this round although R does not report receiving GED or H.S. Diploma, by this round. Check the comments in current round to see whether they were actually enrolled in a degree program in a college.;

chk_commP=0; * Indicates if ENCAT in any prior rounds shows college although R does not report receiving GED or HS Diploma, by those rounds. Check the comments in current and earlier rounds for these cases to see whether they were actually enrolled in a degree program in a college.;

chk_hgc=0; * Those who received a H.S. Diploma, but report HGA<=12 & HGC<12;

chk_grmon=0; * Indicate cases where GRSURV is coded with the GRSURV at DLI, i.e., grsurvP. In these cases we must check whether that grade was completed by June of 2004 to ensure that coding GRMON also by grsurvP is correct.;

hgc_hga=0; * Indicates if Rs reporting HGC greater than HGA;

hgc_hga_n=-4; * Indicates if Rs reporting HGC greater than HGA, after HGC and HGA were edited for those never enrolled at or since DLI such that they remained the same as those at DLI.;

* Enrollment status at each interview and ENCAT at last interview;do i=1 to dim(doicmR); if encatR(i) in (8,9,10,11) then enrollR(i)=1; if encatR(i) in (1,2,3,4,5,6,7) then enrollR(i)=0; if -5<encatR(i)<0 then enrollR(i)=encatR(i); if encatR(i)~=-5 then encatP=encatR(i); if encatR(i)~=-5 then enrollP=enrollR(i); if enrollR(i)=1 then last_enr=i; if hgaR(i) not in (-4, -5) then hgaP=hgaR(i); end;

** Create variable indicating HGC by DLI;do i=1 to dim(graugR); if graugR(i)>-5 then graugP=graugR(i); if locaR(i)>-5 then locaP=locaR(i);end;

** Start and stop dates of enrollment in continuous month scheme;do i=1 to dim(degre); if stopm(i)>0 & stopy(i)>0 then stpcm(i)=((stopy(i)-1980)*12)+stopm(i); if -4<stopm(i)<0|-4<stopy(i)<0 then stpcm(i)=-3; if strtm(i)>0 & strty(i)>0 then strcm(i)=((strty(i)-1980)*12)+strtm(i); if -4<strtm(i)<0|-4<strty(i)<0 then strcm(i)=-3;end;

** Data and quex problems w/ roster information;rosprb1=0; rosprb2=0;do i=1 to dim(scode); if scode(i) in (4,5,6) & e27337(i)=-4 then rosprb1=1; if scode(i)=-4 & e27337(i)>-4 then rosprb2=1; if scode(i) in (-2,-3) then INV1=1; if scode(i) in (4,5,6) & e27337(i) in (-2,-3) then INV2=1;end;do i=1 to dim(strcm); if strcm(i)=-3 then INV3=1; if stpcm(i)=-3 then INV3=2; if strcm(i)=-3 & stpcm(i)=-3 then INV3=3;end;

if STOP>0 then diff=doicm-STOP;do i=1 to dim(degre); if rosnum=i then do; if STOP=doicm & stpcm(i)=doicm & reasn(i)>-4 then diff=10000; end;end;do i=1 to dim(degre); if strcm(i)>=-3 & stpcm(i)>=-3 then lastloopnum=i;end;

if sch in (-1,-2,-3) then lastsch=-3;if sch in (1,2,3) then lastsch=1;if sch in (4,5,6) and deg in (1,3,4,5,6,10) then lastsch=2;if sch in (4,5,6) and deg in (2,7,8,999) then lastsch=2.1;if sch in (4,5,6) and deg=9 then lastsch=2.2;if sch in (4,5,6) and deg in (-1,-2,-3) then lastsch=2.3;if sch in (4,5,6) and deg=-4 then lastsch=2.4;

* - When R attended college (in a degree program) in a previous round;do i=1 to dim(encatR); if encatR(i) in (4,5,6,7,9,10,11) & degR(i)>=1 then prevcoll=1; if encatR(i) in (4,5,6,7,9,10,11) & degR(i)<1 then do; prevcoll=1; chk_commP=1; if hsr13>-4|gdr13>-4 then chk_commP=2; end;end;

* - When R attended college (in a degree program) in a previous round and did not correct HGA as of last interview (e2806) to <13 i.e. accepts being in college as of last interview;do i=1 to dim(encatR); if (e2806r14=-4|e2806r14>=13) & encatR(i) in (4,5,6,7,9,10,11) & (hsR(i)>-4|gdR(i)>-4) then prevcoll=1; if (e2806r14=-4|e2806r14>=13) & encatR(i) in (4,5,6,7,9,10,11) & hsR(i)=-4 & gdR(i)=-4 then do; prevcoll=1; chk_commP=1; if 0<CDTHS<=doicmR(i) then chk_commP=2; if 0<CDTGD<=doicmR(i) then chk_commP=2; end;end;

*** [IA] Determining whether the respondent is enrolled or not. Note: Summer vacations are included as part of the enrollment period; if diff=0 then ENROLL=1; if diff>0 then ENROLL=0; if -3<=STOP<=-1 then ENROLL=0; if e3877A1r14=0 then ENROLL=0; do i=1 to dim(scode); if scode(i) in (4,5,6) then chk_enr2=0; end; if HSD=1 & ENROLL=1 & chk_enr2 ne 0 then do; chk_enr2=1; ENROLL=0; end;

*** ENRollx; if e3877A1r14=0 then enrollx=0; if e4795r14=1 & e4951r14=0 then enrollx=1;

if e4795r14=0 then do; if e1605r14=-4 & e4951r14=0 then enrollx=0; if e1605r14=1 then do; if e1615r14_1=1 & e4951r14=0 then enrollx=1; if e1615r14_1=0 & e1627r14_1=0 & e4951r14=0 then enrollx=0; end; if e1605r14=0 and e4951r14=0 then enrollx=0; end; if (e4951r14=1 or e3877A1r14=1) then do; do i=1 to dim(e6784); if e6784(i)=1 & e7192(i)=0 then enrollx=1; end; do i=1 to dim(e6784); if e6938(i)=0 & e7192(i)=0 then enrollx=0; end; do i=1 to dim(e6784); if e6784(i)=0 & e7192(i)=0 then do; if e6943(i)=1 then enrollx=1; end; end; do i=1 to dim(e6784); if e7142(i)=0 & e7192(i)=0 then enrollx=0; end; end;

*** change "enroll" after going through the cases where "enroll" disagrees with "enrollx";

if ENROLL=0 then do; if (GED<=0) & (HSD<=0) then ENCAT=1; if GED=1 then ENCAT=2; if HSD=1 then ENCAT=3; if prevcoll=1 then ENCAT=4; if currcoll=1 & ((13<=e2857r14<=20)|e3112r14>=12|HSD=1|GED=1|clg_ok=1) then ENCAT=4; if CDTAA>-4 then ENCAT=5; if CDTBA>-4 then ENCAT=6; if CDTMA>-4|CDTDC>-4|CDTPF>-4 then ENCAT=7; end;

if lastsch>2 then do; if GED=0 & HSD=0 & somecoll=0 then ENCAT=8; if currcoll=0 & prevcoll=1 then do; ENCAT=4; if CDTAA>-4 then ENCAT=5; if CDTBA>-4 then ENCAT=6; if CDTMA>-4|CDTDC>-4|CDTPF>-4 then ENCAT=7; end; if currcoll=1 & (HSD=1|GED=1|clg_ok=1) then do; ENCAT=4; if CDTAA>-4 then ENCAT=5; if CDTBA>-4 then ENCAT=6; if CDTMA>-4|CDTDC>-4|CDTPF>-4 then ENCAT=7; end; end; if lastsch=-3 then do; if (HSD=1|GED=1|clg_ok=1) & currcoll=1 then ENCAT=4; if (HSD=1|GED=1) & prevcoll=1 then ENCAT=4; if CDTAA>-4 & somecoll=1 then ENCAT=5; if CDTBA>-4 & somecoll=1 then ENCAT=6; if (CDTMA>-4|CDTDC>-4|CDTPF>-4) & somecoll=1 then encat=7; end; if GED=1 & HSD=0 & somecoll=0 then ENCAT=2; if HSD=1 & somecoll=0 then ENCAT=3;

********************************************** SECTION II **********************************************; if ENCAT in (1,2,3,4,5,6,7) & ENROLL~=0 then do; ENROLL=0; enr_chg=2; end; if ENCAT in (8,9,10,11) & ENROLL~=1 then do; ENROLL=1; enr_chg=3; end;subsitm=0; * Flag to indicate e3112 (single item) is being used to compute GRSURV;subhgam=0; * Flag to hgaloop (HGA from loop) minus 1 is being used to compute GRSURV;subprev=0; * Flag to indicate grade from last interviewed round is being used to compute GRSURV;setto12=0; * Flag to indicate GRSURV being set to 12;

dateitm=0; * Flag to indicate date of grade completion missing;disagre=0; * Flag to indicate that GRSURV from previous rounds is greater than from the current round;datedeg=0; * Flag to indicate date of degree received is invalid;

** attsch=0; if LOCATOR~=15 then do; if attsch=0 & e3877A1r14~=0 & 0<=e3112r14<=12 & 0<=grsurvP<GRSURV<=12 then do; GRSURV=grsurvP; GRAUG=GRSURV; LOCATOR=20.1; LOCA=20.1; end; if attsch=0 & e3877A1r14~=0 & 12<e3112r14<95 & 0<=grsurvP_no3061<GRAUG<=12 then do; GRAUG=grsurvP_no3061; LOCA=20.2; end; end; end;***** end of the loop for those who are asked of 3112;***** for those who were HE in the DLI and not enrolled at or since DLI; if e3877A1r14=0 then do; if locatorr13=15 then do; grsurv=cvc_hgcr13; locator=15; end; if locaP=15 then do; graug=graugP; loca=15; end; end;

*********************************************************************************************************** [IV] CREATED VARIABLE - HIGHEST DEGREE RECEIVED AS OF THE SURVEY DATE (DEGSURV) ***********************************************************************************************************; DEGSURV=0; if GED=1 then DEGSURV=1; if GED=-3 then DEGSURV=-3; if HSD=1 then DEGSURV=2; if HSD=-3 then DEGSURV=-3; ** Junior College or two-year Associate Degree; if CDTAA>-4 then DEGSURV=3;

** Bachelor's Degree; if CDTBA>-4 then DEGSURV=4; ** Master's Degree; if CDTMA>-4 then DEGSURV=5; ** Doctoral Degree; if CDTDC>-4 then DEGSURV=6; ** Professional Degree; if CDTPF>-4 then DEGSURV=7; ** If degree received cannot determine what degree received; do i=1 to dim(e23450); if e23450(i) in (-1, -2, -3) then DEGSURV=-3; end; ** Check these cases as they should not occur; if 0<=DEGSURV<cvc_hdgr13 then prev_deg=1;

DEGAUG=0; ** GED; if 0<CDTGD<=MONYR then DEGAUG=1; if CDTGD in (-3, -2, -1) then DEGAUG=-3; ** High School Diploma; if 0<CDTHS<=MONYR then DEGAUG=2; if CDTHS in (-3, -2, -1) then DEGAUG=-3; ** Junior College or 2-year Associate Degree; if 0<CDTAA<=MONYR then DEGAUG=3; if CDTAA in (-3, -2, -1) then DEGAUG=-3; ** Bachelor's Degree; if 0<CDTBA<=MONYR then DEGAUG=4; if CDTBA in (-3, -2, -1) then DEGAUG=-3; ** Master's Degree; if 0<CDTMA<=MONYR then DEGAUG=5; if CDTMA in (-3, -2, -1) then DEGAUG=-3; ** Doctoral Degree; if 0<CDTDC<=MONYR then DEGAUG=6; if CDTDC in (-3, -2, -1) then DEGAUG=-3; ** Professional Degree; if 0<CDTPF<=MONYR then DEGAUG=7; if CDTPF in (-3, -2, -1) then DEGAUG=-3; if DEGSURV=-3 then DEGAUG=-3;