Training: Receipt of Certificate or Vocational License - Appendix 1

National Longitudinal Survey of Youth - 1997 Cohort

Training: Receipt of Certificate or Vocational License - Appendix 1

Variables Created

  • CVC_TRN_CERT (TRNCERT)
  • CVC_TRN_CERT_DATE~M, Y (TRNCMTH, TRNCYR)

This program creates a cross-round variable that reports whether the respondent has ever received a certificate or license other than a GED through a training program. If so, a pair of cross-round variables provide the month and year that the most recent certificate or license was obtained. These variables are created for all respondents, not just those interviewed in the most recent round.

Variables Used

/**Variable Names in Program        Variable Names from Gator**/
   trncmo97                        'CV_TRN_CERT_DATE_M_1997'n
   trnYr97                         'CV_TRN_CERT_DATE_Y_1997'n
   trncrt97                        'CV_TRN_CERT_1997'n
   trncmo98                        'CV_TRN_CERT_DATE~M_1998'n
   trnYr98                         'CV_TRN_CERT_DATE~Y_1998'n
   trncrt98                        'CV_TRN_CERT_1998'n
   trncmo99                        'CV_TRN_CERT_DATE~M_1999'n
   trnYr99                         'CV_TRN_CERT_DATE~Y_1999'n
   trncrt99                        'CV_TRN_CERT_1999'n
   trncmo2000                      'CV_TRN_CERT_DATE~M_2000'n
   trnYr2000                       'CV_TRN_CERT_DATE~Y_2000'n
   trncrt2000                      'CV_TRN_CERT_2000'n
   trncmo2001                      'CV_TRN_CERT_DATE~M_2001'n
   trnYr2001                       'CV_TRN_CERT_DATE~Y_2001'n
   trncrt2001                      'CV_TRN_CERT_2001'n
   trncmo2002                      'CV_TRN_CERT_DATE~M_2002'n
   trnYr2002                       'CV_TRN_CERT_DATE~Y_2002'n
   trncrt2002                      'CV_TRN_CERT_2002'n
   trncmo2003                      'CV_TRN_CERT_DATE~M_2003'n
   trnYr2003                       'CV_TRN_CERT_DATE~Y_2003'n
   trncrt2003                      'CV_TRN_CERT_2003'n
   trncmo2004                      'CV_TRN_CERT_DATE~M_2004'n
   trnYr2004                       'CV_TRN_CERT_DATE~Y_2004'n
   trncrt2004                      'CV_TRN_CERT_2004'n
   trncmo2005                      'CV_TRN_CERT_DATE~M_2005'n
   trnYr2005                       'CV_TRN_CERT_DATE~Y_2005'n
   trncrt2005                      'CV_TRN_CERT_2005'n
   trncmo2006                      'CV_TRN_CERT_DATE~M_2006'n
   trnYr2006                       'CV_TRN_CERT_DATE~Y_2006'n
   trncrt2006                      'CV_TRN_CERT_2006'n
   trncmo2007                      'CV_TRN_CERT_DATE~M_2007'n
   trnYr2007                       'CV_TRN_CERT_DATE~Y_2007'n
   trncrt2007                      'CV_TRN_CERT_2007'n
   trncmo2008                      'CV_TRN_CERT_DATE~M_2008'n
   trnYr2008                       'CV_TRN_CERT_DATE~Y_2008'n
   trncrt2008                      'CV_TRN_CERT_2008'n
   trncmo2009                      'CV_TRN_CERT_DATE~M_2009'n
   trnYr2009                       'CV_TRN_CERT_DATE~Y_2009'n
   trncrt2009                      'CV_TRN_CERT_2009'n
   T640D1                          'YTRN-640.01~D_2010'n
   T640M1                          'YTRN-640.01~M_2010'n
   T640Y1                          'YTRN-640.01~Y_2010'n
   T640D2                          'YTRN-640.02~D_2010'n
   T640M2                          'YTRN-640.02~M_2010'n
   T640Y2                          'YTRN-640.02~Y_2010'n
   T1500D1                         'YTRN-1500.01~D_2010'n
   T1500M1                         'YTRN-1500.01~M_2010'n
   T1500Y1                         'YTRN-1500.01~Y_2010'n
   T1500D2                         'YTRN-1500.02~D_2010'n
   T1500M2                         'YTRN-1500.02~M_2010'n
   T1500Y2                         'YTRN-1500.02~Y_2010'n
   T1500D3                         'YTRN-1500.03~D_2010'n
   T1500M3                         'YTRN-1500.03~M_2010'n
   T1500Y3                         'YTRN-1500.03~Y_2010'n
   T1500D4                         'YTRN-1500.04~D_2010'n
   T1500M4                         'YTRN-1500.04~M_2010'n
   T1500Y4                         'YTRN-1500.04~Y_2010'n
   T1500D5                         'YTRN-1500.05~D_2010'n
   T1500M5                         'YTRN-1500.05~M_2010'n
   T1500Y5                         'YTRN-1500.05~Y_2010'n
   T1500D6                         'YTRN-1500.06~D_2010'n
   T1500M6                         'YTRN-1500.06~M_2010'n
   T1500Y6                         'YTRN-1500.06~Y_2010'n
   T1500D7                         'YTRN-1500.07~D_2010'n
   T1500M7                         'YTRN-1500.07~M_2010'n
   T1500Y7                         'YTRN-1500.07~Y_2010'n
   T1500D8                         'YTRN-1500.08~D_2010'n
   T1500M8                         'YTRN-1500.08~M_2010'n
   T1500Y8                         'YTRN-1500.08~Y_2010'n
   T69001                          'YTRN-6900.01_2010'n
   T69002                          'YTRN-6900.02_2010'n
   T69003                          'YTRN-6900.03_2010'n
   T69004                          'YTRN-6900.04_2010'n
   T69005                          'YTRN-6900.05_2010'n
   T69006                          'YTRN-6900.06_2010'n
   T69007                          'YTRN-6900.07_2010'n
   T69008                          'YTRN-6900.08_2010'n
   T70001                          'YTRN-7000.01_2010'n
   T70002                          'YTRN-7000.02_2010'n
   T70003                          'YTRN-7000.03_2010'n
   T70004                          'YTRN-7000.04_2010'n
   T70005                          'YTRN-7000.05_2010'n
   T70006                          'YTRN-7000.06_2010'n
   T70007                          'YTRN-7000.07_2010'n
   T70008                          'YTRN-7000.08_2010'n
   PUBID                           'PUBID_2010'n

