VARIABLE NAME: PROG

DESCRIPTOR: Program (School and Major)

DEFINITION: The combination of School (SCHOOL) and Major (MAJOR) variables resulting in a 6-digit code to identify a program within a college.  

VALUES: See the USC Codebook, under Simple Search select VALID SCHOOL MAJOR DEGREE COMBINATIONS (E0784).

FIELD ATTRIBUTE: A6

NOTE: School (SCHOOL) and Major (MAJOR) are each 3-digit variables. Program (PROG) is the concatenation of these two variables to create a new 6-digit variable that, due to organizational changes within colleges and majors, allows for the selection of the college that owned the major during any specific terms.   

SOURCE: USC INFO and Degrees Awarded Files

EXAMPLE: To select undergraduate students in Exercise Science in the Arnold School of Public Health, type PROG='270331' in the WHERE statement, since the undergraduate school code for the Arnold School of Public Health = '270' and the Exercise Science major code = '331'. To select all students (undergraduate and graduate) in the Exercise Science program in the Arnold School of Public Health only, type PROG IN ('270331','275331') in the WHERE statement, since the undergraduate school code for the Arnold School of Public Health = '270', the graduate school code for the Arnold School of Public Health = '275', and the Exercise Science major code = '331'.