* 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(Employment_Status)) respondent=0.
execute.

select if (respondent=1).

execute.

***Being in the labor force is defined as working for pay or seeking paid employment***. 

compute in_labor_force=0.
if ((Employment_Status=1) OR (Employment_Status=2) OR (Employment_Status=3) OR (Employment_Status=4) OR (Seeking_Employment=1) OR (Seeking_Employment=2) OR (Seeking_Employment=3)) in_labor_force=1.
execute.

***Calculate who is employed***.

Compute employed=0.
if ((Employment_Status=1) OR (Employment_Status=2) OR (Employment_Status=3) OR (Employment_Status=4)) employed=1.
execute.

***Calculate who is employed in the filed of study***.

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).