SAS Code for Variable Creation

/*Initialize variables*/
TRNCERT=.; /*Ever received vocational/completion certificate or state license*/
TRNCMTH=.; /*Month of most recent certificate/license--based on date of completion
             of most recent cert/lic granting training program*/
TRNCYR=.;  /*Year of most recent certificate/license--based on date of completion
             of most recent cert/lic granting training program*/

/*Defining arrays*/
%let n=9;
%let R=13;

array recent(&n);
array t6900{&n};
array t7000{&n};
array t1500m{&n};
array t1500y{&n};
array t1500cm(&n);

array t640m{&n};
array t640y{&n};
array t640cm(&n);
array T_cm(&n);

array trnCRTr{&R};
array trnMr{&R};
array trnYr{&R};

 dlitrnCRT =-4;
 dlitrnM  =-4;
 dlitrnY  =-4;

 do i=1 to (&R);
   if trnYr(i)>-4 then do;
      dlitrnCRT=trnCRTr{i};
      dlitrnM=trnMr{i};
      dlitrnY=trnYr{i};
      dli=i;
    end;
 end;

 do i=1 to (&n);
    if t640m{i} >-4 & t640y{i}>-4 & t1500m{i}=-4 then do;
       t1500m{i}=t640m{i};
       t1500y{i}=t640y{i};
       t640m{i}=-4;
       t640y{i}=-4;
    end;

    if t1500m{i} >0 & t1500y{i}>0 & t6900{i}=1 and (1<=t7000{i}<=3 or t7000{i}=8) then do;
       t1500cm{i}= (t1500y{i}-1980)*12+t1500m{i};
    end;
    if t1500cm{i}>0 then do;
    T_cm(&n) =  max(of t1500cm1-t1500cm9);

  end;
