* Encoding: UTF-8.

***The data set includes both respondents and non respondents but this anlalysis is only on respondents***
***For this analysis, we will consider someone a respondent if they answered the Employment Status question***.

compute respondent=1.
if (sysmis(Current_Employment_Status)=1) respondent=0.
execute.

select if (respondent=1).

execute.

***Being in the labor force is defined as working for pay or seeking paid employment, this also includes furloughed employees (COVID years)***. 

compute in_labor_force=0.
if (Current_Employment_Status=1 OR Current_Employment_Status=2 OR Current_Employment_Status=3 OR Current_Employment_Status=5 or Current_Employment_Status=6 or Current_Employment_Status=8) in_labor_force=1.

execute.
***Calculate who is employed***.
***If the person was employed but lost employment due to COVID, the are included as employed*** (COVID years).

Compute employed=0.
if (Current_Employment_Status=1 OR Current_Employment_Status=2 OR Current_Employment_Status=3 or Current_Employment_Status=8 or Employed_Pre_Covid=1 ) employed=1.
execute.

***Calculate who is employed in the filed of study***
***Pre-COVID Job Similarity is used if current Job Similiarity is missing (COVID years)***. 

IF  (SYSMIS(Job_Similarity)) Job_Similarity=Precovid_Job_Similarity.
EXECUTE.

compute employed_in_field=0.
if ((Job_Similarity=1 or Job_Similarity=2) and employed=1) employed_in_field=1.
execute.

***Calculate who is employed in laborforce and employed in the field of study***. 
***This is by award title and award level. If you want to look at by TOP code, replace "SP_TITLE" with "SP01"***.
***If running for ACCJC, create indivdual files for each year using the Year variable***. 

DATASET DECLARE Employed_in_Field.
AGGREGATE
  /OUTFILE='Employed_in_Field'
  /BREAK=SP_TITLE SP02
  /employed_in_field_sum=SUM,(employed_in_field)
  /employed_sum=SUM(employed)
  /in_labor_force_sum=SUM(in_labor_force)
  /N_BREAK=N. 

DATASET ACTIVATE Employed_in_Field. 

compute in_labor_force_and_employed_in_field= employed_in_field_sum / in_labor_force_sum.

execute.

SORT CASES BY N_BREAK (D).