end;

  do i=1 to (&n);
  if T_cm(&n)>0 then do;
              do i=396 to 216 by -12;              /*  384 Dec 2010  */
                    if  i-11<=T_cm(&n)<=i then do;
                        TRNCMTH=T_cm(&n)-(i-12);          /* 10/05= 310  10=310-(312-12)   */
                        TRNCYR=(T_cm(&n)-TRNCMTH)/12+1980;
                    end;
              end;
      end;
end;

if TRNCMTH>-4 then TRNCERT=1;

do i=1 to (&n);
  if TRNCERT^=1 then do;
      if t6900{i}=0 then TRNCERT=0;
      if t6900{i}=1 and t7000{i}>3 & t7000{i} ne 8  then TRNCERT=0;
      if t6900{i}=1 and t7000{i}<1 then TRNCERT=0;
 end;

 if t6900{i}=1 and (1<=t7000{i}<=3 or t7000{i}=8) &  TRNCMTH = . & ( t1500M(i) in (-1 -2) | t1500Y(i) in (-1 -2)) then do;
  TRNCMTH=t1500M(i);
  TRNCYR= t1500Y(i);
  TRNCERT=1;
  end;
end;

/*This part compares values for current round to created vars for previous round(s)
to obtain the most recent date of cert/lic receipt*/

do i=1 to (&R);
  if TRNCERT in(. , 0 ,-3 ) & TRNCRTR{i} in ( -3, 1) then do;
   TRNCERT=TRNCRTR{i};
   TRNCYR=TRNYR{i};
   TRNCMTH=TRNMR{i};
  end;
if TRNCERT=. and TRNCRTR{i}=0 then do;
    TRNCERT=TRNCRTR{i};
    TRNCYR=TRNYR{i};
    TRNCMTH=TRNMR{i};
end;

/*if previous report was an invalid skip and there has never been a valid cert reported,
 this carries that value forward.;*/

  if TRNCERT=1 and TRNCRTR{i}=1 and TRNYR{i}>TRNCYR then do;
   TRNCYR=TRNYR{i};
   TRNCMTH=TRNMR{i};
  end;

  if TRNCERT=1 and TRNCRTR{i}=1 and TRNYR{i}=TRNCYR and TRNMR{i}>TRNCMTH then do;
    TRNCMTH=TRNMR{i};
  end;
end;

if TRNCYR in (-1, -2) then TRNCYR=-3;
if TRNCMTH in (-1,-2) then TRNCMTH=-3;
if TRNCERT=. and t69001=-4 then TRNCERT=-4;
if TRNCERT=. and t69001=-5 then TRNCERT=-5;
if TRNCERT=. and t69001 in (-1,-2,-3) then TRNCERT=-3;

/*if R received training cert but there is no date, then date variables =
invalid skip*/

if TRNCERT=1 and TRNCMTH<1 then TRNCMTH=-3;
if TRNCERT=1 and TRNCYR<1 then  TRNCYR=-3;

/*if R took training but did not receive training cert then the date variables=
valid skip  */
if TRNCERT=0 then TRNCMTH=-4;
if TRNCERT=0 then TRNCYR=-4;
if TRNCERT=-3 then TRNCMTH=-3;
if TRNCERT=-3 then TRNCYR=-3;
if TRNCERT=-4 then TRNCMTH=-4;
if TRNCERT=-4 then TRNCYR=-4;
if  T640M1=-5 then TRNCMTH=-5;
if  T640M1=-5 then TRNCYR=-5;

if  T640M1=-5 then do;
TRNCERT=dlitrnCRT;
TRNCYR=dlitrnY;
TRNCMTH=dlitrnM;
end;
endsas;