Syntax

Common Data Recodes

Syntax for collapsing response options on survey items or otherwise reconfiguring existing data into new variables.

A convenient way to present frequency distributions is to recode response options into simpler categories - usually collapsing them down to just two groups. For example, NSSE items using the "how often" response options-Never, Sometimes, Often, and Very often-can be recoded so that Often and Very often are combined into a single category called "Frequently". Likewise, the "emphasis" response set-Very little, Some, Quite a bit, and Very much-can be recoded so that the top two response options are combined into a category called "Substantial." It may also be preferable to isolate the percentage of students who have "Never" engaged in a particular activity, or who otherwise selected the lowest possible response.


****************************** RECODING RESPONSE CATEGORIES.

***** This syntax is written for the updated NSSE (since 2013) data sets and variables.
***** Data from earlier years may have different variables and variable names which do not fit the syntax provided below.

***** DICHOTOMIZE THE “HOW OFTEN” ITEMS.

**** RECODE AND FLAG 'FREQUENTLY'.

RECODE askquest drafts unprepared unpreparedr attendart
CLaskhelp CLexplain CLstudy CLproject present RIintegrate RIsocietal RIdiverse
RIownview RIperspect RInewview RIconnect SFcareer SFotherwork SFdiscuss
SFperform QRconclude QRproblem QRevaluate DDrace DDeconomic DDreligion
DDpolitical LSreading LSnotes LSsummary (1, 2 = 0) (3, 4 = 1)
INTO faskquest fdrafts funprepared funpreparedr fattendart
fCLaskhelp fCLexplain fCLstudy fCLproject fpresent fRIintegrate fRIsocietal fRIdiverse
fRIownview fRIperspect fRInewview fRIconnect fSFcareer fSFotherwork fSFdiscuss
fSFperform fQRconclude fQRproblem fQRevaluate fDDrace fDDeconomic fDDreligion
fDDpolitical fLSreading fLSnotes fLSsummary.

VALUE LABELS faskquest fdrafts funprepared funpreparedr fattendart
fCLaskhelp fCLexplain fCLstudy fCLproject fpresent fRIintegrate fRIsocietal fRIdiverse
fRIownview fRIperspect fRInewview fRIconnect fSFcareer fSFotherwork fSFdiscuss
fSFperform fQRconclude fQRproblem fQRevaluate fDDrace fDDeconomic fDDreligion
fDDpolitical fLSreading fLSnotes fLSsummary 0 'Infrequently' 1 'Frequently'.

EXECUTE.

**** RECODE AND FLAG 'NEVER'.

RECODE askquest drafts unprepared unpreparedr attendart
CLaskhelp CLexplain CLstudy CLproject present RIintegrate RIsocietal RIdiverse
RIownview RIperspect RInewview RIconnect SFcareer SFotherwork SFdiscuss
SFperform QRconclude QRproblem QRevaluate DDrace DDeconomic DDreligion
DDpolitical LSreading LSnotes LSsummary (1= 1) (2, 3, 4 = 0)
INTO naskquest ndrafts nunprepared nunpreparedr nattendart
nCLaskhelp nCLexplain nCLstudy nCLproject npresent nRIintegrate nRIsocietal nRIdiverse
nRIownview nRIperspect nRInewview nRIconnect nSFcareer nSFotherwork nSFdiscuss
nSFperform nQRconclude nQRproblem nQRevaluate nDDrace nDDeconomic nDDreligion
nDDpolitical nLSreading nLSnotes nLSsummary.

VALUE LABELS naskquest ndrafts nunprepared nunpreparedr nattendart
nCLaskhelp nCLexplain nCLstudy nCLproject npresent nRIintegrate nRIsocietal nRIdiverse
nRIownview nRIperspect nRInewview nRIconnect nSFcareer nSFotherwork nSFdiscuss
nSFperform nQRconclude nQRproblem nQRevaluate nDDrace nDDeconomic nDDreligion
nDDpolitical nLSreading nLSnotes nLSsummary 1 'Never' 0 'At least sometimes'.

EXECUTE.

***** DICHOTOMIZE THE ‘EMPHASIS’ and SELF-REPORTED GAINS ITEMS.
***** RECODE AND FLAG 'SUBSTANTIAL'.

RECODE memorize HOapply HOanalyze HOevaluate HOform ETgoals ETorganize ETexample
ETdraftfb ETfeedback empstudy SEacademic SElearnsup SEdiverse SEsocial SEwellness
SEnonacad SEactivities SEevents pgwrite pgspeak pgthink pganalyze pgwork pgothers pgvalues
pgdiverse pgprobsolve pgcitizen (1, 2 = 0) (3, 4 = 1)
INTO smemorize sHOapply sHOanalyze sHOevaluate sHOform sETgoals sETorganize sETexample
sETdraftfb sETfeedback sempstudy sSEacademic sSElearnsup sSEdiverse sSEsocial sSEwellness
sSEnonacad sSEactivities sSEevents spgwrite spgspeak spgthink spganalyze spgwork spgothers spgvalues
spgdiverse spgprobsolve spgcitizen.

VALUE LABELS smemorize sHOapply sHOanalyze sHOevaluate sHOform sETgoals sETorganize sETexample
sETdraftfb sETfeedback sempstudy sSEacademic sSElearnsup sSEdiverse sSEsocial sSEwellness
sSEnonacad sSEactivities sSEevents spgwrite spgspeak spgthink spganalyze spgwork spgothers spgvalues
spgdiverse spgprobsolve spgcitizen 0 'Not Substantial' 1 'Substantial'.

EXECUTE.

**** RECODE AND FLAG 'VERY LITTLE'.

RECODE memorize HOapply HOanalyze HOevaluate HOform ETgoals ETorganize ETexample
ETdraftfb ETfeedback empstudy SEacademic SElearnsup SEdiverse SEsocial SEwellness
SEnonacad SEactivities SEevents pgwrite pgspeak pgthink pganalyze pgwork pgothers pgvalues
pgdiverse pgprobsolve pgcitizen (1 = 1) (2, 3, 4 = 0)
INTO vlmemorize vlHOapply vlHOanalyze vlHOevaluate vlHOform vlETgoals vlETorganize vlETexample
vlETdraftfb vlETfeedback vlempstudy vlSEacademic vlSElearnsup vlSEdiverse vlSEsocial vlSEwellness
vlSEnonacad vlSEactivities vlSEevents vlpgwrite vlpgspeak vlpgthink vlpganalyze vlpgwork vlpgothers vlpgvalues
vlpgdiverse vlpgprobsolve vlpgcitizen.

VALUE LABELS vlmemorize vlHOapply vlHOanalyze vlHOevaluate vlHOform vlETgoals vlETorganize vlETexample
vlETdraftfb vlETfeedback vlempstudy vlSEacademic vlSElearnsup vlSEdiverse vlSEsocial vlSEwellness
vlSEnonacad vlSEactivities vlSEevents vlpgwrite vlpgspeak vlpgthink vlpganalyze vlpgwork vlpgothers vlpgvalues
vlpgdiverse vlpgprobsolve vlpgcitizen 1 'Very little' 0 'At least some'.

EXECUTE.

***** RECODE QUALITY OF INTERACTION ITEMS.

MISSING VALUES QIstudent QIadvisor QIfaculty QIstaff QIadmin (9).

RECODE QIstudent QIadvisor QIfaculty QIstaff QIadmin (1, 2 = 0) (3, 4, 5 = 1) (6, 7 = 2)
INTO QIstudentR QIadvisorR QIfacultyR QIstaffR QIadminR.

VALUE LABELS QIstudentR QIadvisorR QIfacultyR QIstaffR QIadminR
0 'Low rating (1 or 2)' 1 'Moderate ratings (3, 4, or 5)' 2 'High ratings (6 or 7)'.

***** RECODE AND FLAG PARTICIPATION IN High-Impact Activities.

RECODE intern leader learncom abroad research capstone (1, 2, 3 = 0) (4 = 1) INTO
internR leaderR learncomR abroadR researchR capstoneR.

VALUE LABELS internR leaderR learncomR abroadR researchR capstoneR 0 'Not Done' 1 'Done or in progress'.

RECODE servcourse (4, 3, 2=1) (1=0) INTO servcourseR.

VALUE LABELS servcourseR 0 'None' 1 'At least some'.

EXECUTE.

***** EXTENT TO WHICH COURSES HAVE CHALLENGED TO DO BEST WORK.
***** COLLAPSE INTO LOW, MEDIUM and HIGH CATEGORIES.

RECODE challenge (1, 2 = 0) (3 thru 5 = 1) (6, 7 =2) into challengeR.

VALUE LABELS challengeR 0 'Low challenge (1-2)' 1 'Medium challenge (3-5)' 2 'High challenge (6-7)'.

EXECUTE.
***** NUMBER OF WRITTEN PAPERS.

***** RECODE AND FLAG 'AT LEAST 6'.

RECODE wrshort wrmed wrlong (1 thru 3 = 0) (4 thru 7 = 1) INTO wrshort6 wrmed6 wrlong6.

VALUE LABELS wrshort6 wrmed6 wrlong6 0 '5 or fewer' 1 'At least 6'.

EXECUTE.

****RECODE AND FLAG 'NONE'.

RECODE wrshort wrmed wrlong (1 = 1) (2 thru 7 = 0) INTO wrshort0 wrmed0 wrlong0.

VALUE LABELS wrshort0 wrmed0 wrlong0 1 'None' 0 'At least 1' .

EXECUTE.


***** HOURS PER WEEK.

***** RECODE AND FLAG '6 HOURS OR MORE'.

RECODE tmprep tmcocurr tmworkon tmworkoff tmservice tmrelax tmcare tmcommute (1, 2 = 0) (3 thru 8 = 1)
INTO tmprep6 tmcocurr6 tmworkon6 tmworkoff6 tmservice6 tmrelax6 tmcare6 tmcommute6.

VALUE LABELS tmprep6 tmcocurr6 tmworkon6 tmworkoff6 tmservice6 tmrelax6 tmcare6 tmcommute6 0 '5 or fewer hours ' 1 '6 or more hours'.

EXECUTE.

***** RECODE AND FLAG '0 HOURS PER WEEK'.


RECODE tmprep tmcocurr tmworkon tmworkoff tmservice tmrelax tmcare tmcommute (1 = 1) (2 thru 8 = 0)
INTO tmprep0 tmcocurr0 tmworkon0 tmworkoff0 tmservice0 tmrelax0 tmcare0 tmcommute0.

VALUE LABELS tmprep0 tmcocurr0 tmworkon0 tmworkoff0 tmservice0 tmrelax0 tmcare0 tmcommute0 1 '0 hours' 0 '1 or more hours'.

EXECUTE.

**************************************** SATISFACTION.

RECODE evalexp sameinst (1, 2 = 0) (3, 4 = 1) INTO evalexpR sameinstR.

VALUE LABELS evalexpR 0 'Poor/Fair' 1 'Good/Excellent'.
VALUE LABELS sameinstR 0 'No' 1 'Yes'.

EXECUTE.

NSSE asks students to estimate how much time they spent on a variety of activities in a typical 7-day week. The SPSS syntax linked below converts these "time on task" variables to hour-per-week units to make it possible to report the approximate number of hours on a particular activity (e.g., "First-year students spent on average about 13 hours per week preparing for classes."). Response options for these items are 0, 1-5, 6-10, 11-15, 16-20, 21-25, 26-30, and more than 30 hours per week. The SPSS syntax linked below assigns the midpoint value to each response range to estimate the number of hours spent. For example, 1-5 is recoded to 3 hours per week, and 6-10 is recoded to 8 hours per week. "More than 30" is arbitrarily assigned a value of 33 hours per week. Of course, these estimates are not intended to be accurate for an individual student, but they are very informative and useful when aggregating to the group level.

 

*********************************************************.

***** ESTIMATING HOURS PER WEEK AT THE GROUP LEVEL.
***** NSSE asks students to estimate how much time they spend on a variety of activities in a typical 7-day week.
***** This syntax converts these “time on task” variables to hours per week units to make it possible to report the approximate
***** number of hours on a particular activity (e.g., “FY students spent on average about 13 hours per week preparing for classes.”).

***** Response options for these items are ‘0’, ‘1-5’, ‘6-10’, ‘11-15’, ‘16-20’, ‘21-25’, ‘26-30’, and ‘more than 30’ hours per week.
***** The syntax below assigns the mid-point value to each response range to estimate the number of hours. For example, ‘1-5’ is recoded
***** to 3 hours per week, and ‘6-10’ is recoded to 8 hours per week. ‘More than 30’ is arbitrarily assigned a value of 33 hours per week.
***** These estimates are not intended to be accurate for an individual student, but they are very informative and useful when aggregating to the group level.

RECODE tmprep (1=0) (2=3) (3=8) (4=13) (5=18) (6=23) (7=28) (8=33) INTO tmprephrs.
RECODE tmcocurr (1=0) (2=3) (3=8) (4=13) (5=18) (6=23) (7=28) (8=33) INTO tmcocurrhrs.
RECODE tmworkon (1=0) (2=3) (3=8) (4=13) (5=18) (6=23) (7=28) (8=33) INTO tmworkonhrs.
RECODE tmworkoff (1=0) (2=3) (3=8) (4=13) (5=18) (6=23) (7=28) (8=33) INTO tmworkoffhrs.
RECODE tmservice (1=0) (2=3) (3=8) (4=13) (5=18) (6=23) (7=28) (8=33) INTO tmservicehrs.
RECODE tmrelax (1=0) (2=3) (3=8) (4=13) (5=18) (6=23) (7=28) (8=33) INTO tmrelaxhrs.
RECODE tmcare (1=0) (2=3) (3=8) (4=13) (5=18) (6=23) (7=28) (8=33) INTO tmcarehrs.
RECODE tmcommute (1=0) (2=3) (3=8) (4=13) (5=18) (6=23) (7=28) (8=33) INTO tmcommutehrs.
VARIABLE LEVEL tmprephrstmcocurrhrstmworkonhrstmworkoffhrstmservicehrstmrelaxhrstmcarehrstmcommutehrs (SCALE).
EXECUTE.

**** Combining tmworkonhrs and tmworkoffhrs.
NUMERIC tmworkhrs (F4.0).
VARIABLE LEVEL tmworkhrs (SCALE).
VARIABLE LABELS tmworkhrs 'Estimated hours: Combination of tmworkon and tmworkoff'.
COMPUTE tmworkhrs=tmworkonhrs + tmworkoffhrs.
EXECUTE.

***** COMPUTE THE AVERAGE HOURS PER WEEK BY CLASS.
SUBTITLE "First-Year Student Time on Task Descriptives".
TEMPORARY.
SELECT IF (IRclass eq 1).
DESCRIPTIVES tmprephrstmcocurrhrstmworkonhrstmworkoffhrstmservicehrstmrelaxhrstmcarehrstmcommutehrs.

SUBTITLE "Senior Time on Task Descriptives".
TEMPORARY.
SELECT IF (IRclass eq 4).
DESCRIPTIVES tmprephrstmcocurrhrstmworkonhrstmworkoffhrstmservicehrstmrelaxhrstmcarehrstmcommutehrs.

*********************************************************.
***** Recode NSSE 2013 reading item (tmread) into hours.

RECODE tmread (1=0) (2=3) (3=8) (4=13) (5=18) (6=23) (7=28) (8=33) INTO tmreadhrs.
VARIABLE LEVEL tmreadhrs (SCALE).
EXECUTE.

*********************************************************.
***** Recode NSSE 2014 reading item into hours per week.
***** Response options for this items are ‘Very little', 'Some', 'About half', 'Most', 'Almost all'.
***** The syntax below assigns .1 for 'Very little', .25 for 'Some', .5 for 'About half', .75 for 'Most', and .9 for 'Almost all'.
***** Again, these estimates are not intended to be accurate for an individual student, but they are very informative and useful when aggregating to the group level.

NUMERIC tmreadinghrs (F4.2).
VARIABLE LABELS tmreadinghrs 'Estimated hours: reading recoded by NSSE using tmprephrs and reading'.
IF reading=1 tmreadinghrs=.1*tmprephrs.
IF reading=2 tmreadinghrs=.25*tmprephrs.
IF reading=3 tmreadinghrs=.5*tmprephrs.
IF reading=4 tmreadinghrs=.75*tmprephrs.
IF reading=5 tmreadinghrs=.9*tmprephrs.
EXECUTE.
**** Dichotomize reading into more or less than 10 hours per week.
NUMERIC dtmreadinghrs (F4.0).
VARIABLE LABELS dtmreadinghrs 'Dichotomous recode of tmreadinghrs for reporting'.
VALUE LABELS dtmreadinghrs 0 '10 or fewer hours/week' 1 'More than 10 hours/week'.
RECODE tmreadinghrs (0 THRU 10=0) (10.01 THRU HIGHEST=1) INTO dtmreadinghrs.
EXECUTE.

**** Collapsed version of hours reading per week.
NUMERIC tmreadinghrscol (F4.0).
RECODE tmreadinghrs (0=1) (.001 THRU 5=2) (5.001 THRU 10=3) (10.001 THRU 15=4)
(15.001 THRU 20=5) (20.001 THRU 25=6) (25.001 THRU 30=7) INTO tmreadinghrscol.
VARIABLE LABELS tmreadinghrscol 'Collapsed recode of tmreadinghrs'.
VARIABLE LEVEL tmreadinghrscol(ORDINAL).
VALUE LABELS tmreadinghrscol
1 '0 hrs'
2 'More than zero, up to 5 hrs'
3 'More than five, up to 10hrs'
4 'More than 10, up to 15 hrs'
5 'More than 15, up to 20 hrs'
6 'More than 20, up to 25 hrs'
7 'More than 25 hrs'.
EXECUTE.

NSSE asks students to estimate the number writing assignments of certain lengths they have done during the school year. The SPSS syntax linked below converts these writing items to

  1. Estimated number of assigned papers written up to 5 pages, between 6 and 10 pages, and 11 or more pages (e.g., "First-year students were assigned an average of 3 writing assignments between 6 and 10 pages.").
  2. Estimated pages of assigned writing (e.g., "Seniors were assigned an average of 75 pages of writing.").

To estimate the number of assigned papers of a specific length, response options for these items (none, 1-2, 3-5, 6-10, 11-15, 16-20, and more than 20 papers) are recoded to the midpoint value of each response range. For example, 1-2 is recoded as 1.5 papers, and 3-5 is recoded as 4 papers. "More than 20" papers is arbitrarily assigned a value of 23 papers.

To estimate the number of pages of assigned writing, the average number of writing assignments of a given page-length was multiplied by an approximate number of pages for the assignment type. The number of pages assigned as the midpoint of the ranges "up to 5" pages is 3 pages, "between 6 and 10" pages is 8 pages, and "11 or more" pages was arbitrarily assigned a value of 15 pages. These numbers of pages assigned midpoints are then multiplied by the response option midpoints then summed together to estimate the number of pages of assigned writing. For example, a student who wrote 11 to 15 papers of up to 5 pages, 3 to 5 papers of between 6 and 10 pages, and 1 to 2 papers of 11 or more pages would have a value of 93.5 for estimated number of assigned writing [(13*3)+(4*8)+(1.5*15)=93.5].

Of course, these estimates are not intended to be accurate for an individual student, but they are very informative and useful when aggregating to the group level.


*********************************************************.
ESTIMATING NUMBERS OF PAGES WRITTEN AT THE GROUP LEVEL.
*********************************************************.

*********************************************************.
A. ESTIMATED NUMBER OF ASSIGNED PAPERS OF A GIVEN LENGTH.
*********************************************************.

RECODE wrshort (1=0) (2=1.5) (3=4) (4=8) (5=13) (6=18) (7=23) INTO wrshortnum.
RECODE wrmed (1=0) (2=1.5) (3=4) (4=8) (5=13) (6=18) (7=23) INTO wrmednum.
RECODE wrlong (1=0) (2=1.5) (3=4) (4=8) (5=13) (6=18) (7=23) INTO wrlongnum.
VARIABLE LEVEL wrshortnumwrmednumwrlongnum (SCALE).
VARIABLE LABELS wrshortnum 'Estimated number of assigned papers, reports, etc., up to 5 pages'.
VARIABLE LABELS wrmednum 'Estimated number of assigned papers, reports, etc., between 6 and 10 pages'.
VARIABLE LABELS wrlongnum 'Estimated number of assigned papers, reports, etc., 11 pages or more'.
EXECUTE.


*********************************************************.
B. ESTIMATED PAGES OF ASSIGNED WRITING.
*********************************************************.

RECODE wrshort (1=0) (2=4.5) (3=12) (4=24) (5=39) (6=54) (7=69) INTO wr1.
RECODE wrmed (1=0) (2=12) (3=32) (4=64) (5=104) (6=144) (7=184) INTO wr2.
RECODE wrlong (1=0) (2=22.5) (3=60) (4=120) (5=195) (6=270) (7=345) INTO wr3.
EXECUTE.

COMPUTE wrpages=wr1+wr2+wr3.
VARIABLE LEVEL wrpages (SCALE).
VARIABLE LABELS wrpages 'Estimated pages of assigned writing'.
EXECUTE.
DELETE VARIABLES wr1 wr2 wr3.

There are several ways to define first-generation status. This SPSS syntax linked below recodes parental education to meet two distinct definitions:

  1. Highest level of education for either parent is less than a bachelor's degree (parents may have some postsecondary education).
  2. Highest level of education for either parent is a high school diploma or less (parents have no experience in postsecondary education).

*********************************************************.
***** RECODES FOR PARENTAL EDUCATION--->>FIRST-GENERATION STATUS.

*********************************************************.
***** FIRST-GENERATION, OPTION 1: Creates a dummy variable for first-generation status where the
highest level of parent education is less than a bachelor's degree.
***** FIRST-GENERATION, OPTION 2: Creates a dummy variable for first-generation status where the
parents have no experience in higher education.
*********************************************************.

***** FIRST-GENERATION, OPTION 1.
***** First-generation status is defined as neither parent having earned a bachelor's degree (parents may have some postsecondary experience).
***** Thus, the highest level of education for either parent is less than a bachelor's degree.
***** This is the first-generation variable included in the NSSE dataset.
***** This definition is used by the U.S. Department of Education for TRIO programs (34 C.F.R. § 646.7).

RECODE parented (1 thru 4=1) (5 thru 7=0) INTO firstgen.
VARIABLE LABELS firstgen "First-Generation Status (neither parent/guardian holds a bachelor's degree)".
FORMATS firstgen(F4.0).
VALUE LABELS firstgen
0 'No'
1 'Yes'.
EXECUTE.

FREQUENCIES firstgen.

**********************************************.
**** FOR CANADIAN INSTITUTIONS.
**** RECODE PARENTED_CA TO FIRSTGEN.
****IF (parented_ca LE 4) firstgen = 1.
****IF (parented_ca GT 4) firstgen = 0.
****EXECUTE.


***** FIRST-GENERATION, OPTION 2.
***** First-generation status is defined as neither parent having any postsecondary experience.
***** Thus, the highest level of education for either parent is a high school diploma.
***** This is an alternate definition of first-generation status sometimes used (see Chen, 2005).
***** Chen, X. (2005). First Generation Students in Postsecondary Education: A Look at Their College Transcripts
(NCES 2005–171). U.S. Department of Education, National Center for Education Statistics. Washington,
DC: U.S. Government Printing Office.

RECODE parented (1 thru 2=1) (3 thru 7=0) INTO firstgenHS.
VARIABLE LABELS firstgenHS 'First-Generation Status (no parent/guardian has any postsecondary experience)'.
FORMATS firstgenHS (F4.0).
VALUE LABELS firstgenHS
0 'Not first-generation (at least one parent/guardian has some postsecondary experience)'
1 'First-generation (no parent/guardian has any postsecondary experience)'.
EXECUTE.

FREQUENCIES firstgenHS.

The Classification of Instructional Programs (CIP) was developed by the National Center for Education Statistics to track enrollment and degree completion by field of study. To better understand how NSSE's major fields relate to CIP codes, or to add CIP codes into a NSSE data file, the syntax below recodes NSSE majors into the four and six-digit CIP coding scheme. We also have an excel crosswalk table available.

*********************************************************.

numeric CIP6 (F8.4).
numeric CIP4 (F8.2).
variable level CIP4 CIP6 (nominal).
variable labels CIP4 '4-digit CIP code associated with primary NSSE major code'
/CIP6 '6-digit CIP code associated with primary NSSE major code'.


*********************Arts & Humanities.

*Arts, fine and applied.
if (MAJfirstcode eq 1) CIP6 = 50.0701.
add value labels CIP6 50.0701 'Art/Art Studies, General'.
if (MAJfirstcode eq 1) CIP4 = 50.07.
add value labels CIP4 50.07 'Fine and Studio Arts'.
*if (MAJfirstcode eq 1) CIP6 = 50.0702.
*add value labels CIP6 50.0702 'Fine/Studio Arts, General'.
*if (MAJfirstcode eq 1) CIP4 = 50.04.
*add value labels CIP4 50.04 'Design and Applied Arts'.
*if (MAJfirstcode eq 1) CIP6 = 50.0409.
*add value labels CIP6 50.0409 'Graphic Design'.

*Architecture.
if (MAJfirstcode eq 2) CIP6 = 4.0201.
add value labels CIP6 4.0201 'Architecture'.
if (MAJfirstcode eq 2) CIP4 = 4.02.
add value labels CIP4 4.02 'Architecture'.

*Art history.
if (MAJfirstcode eq 3) CIP6 = 50.0703.
add value labels CIP6 50.0703 'Art History, Criticism and Conservation'.
if (MAJfirstcode eq 3) CIP4 = 50.07.
add value labels CIP4 50.07 'Fine and Studio Arts'.

*English (language and literature).
if (MAJfirstcode eq 4) CIP6 = 23.0101.
add value labels CIP6 23.0101 'English Language and Literature, General'.
if (MAJfirstcode eq 4) CIP4 = 23.01.
add value labels CIP4 23.01 'English Language and Literature, General'.

*French (language and literature).
if (MAJfirstcode eq 5) CIP6 = 16.0901.
add value labels CIP6 16.0901 'French Language and Literature'.
if (MAJfirstcode eq 5) CIP4 = 16.09.
add value labels CIP4 16.09 'Romance Languages, Literatures, and Linguistics'.

*Spanish (language and literature).
if (MAJfirstcode eq 6) CIP6 = 16.0905.
add value labels CIP6 16.0905 'Spanish Language and Literature'.
if (MAJfirstcode eq 6) CIP4 = 16.09.
add value labels CIP4 16.09 'Romance Languages, Literatures, and Linguistics'.

*Other language and literature.
if (MAJfirstcode eq 7) CIP6 = 16.0101.
add value labels CIP6 16.0101 'Foreign Languages and Literatures, General'.
if (MAJfirstcode eq 7) CIP4 = 16.01.
add value labels CIP4 16.01 'Linguistic, Comparative, and Related Language Studies and Services'.

*History.
if (MAJfirstcode eq 8) CIP6 = 54.0101.
add value labels CIP6 54.0101 'History, General'.
if (MAJfirstcode eq 8) CIP4 = 54.01.
add value labels CIP4 54.01 'History'.

*Humanities (general).
if (MAJfirstcode eq 9) CIP6 = 24.0103.
add value labels CIP6 24.0103 'Humanities/Humanistic Studies'.
if (MAJfirstcode eq 9) CIP4 = 24.01.
add value labels CIP4 24.01 'Liberal Arts and Sciences, General Studies and Humanities'.

*Music.
if (MAJfirstcode eq 10) CIP6 = 50.0901.
add value labels CIP6 50.0901 'Music, General'.
if (MAJfirstcode eq 10) CIP4 = 50.09.
add value labels CIP4 50.09 'Music'.
*if (MAJfirstcode eq 10) CIP6 = 50.0903.
*add value labels CIP6 50.0903 'Music Performance, General'.

*Philosophy.
if (MAJfirstcode eq 11) CIP6 = 38.0101.
add value labels CIP6 38.0101 'Philosophy'.
if (MAJfirstcode eq 11) CIP4 = 38.01.
add value labels CIP4 38.01 'Philosophy'.

*Religion.
if (MAJfirstcode eq 12) CIP6 = 38.0201.
add value labels CIP6 38.0201 'Religion/Religious Studies'.
if (MAJfirstcode eq 12) CIP4 = 38.02.
add value labels CIP4 38.02 'Religion/Religious Studies'.

*Theater or drama.
if (MAJfirstcode eq 13) CIP6 = 50.0501.
add value labels CIP6 50.0501 'Drama and Dramatics/Theatre Arts, General'.
if (MAJfirstcode eq 13) CIP4 = 50.05.
add value labels CIP4 50.05 'Drama/Theatre Arts and Stagecraft'.
*if (MAJfirstcode eq 13) CIP6 = 50.0506.
*add value labels CIP6 50.0506 'Acting'.
*if (MAJfirstcode eq 13) CIP4 = 50.01.
*add value labels CIP4 50.01 'Visual and Performing Arts, General'.
*if (MAJfirstcode eq 13) CIP6 = 50.0101.
*add value labels CIP6 50.0101 'Visual and Performing Arts, General'.

*Other fine and performing arts.
if (MAJfirstcode eq 14) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 14) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 14) CIP6 = 50.0408.
*add value labels CIP6 50.0408 'Interior Design'.
*if (MAJfirstcode eq 14) CIP4 = 50.04.
*add value labels CIP4 50.04 'Design and Applied Arts'.
*if (MAJfirstcode eq 14) CIP6 = 50.0301.
*add value labels CIP6 50.0301 'Dance, General'.
*if (MAJfirstcode eq 14) CIP4 = 50.03.
*add value labels CIP4 50.03 'Dance'.

*Other humanities.
if (MAJfirstcode eq 15) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 15) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 15) CIP6 = 5.0102.
*add value labels CIP6 5.0102 'American/United States Studies/Civilization'.
*if (MAJfirstcode eq 15) CIP4 = 5.01.
*add value labels CIP4 5.01 'Area Studies'.
*if (MAJfirstcode eq 15) CIP6 = 5.0103.
*add value labels CIP6 5.0103 'Asian Studies/Civilization'.


*********************Biological Sciences, Agriculture, & Natural Resources.

*Biology (general).
if (MAJfirstcode eq 16) CIP6 = 26.0101.
add value labels CIP6 26.0101 'Biology/Biological Sciences, General'.
if (MAJfirstcode eq 16) CIP4 = 26.01.
add value labels CIP4 26.01 'Biology, General'.

*Agriculture.
if (MAJfirstcode eq 17) CIP6 = 1.
add value labels CIP6 1 'Agriculture, General'.
if (MAJfirstcode eq 17) CIP4 = 1.
add value labels CIP4 1 'Agriculture, General'.

*Biochemistry or biophysics.
if (MAJfirstcode eq 18) CIP6 = 26.0202.
add value labels CIP6 26.0202 'Biochemistry'.
if (MAJfirstcode eq 18) CIP4 = 26.02.
add value labels CIP4 26.02 'Biochemistry, Biophysics and Molecular Biology'.
*if (MAJfirstcode eq 18) CIP6 = 26.0203.
*add value labels CIP6 26.0203 'Biophysics'.

*Biomedical science.
if (MAJfirstcode eq 19) CIP6 = 26.0102.
add value labels CIP6 26.0102 'Biomedical Sciences, General'.
if (MAJfirstcode eq 19) CIP4 = 26.01.
add value labels CIP4 26.01 'Biology, General'.

*Botany.
if (MAJfirstcode eq 20) CIP6 = 26.0301.
add value labels CIP6 26.0301 'Botany/Plant Biology'.
if (MAJfirstcode eq 20) CIP4 = 26.03.
add value labels CIP4 26.03 'Botany/Plant Biology'.

*Cell and molecular biology.
if (MAJfirstcode eq 21) CIP6 = 26.0401.
add value labels CIP6 26.0401 'Cell/Cellular Biology and Histology'.
if (MAJfirstcode eq 21) CIP4 = 26.04.
add value labels CIP4 26.04 'Cell/Cellular Biology and Anatomical Sciences'.

*Environmental science/studies.
if (MAJfirstcode eq 22) CIP6 = 3.0103.
add value labels CIP6 3.0103 'Environmental Studies'.
if (MAJfirstcode eq 22) CIP4 = 3.01.
add value labels CIP4 3.01 'Natural Resources Conservation and Research'.
*if (MAJfirstcode eq 22) CIP6 = 3.0104.
*add value labels CIP6 3.0104 'Environmental Science'.

*Marine science.
if (MAJfirstcode eq 23) CIP6 = 30.3201.
add value labels CIP6 30.3201 'Marine Sciences'.
if (MAJfirstcode eq 23) CIP4 = 30.32.
add value labels CIP4 30.32 'Marine Sciences'.
*if (MAJfirstcode eq 23) CIP6 = 26.1302.
*add value labels CIP6 26.1302 'Marine Biology and Biological Oceanography'.
*if (MAJfirstcode eq 23) CIP4 = 26.13.
*add value labels CIP4 26.13 'Ecology, Evolution, Systematics, and Population Biology'.

*Microbiology or bacteriology.
if (MAJfirstcode eq 24) CIP6 = 26.0502.
add value labels CIP6 26.0502 'Microbiology, General'.
if (MAJfirstcode eq 24) CIP4 = 26.05.
add value labels CIP4 26.05 'Microbiological Sciences and Immunology'.
*if (MAJfirstcode eq 24) CIP6 = 26.0503.
*add value labels CIP6 26.0503 'Medical Microbiology and Bacteriology'.

*Natural resources and conservation.
if (MAJfirstcode eq 25) CIP6 = 3.0101.
add value labels CIP6 3.0101 'Natural Resources/Conservation, General'.
if (MAJfirstcode eq 25) CIP4 = 3.01.
add value labels CIP4 3.01 'Natural Resources Conservation and Research'.
*if (MAJfirstcode eq 25) CIP6 = 3.0601.
*add value labels CIP6 3.0601 'Wildlife, Fish and Wildlands Science and Management'.
*if (MAJfirstcode eq 25) CIP4 = 3.06.
*add value labels CIP4 3.06 'Wildlife and Wildlands Science and Management'.
*if (MAJfirstcode eq 25) CIP6 = 3.0501.
*add value labels CIP6 3.0501 'Forestry, General'.
*if (MAJfirstcode eq 25) CIP4 = 3.05.
*add value labels CIP4 3.05 'Forestry'.

*Natural science.
if (MAJfirstcode eq 26) CIP6 = 30.1801.
add value labels CIP6 30.1801 'Natural Sciences'.
if (MAJfirstcode eq 26) CIP4 = 30.18.
add value labels CIP4 30.18 'Natural Sciences'.

*Neuroscience.
if (MAJfirstcode eq 27) CIP6 = 26.1501.
add value labels CIP6 26.1501 'Neuroscience'.
if (MAJfirstcode eq 27) CIP4 = 26.15.
add value labels CIP4 26.15 'Neurobiology and Neurosciences'.

*Physiology and developmental biology.
if (MAJfirstcode eq 28) CIP6 = 26.0901.
add value labels CIP6 26.0901 'Physiology, General'.
if (MAJfirstcode eq 28) CIP4 = 26.09.
add value labels CIP4 26.09 'Physiology, Pathology and Related Sciences'.

*Zoology.
if (MAJfirstcode eq 29) CIP6 = 26.0701.
add value labels CIP6 26.0701 'Zoology/Animal Biology'.
if (MAJfirstcode eq 29) CIP4 = 26.07.
add value labels CIP4 26.07 'Zoology/Animal Biology'.

*Other agriculture and natural resources.
if (MAJfirstcode eq 30) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 30) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 30) CIP6 = 1.0102.
*add value labels CIP6 1.0102 'Agribusiness/Agricultural Business Operations'.
*if (MAJfirstcode eq 30) CIP4 = 1.01.
*add value labels CIP4 1.01 'Agricultural Business and Management'.
*if (MAJfirstcode eq 30) CIP6 = 1.0601.
*add value labels CIP6 1.0601 'Applied Horticulture/Horticulture Operations, General'.
*if (MAJfirstcode eq 30) CIP4 = 1.06.
*add value labels CIP4 1.06 'Applied Horticulture and Horticultural Business Services'.

*Other biological sciences.
if (MAJfirstcode eq 31) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 31) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 31) CIP6 = 26.1301.
*add value labels CIP6 26.1301 'Ecology'.
*if (MAJfirstcode eq 31) CIP4 = 26.13.
*add value labels CIP4 26.13 'Ecology, Evolution, Systematics, and Population Biology'.
*if (MAJfirstcode eq 31) CIP6 = 26.1201.
*add value labels CIP6 26.1201 'Biotechnology'.
*if (MAJfirstcode eq 31) CIP4 = 26.12.
*add value labels CIP4 26.12 'Biotechnology'.


*********************Physical Sciences, Mathematics, & Computer Science.

*Physical sciences (general).
if (MAJfirstcode eq 32) CIP6 = 40.0101.
add value labels CIP6 40.0101 'Physical Sciences'.
if (MAJfirstcode eq 32) CIP4 = 40.01.
add value labels CIP4 40.01 'Physical Sciences'.

*Astronomy.
if (MAJfirstcode eq 33) CIP6 = 40.0201.
add value labels CIP6 40.0201 'Astronomy'.
if (MAJfirstcode eq 33) CIP4 = 40.02.
add value labels CIP4 40.02 'Astronomy and Astrophysics'.

*Atmospheric science (including meteorology).
if (MAJfirstcode eq 34) CIP6 = 40.0401.
add value labels CIP6 40.0401 'Atmospheric Sciences and Meteorology, General'.
if (MAJfirstcode eq 34) CIP4 = 40.04.
add value labels CIP4 40.04 'Atmospheric Sciences and Meteorology'.

*Chemistry.
if (MAJfirstcode eq 35) CIP6 = 40.0501.
add value labels CIP6 40.0501 'Chemistry, General'.
if (MAJfirstcode eq 35) CIP4 = 40.05.
add value labels CIP4 40.05 'Chemistry'.

*Computer science.
if (MAJfirstcode eq 36) CIP6 = 11.0701.
add value labels CIP6 11.0701 'Computer Science'.
if (MAJfirstcode eq 36) CIP4 = 11.07.
add value labels CIP4 11.07 'Computer Science'.

*Earth science (including geology).
if (MAJfirstcode eq 37) CIP6 = 40.0601.
add value labels CIP6 40.0601 'Geology/Earth Science, General'.
if (MAJfirstcode eq 37) CIP4 = 40.06.
add value labels CIP4 40.06 'Geological and Earth Sciences/Geosciences'.

*Mathematics.
if (MAJfirstcode eq 38) CIP6 = 27.0101.
add value labels CIP6 27.0101 'Mathematics, General'.
if (MAJfirstcode eq 38) CIP4 = 27.01.
add value labels CIP4 27.01 'Mathematics'.

*Physics.
if (MAJfirstcode eq 39) CIP6 = 40.0801.
add value labels CIP6 40.0801 'Physics, General'.
if (MAJfirstcode eq 39) CIP4 = 40.08.
add value labels CIP4 40.08 'Physics'.

*Statistics.
if (MAJfirstcode eq 40) CIP6 = 27.0501.
add value labels CIP6 27.0501 'Statistics, General'.
if (MAJfirstcode eq 40) CIP4 = 27.05.
add value labels CIP4 27.05 'Statistics'.

*Other physical sciences.
if (MAJfirstcode eq 41) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 41) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 41) CIP6 = 40.0202.
*add value labels CIP6 40.0202 'Astrophysics'.
*if (MAJfirstcode eq 41) CIP4 = 40.02.
*add value labels CIP4 40.02 'Astronomy and Astrophysics'.
*if (MAJfirstcode eq 41) CIP6 = 40.1001.
*add value labels CIP6 40.1001 'Materials Science'.
*if (MAJfirstcode eq 41) CIP4 = 40.1.
*add value labels CIP4 40.1 'Materials Sciences'.


*********************Social Sciences.

*Social sciences (general).
if (MAJfirstcode eq 42) CIP6 = 45.0101.
add value labels CIP6 45.0101 'Social Sciences, General'.
if (MAJfirstcode eq 42) CIP4 = 45.01.
add value labels CIP4 45.01 'Social Sciences, General'.

*Anthropology.
if (MAJfirstcode eq 43) CIP6 = 45.0201.
add value labels CIP6 45.0201 'Anthropology'.
if (MAJfirstcode eq 43) CIP4 = 45.02.
add value labels CIP4 45.02 'Anthropology'.

*Economics.
if (MAJfirstcode eq 44) CIP6 = 45.0601.
add value labels CIP6 45.0601 'Economics, General'.
if (MAJfirstcode eq 44) CIP4 = 45.06.
add value labels CIP4 45.06 'Economics'.

*Ethnic studies.
if (MAJfirstcode eq 45) CIP6 = 5.02.
add value labels CIP6 5.02 'Ethnic Studies'.
if (MAJfirstcode eq 45) CIP4 = 5.02.
add value labels CIP4 5.02 'Ethnic, Cultural Minority, Gender, and Group Studies'.

*Gender studies.
if (MAJfirstcode eq 46) CIP6 = 5.0207.
add value labels CIP6 5.0207 "Women's Studies".
if (MAJfirstcode eq 46) CIP4 = 5.02.
add value labels CIP4 5.02 'Ethnic, Cultural Minority, Gender, and Group Studies'.
*if (MAJfirstcode eq 46) CIP6 = 5.0299.
*add value labels CIP6 5.0299 'Ethnic, Cultural Minority, Gender, and Group Studies, Other'.

*Geography.
if (MAJfirstcode eq 47) CIP6 = 45.0701.
add value labels CIP6 45.0701 'Geography'.
if (MAJfirstcode eq 47) CIP4 = 45.07.
add value labels CIP4 45.07 'Geography and Cartography'.

*International relations.
if (MAJfirstcode eq 48) CIP6 = 45.0901.
add value labels CIP6 45.0901 'International Relations and Affairs'.
if (MAJfirstcode eq 48) CIP4 = 45.09.
add value labels CIP4 45.09 'International Relations and National Security Studies'.

*Political science.
if (MAJfirstcode eq 49) CIP6 = 45.1001.
add value labels CIP6 45.1001 'Political Science and Government, General'.
if (MAJfirstcode eq 49) CIP4 = 45.1.
add value labels CIP4 45.1 'Political Science and Government'.

*Psychology.
if (MAJfirstcode eq 50) CIP6 = 42.0101.
add value labels CIP6 42.0101 'Psychology, General'.
if (MAJfirstcode eq 50) CIP4 = 42.01.
add value labels CIP4 42.01 'Psychology, General'.

*Sociology.
if (MAJfirstcode eq 51) CIP6 = 45.1101.
add value labels CIP6 45.1101 'Sociology'.
if (MAJfirstcode eq 51) CIP4 = 45.11.
add value labels CIP4 45.11 'Sociology'.

*Other social sciences.
if (MAJfirstcode eq 52) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 52) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 52) CIP6 = 30.1701.
*add value labels CIP6 30.1701 'Behavioral Science'.
*if (MAJfirstcode eq 52) CIP4 = 30.17.
*add value labels CIP4 30.17 'Behavioral Sciences'.
*if (MAJfirstcode eq 52) CIP6 = 45.9999.
*add value labels CIP6 45.9999 'Social sciences, other'.
*if (MAJfirstcode eq 52) CIP4 = 45.99.
*add value labels CIP4 45.99 'Social Sciences, Other'.


*********************Business.

*Accounting.
if (MAJfirstcode eq 53) CIP6 = 52.0301.
add value labels CIP6 52.0301 'Accounting'.
if (MAJfirstcode eq 53) CIP4 = 52.03.
add value labels CIP4 52.03 'Accounting and Related Services'.

*Business administration.
if (MAJfirstcode eq 54) CIP6 = 52.0201.
add value labels CIP6 52.0201 'Business Administration and Management, General'.
if (MAJfirstcode eq 54) CIP4 = 52.02.
add value labels CIP4 52.02 'Business Administration, Management and Operations'.
*if (MAJfirstcode eq 54) CIP6 = 52.0101.
*add value labels CIP6 52.0101 'Business/Commerce, General'.
*if (MAJfirstcode eq 54) CIP4 = 52.01.
*add value labels CIP4 52.01 'Business/Commerce, General'.

*Entrepreneurial studies.
if (MAJfirstcode eq 55) CIP6 = 52.0701.
add value labels CIP6 52.0701 'Entrepreneurship/Entrepreneurial Studies'.
if (MAJfirstcode eq 55) CIP4 = 52.07.
add value labels CIP4 52.07 'Entrepreneurial and Small Business Operations'.

*Finance.
if (MAJfirstcode eq 56) CIP6 = 52.0801.
add value labels CIP6 52.0801 'Finance, General'.
if (MAJfirstcode eq 56) CIP4 = 52.08.
add value labels CIP4 52.08 'Finance and Financial Management Services'.

*Hospitality and tourism.
if (MAJfirstcode eq 57) CIP6 = 52.0901.
add value labels CIP6 52.0901 'Hospitality Administration/Management, General'.
if (MAJfirstcode eq 57) CIP4 = 52.09.
add value labels CIP4 52.09 'Hospitality Administration/Management'.

*International business.
if (MAJfirstcode eq 58) CIP6 = 52.1101.
add value labels CIP6 52.1101 'International Business/Trade/Commerce'.
if (MAJfirstcode eq 58) CIP4 = 52.11.
add value labels CIP4 52.11 'International Business'.

*Management.
if (MAJfirstcode eq 59) CIP6 = 52.0205.
add value labels CIP6 52.0205 'Operations Management and Supervision'.
if (MAJfirstcode eq 59) CIP4 = 52.02.
add value labels CIP4 52.02 'Business Administration, Management and Operations'.
*if (MAJfirstcode eq 59) CIP6 = 52.0204.
*add value labels CIP6 52.0204 'Office Management and Supervision'.

*Management information systems.
if (MAJfirstcode eq 60) CIP6 = 52.1201.
add value labels CIP6 52.1201 'Management Information Systems, General'.
if (MAJfirstcode eq 60) CIP4 = 52.12.
add value labels CIP4 52.12 'Management Information Systems and Services'.

*Marketing.
if (MAJfirstcode eq 61) CIP6 = 52.1401.
add value labels CIP6 52.1401 'Marketing/Marketing Management, General'.
if (MAJfirstcode eq 61) CIP4 = 52.14.
add value labels CIP4 52.14 'Marketing'.

*Organizational leadership or behavior.
if (MAJfirstcode eq 62) CIP6 = 52.0213.
add value labels CIP6 52.0213 'Organizational Leadership'.
if (MAJfirstcode eq 62) CIP4 = 52.02.
add value labels CIP4 52.02 'Business Administration, Management and Operations'.

*Supply chain and operations management.
if (MAJfirstcode eq 63) CIP6 = 52.0203.
add value labels CIP6 52.0203 'Logistics, Materials, and Supply Chain Management'.
if (MAJfirstcode eq 63) CIP4 = 52.02.
add value labels CIP4 52.02 'Business Administration, Management and Operations'.
*if (MAJfirstcode eq 63) CIP6 = 52.0205.
*add value labels CIP6 52.0205 'Operations Management and Supervision'.

*Other business.
if (MAJfirstcode eq 64) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 64) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 64) CIP6 = 52.1001.
*add value labels CIP6 52.1001 'Human Resources Management/Personnel Administration, General'.
*if (MAJfirstcode eq 64) CIP4 = 52.1.
*add value labels CIP4 52.1 'Human Resources Management and Services'.
*if (MAJfirstcode eq 64) CIP6 = 52.1902.
*add value labels CIP6 52.1902 'Fashion Merchandising'.
*if (MAJfirstcode eq 64) CIP4 = 52.19.
*add value labels CIP4 52.19 'Specialized Sales, Merchandising and Marketing Operations'.


*********************Communications, Media, & Public Relations.

*Communications (general).
if (MAJfirstcode eq 65) CIP6 = 9.01.
add value labels CIP6 9.01 'Communication, General'.
if (MAJfirstcode eq 65) CIP4 = 9.01.
add value labels CIP4 9.01 'Communication and Media Studies'.

*Broadcast communications.
if (MAJfirstcode eq 66) CIP6 = 9.0701.
add value labels CIP6 9.0701 'Radio and Television'.
if (MAJfirstcode eq 66) CIP4 = 9.07.
add value labels CIP4 9.07 'Radio, Television, and Digital Communication'.
*if (MAJfirstcode eq 66) CIP6 = 9.0402.
*add value labels CIP6 9.0402 'Broadcast Journalism'.
*if (MAJfirstcode eq 66) CIP4 = 9.04.
*add value labels CIP4 9.04 'Journalism'.
*if (MAJfirstcode eq 66) CIP6 = 10.0202.
*add value labels CIP6 10.0202 'Radio and Television Broadcasting Technology/Technician'.
*if (MAJfirstcode eq 66) CIP4 = 10.02.
*add value labels CIP4 10.02 'Audiovisual Communications Technologies/Technicians'.

*Journalism.
if (MAJfirstcode eq 67) CIP6 = 9.0401.
add value labels CIP6 9.0401 'Journalism'.
if (MAJfirstcode eq 67) CIP4 = 9.04.
add value labels CIP4 9.04 'Journalism'.

*Mass communications and media studies.
if (MAJfirstcode eq 68) CIP6 = 9.0102.
add value labels CIP6 9.0102 'Mass Communication/Media Studies'.
if (MAJfirstcode eq 68) CIP4 = 9.01.
add value labels CIP4 9.01 'Communication and Media Studies'.

*Public relations and advertising.
if (MAJfirstcode eq 69) CIP6 = 9.0903.
add value labels CIP6 9.0903 'Advertising'.
if (MAJfirstcode eq 69) CIP4 = 9.09.
add value labels CIP4 9.09 'Public Relations, Advertising, and Applied Communication'.
*if (MAJfirstcode eq 69) CIP6 = 9.0902.
*add value labels CIP6 9.0902 'Public Relations/Image Management'.

*Speech.
if (MAJfirstcode eq 70) CIP6 = 9.0101.
add value labels CIP6 9.0101 'Speech Communication and Rhetoric'.
if (MAJfirstcode eq 70) CIP4 = 9.01.
add value labels CIP4 9.01 'Communication and Media Studies'.

*Telecommunications.
if (MAJfirstcode eq 71) CIP6 = 15.0305.
add value labels CIP6 15.0305 'Telecommunications Technology/Technician'.
if (MAJfirstcode eq 71) CIP4 = 15.03.
add value labels CIP4 15.03 'Electrical Engineering Technologies/Technicians'.

*Other communications.
if (MAJfirstcode eq 72) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 72) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 72) CIP6 = 9.9999.
*add value labels CIP6 9.9999 'Communication, journalism, and related programs, other'.
*if (MAJfirstcode eq 72) CIP4 = 9.99.
*add value labels CIP4 9.99 'Communication, Journalism, and Related Programs, Other'.


*********************Education.

*Education (general).
if (MAJfirstcode eq 73) CIP6 = 13.0101.
add value labels CIP6 13.0101 'Education, General'.
if (MAJfirstcode eq 73) CIP4 = 13.01.
add value labels CIP4 13.01 'Education, General'.

*Business education.
if (MAJfirstcode eq 74) CIP6 = 13.1303.
add value labels CIP6 13.1303 'Business Teacher Education'.
if (MAJfirstcode eq 74) CIP4 = 13.13.
add value labels CIP4 13.13 'Teacher Education and Professional Development, Specific Subject Areas'.

*Early childhood education.
if (MAJfirstcode eq 75) CIP6 = 13.121.
add value labels CIP6 13.121 'Early Childhood Education and Teaching'.
if (MAJfirstcode eq 75) CIP4 = 13.12.
add value labels CIP4 13.12 'Teacher Education and Professional Development, Specific Levels and Methods'.

*Elementary, middle school education.
if (MAJfirstcode eq 76) CIP6 = 13.1202.
add value labels CIP6 13.1202 'Elementary Education and Teaching'.
if (MAJfirstcode eq 76) CIP4 = 13.12.
add value labels CIP4 13.12 'Teacher Education and Professional Development, Specific Levels and Methods'.
*if (MAJfirstcode eq 76) CIP6 = 13.1203.
*add value labels CIP6 13.1203 'Junior High/Intermediate/Middle School Education and Teaching'.

*Mathematics education.
if (MAJfirstcode eq 77) CIP6 = 13.1311.
add value labels CIP6 13.1311 'Mathematics Teacher Education'.
if (MAJfirstcode eq 77) CIP4 = 13.13.
add value labels CIP4 13.13 'Teacher Education and Professional Development, Specific Subject Areas'.

*Music or art education.
if (MAJfirstcode eq 78) CIP6 = 13.1312.
add value labels CIP6 13.1312 'Music Teacher Education'.
if (MAJfirstcode eq 78) CIP4 = 13.13.
add value labels CIP4 13.13 'Teacher Education and Professional Development, Specific Subject Areas'.
*if (MAJfirstcode eq 78) CIP6 = 13.1302.
*add value labels CIP6 13.1302 'Art Teacher Education'.

*Physical education.
if (MAJfirstcode eq 79) CIP6 = 13.1314.
add value labels CIP6 13.1314 'Physical Education Teaching and Coaching'.
if (MAJfirstcode eq 79) CIP4 = 13.13.
add value labels CIP4 13.13 'Teacher Education and Professional Development, Specific Subject Areas'.
*if (MAJfirstcode eq 79) CIP6 = 31.0501.
*add value labels CIP6 31.0501 'Health and Physical Education/Fitness, General'.
*if (MAJfirstcode eq 79) CIP4 = 31.05.
*add value labels CIP4 31.05 'Health and Physical Education/Fitness'.

*Secondary education.
if (MAJfirstcode eq 80) CIP6 = 13.1205.
add value labels CIP6 13.1205 'Secondary Education and Teaching'.
if (MAJfirstcode eq 80) CIP4 = 13.12.
add value labels CIP4 13.12 'Teacher Education and Professional Development, Specific Levels and Methods'.

*Social studies education.
if (MAJfirstcode eq 81) CIP6 = 13.1317.
add value labels CIP6 13.1317 'Social Science Teacher Education'.
if (MAJfirstcode eq 81) CIP4 = 13.13.
add value labels CIP4 13.13 'Teacher Education and Professional Development, Specific Subject Areas'.

*Special education.
if (MAJfirstcode eq 82) CIP6 = 13.1001.
add value labels CIP6 13.1001 'Special Education and Teaching, General'.
if (MAJfirstcode eq 82) CIP4 = 13.1.
add value labels CIP4 13.1 'Special Education and Teaching'.

*Other education.
if (MAJfirstcode eq 83) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 83) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 83) CIP6 = 13.1305.
*add value labels CIP6 13.1305 'English/Language Arts Teacher Education'.
*if (MAJfirstcode eq 83) CIP4 = 13.13.
*add value labels CIP4 13.13 'Teacher Education and Professional Development, Specific Subject Areas'.


*********************Engineering.

*Engineering (general).
if (MAJfirstcode eq 84) CIP6 = 14.0101.
add value labels CIP6 14.0101 'Engineering, General'.
if (MAJfirstcode eq 84) CIP4 = 14.01.
add value labels CIP4 14.01 'Engineering, General'.

*Aero-, astronautical engineering.
if (MAJfirstcode eq 85) CIP6 = 14.0201.
add value labels CIP6 14.0201 'Aerospace, Aeronautical and Astronautical Engineering'.
if (MAJfirstcode eq 85) CIP4 = 14.02.
add value labels CIP4 14.02 'Aerospace, Aeronautical and Astronautical Engineering'.

*Bioengineering.
if (MAJfirstcode eq 86) CIP6 = 14.0501.
add value labels CIP6 14.0501 'Bioengineering and Biomedical Engineering'.
if (MAJfirstcode eq 86) CIP4 = 14.05.
add value labels CIP4 14.05 'Biomedical/Medical Engineering'.

*Biomedical engineering.
if (MAJfirstcode eq 87) CIP6 = 14.0501.
add value labels CIP6 14.0501 'Bioengineering and Biomedical Engineering'.
if (MAJfirstcode eq 87) CIP4 = 14.05.
add value labels CIP4 14.05 'Biomedical/Medical Engineering'.

*Chemical engineering.
if (MAJfirstcode eq 88) CIP6 = 14.0701.
add value labels CIP6 14.0701 'Chemical Engineering'.
if (MAJfirstcode eq 88) CIP4 = 14.07.
add value labels CIP4 14.07 'Chemical Engineering'.

*Civil engineering.
if (MAJfirstcode eq 89) CIP6 = 14.0801.
add value labels CIP6 14.0801 'Civil Engineering, General'.
if (MAJfirstcode eq 89) CIP4 = 14.08.
add value labels CIP4 14.08 'Civil Engineering'.

*Computer engineering and technology.
if (MAJfirstcode eq 90) CIP6 = 14.0901.
add value labels CIP6 14.0901 'Computer Engineering, General'.
if (MAJfirstcode eq 90) CIP4 = 14.09.
add value labels CIP4 14.09 'Computer Engineering'.
*if (MAJfirstcode eq 90) CIP6 = 15.1201.
*add value labels CIP6 15.1201 'Computer Engineering Technology/Technician'.
*if (MAJfirstcode eq 90) CIP4 = 15.12.
*add value labels CIP4 15.12 'Computer Engineering Technologies/Technicians'.

*Electrical or electronic engineering.
if (MAJfirstcode eq 91) CIP6 = 14.1001.
add value labels CIP6 14.1001 'Electrical and Electronics Engineering'.
if (MAJfirstcode eq 91) CIP4 = 14.1.
add value labels CIP4 14.1 'Electrical, Electronics and Communications Engineering'.

*Industrial engineering.
if (MAJfirstcode eq 92) CIP6 = 14.3501.
add value labels CIP6 14.3501 'Industrial Engineering'.
if (MAJfirstcode eq 92) CIP4 = 14.35.
add value labels CIP4 14.35 'Industrial Engineering'.

*Materials engineering.
if (MAJfirstcode eq 93) CIP6 = 14.1801.
add value labels CIP6 14.1801 'Materials Engineering'.
if (MAJfirstcode eq 93) CIP4 = 14.18.
add value labels CIP4 14.18 'Materials Engineering'.

*Mechanical engineering.
if (MAJfirstcode eq 94) CIP6 = 14.1901.
add value labels CIP6 14.1901 'Mechanical Engineering'.
if (MAJfirstcode eq 94) CIP4 = 14.19.
add value labels CIP4 14.19 'Mechanical Engineering'.

*Petroleum engineering.
if (MAJfirstcode eq 95) CIP6 = 14.2501.
add value labels CIP6 14.2501 'Petroleum Engineering'.
if (MAJfirstcode eq 95) CIP4 = 14.25.
add value labels CIP4 14.25 'Petroleum Engineering'.

*Software engineering.
if (MAJfirstcode eq 96) CIP6 = 14.0903.
add value labels CIP6 14.0903 'Computer Software Engineering'.
if (MAJfirstcode eq 96) CIP4 = 14.09.
add value labels CIP4 14.09 'Computer Engineering'.

*Other engineering.
if (MAJfirstcode eq 97) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 97) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 97) CIP6 = 14.0301.
*add value labels CIP6 14.0301 'Agricultural Engineering'.
*if (MAJfirstcode eq 97) CIP4 = 14.03.
*add value labels CIP4 14.03 'Agricultural Engineering'.
*if (MAJfirstcode eq 97) CIP6 = 14.1401.
*add value labels CIP6 14.1401 'Environmental/Environmental Health Engineering'.
*if (MAJfirstcode eq 97) CIP4 = 14.14.
*add value labels CIP4 14.14 'Environmental/Environmental Health Engineering'.


*********************Health Professions.

*Allied health.
if (MAJfirstcode eq 98) CIP6 = 51.
add value labels CIP6 51 'Health Services/Allied Health/Health Sciences, General'.
if (MAJfirstcode eq 98) CIP4 = 51.
add value labels CIP4 51 'Health Services/Allied Health/Health Sciences, General'.

*Dentistry.
if (MAJfirstcode eq 99) CIP6 = 51.1101.
add value labels CIP6 51.1101 'Pre-Dentistry Studies'.
if (MAJfirstcode eq 99) CIP4 = 51.11.
add value labels CIP4 51.11 'Health/Medical Preparatory Programs'.

*Health science.
if (MAJfirstcode eq 100) CIP6 = 51.
add value labels CIP6 51 'Health Services/Allied Health/Health Sciences, General'.
if (MAJfirstcode eq 100) CIP4 = 51.
add value labels CIP4 51 'Health Services/Allied Health/Health Sciences, General'.

*Health technology (medical, dental, laboratory).
if (MAJfirstcode eq 101) CIP6 = 51.1005.
add value labels CIP6 51.1005 'Clinical Laboratory Science/Medical Technology/Technologist'.
if (MAJfirstcode eq 101) CIP4 = 51.1.
add value labels CIP4 51.1 'Clinical/Medical Laboratory Science/Research and Allied Professions'.

*Healthcare administration and policy.
if (MAJfirstcode eq 102) CIP6 = 51.0701.
add value labels CIP6 51.0701 'Health/Health Care Administration/Management'.
if (MAJfirstcode eq 102) CIP4 = 51.07.
add value labels CIP4 51.07 'Health and Medical Administrative Services'.
*if (MAJfirstcode eq 102) CIP6 = 51.0702.
*add value labels CIP6 51.0702 'Hospital and Health Care Facilities Administration/Management'.
*if (MAJfirstcode eq 102) CIP6 = 51.0706.
*add value labels CIP6 51.0706 'Health Information/Medical Records Administration/Administrator'.

*Kinesiology.
if (MAJfirstcode eq 103) CIP6 = 31.0505.
add value labels CIP6 31.0505 'Kinesiology and Exercise Science'.
if (MAJfirstcode eq 103) CIP4 = 31.05.
add value labels CIP4 31.05 'Health and Physical Education/Fitness'.
*if (MAJfirstcode eq 103) CIP6 = 26.0908.
*add value labels CIP6 26.0908 'Exercise Physiology'.
*if (MAJfirstcode eq 103) CIP4 = 26.09.
*add value labels CIP4 26.09 'Physiology, Pathology and Related Sciences'.

*Medicine.
if (MAJfirstcode eq 104) CIP6 = 51.1102.
add value labels CIP6 51.1102 'Pre-Medicine/Pre-Medical Studies'.
if (MAJfirstcode eq 104) CIP4 = 51.11.
add value labels CIP4 51.11 'Health/Medical Preparatory Programs'.

*Nursing.
if (MAJfirstcode eq 105) CIP6 = 51.3801.
add value labels CIP6 51.3801 'Registered nursing/registered nurse'.
if (MAJfirstcode eq 105) CIP4 = 51.38.
add value labels CIP4 51.38 'Registered Nursing, Nursing Administration, Nursing Research and Clinical Nursing'.
*if (MAJfirstcode eq 105) CIP6 = 51.3808.
*add value labels CIP6 51.3808 'Nursing Science'.

*Nutrition and dietetics.
if (MAJfirstcode eq 106) CIP6 = 51.3101.
add value labels CIP6 51.3101 'Dietetics/Dietitian'.
if (MAJfirstcode eq 106) CIP4 = 51.31.
add value labels CIP4 51.31 'Dietetics and Clinical Nutrition Services'.
*if (MAJfirstcode eq 106) CIP6 = 19.0501.
*add value labels CIP6 19.0501 'Foods, nutrition, and wellness studies, general'.
*if (MAJfirstcode eq 106) CIP4 = 19.05.
*add value labels CIP4 19.05 'Foods, Nutrition, and Related Services'.
*if (MAJfirstcode eq 106) CIP6 = 30.1901.
*add value labels CIP6 30.1901 'Nutrition sciences'.
*if (MAJfirstcode eq 106) CIP4 = 30.19.
*add value labels CIP4 30.19 'Nutrition Sciences'.

*Occupational safety and health.
if (MAJfirstcode eq 107) CIP6 = 15.0701.
add value labels CIP6 15.0701 'Occupational safety and health technology/technician'.
if (MAJfirstcode eq 107) CIP4 = 15.07.
add value labels CIP4 15.07 'Quality Control and Safety Technologies/Technicians'.

*Occupational therapy.
if (MAJfirstcode eq 108) CIP6 = 51.2306.
add value labels CIP6 51.2306 'Occupational Therapy/Therapist'.
if (MAJfirstcode eq 108) CIP4 = 51.23.
add value labels CIP4 51.23 'Rehabilitation and Therapeutic Professions'.
*if (MAJfirstcode eq 108) CIP6 = 51.1107.
*add value labels CIP6 51.1107 'Pre-Occupational Therapy Studies'.
*if (MAJfirstcode eq 108) CIP4 = 51.11.
*add value labels CIP4 51.11 'Health/Medical Preparatory Programs'.

*Pharmacy.
if (MAJfirstcode eq 109) CIP6 = 51.2001.
add value labels CIP6 51.2001 'Pharmacy'.
if (MAJfirstcode eq 109) CIP4 = 51.2.
add value labels CIP4 51.2 'Pharmacy, Pharmaceutical Sciences, and Administration'.
*if (MAJfirstcode eq 109) CIP6 = 51.201.
*add value labels CIP6 51.201 'Pharmaceutical Sciences'.
*if (MAJfirstcode eq 109) CIP4 = 51.11.
*add value labels CIP4 51.11 'Health/Medical Preparatory Programs'.
*if (MAJfirstcode eq 109) CIP6 = 51.1103.
*add value labels CIP6 51.1103 'Pre-Pharmacy Studies'.

*Physical therapy.
if (MAJfirstcode eq 110) CIP6 = 51.2308.
add value labels CIP6 51.2308 'Physical Therapy/Therapist'.
if (MAJfirstcode eq 110) CIP4 = 51.23.
add value labels CIP4 51.23 'Rehabilitation and Therapeutic Professions'.
*if (MAJfirstcode eq 110) CIP6 = 51.1109.
*add value labels CIP6 51.1109 'Pre-Physical Therapy Studies'.
*if (MAJfirstcode eq 110) CIP4 = 51.11.
*add value labels CIP4 51.11 'Health/Medical Preparatory Programs'.

*Rehabilitation sciences.
if (MAJfirstcode eq 111) CIP6 = 51.2314.
add value labels CIP6 51.2314 'Rehabilitation Science'.
if (MAJfirstcode eq 111) CIP4 = 51.23.
add value labels CIP4 51.23 'Rehabilitation and Therapeutic Professions'.

*Speech therapy.
if (MAJfirstcode eq 112) CIP6 = 51.0204.
add value labels CIP6 51.0204 'Audiology/Audiologist and Speech-Language Pathology/Pathologist'.
if (MAJfirstcode eq 112) CIP4 = 51.02.
add value labels CIP4 51.02 'Communication Disorders Sciences and Services'.
*if (MAJfirstcode eq 112) CIP6 = 51.0201.
*add value labels CIP6 51.0201 'Communication Sciences and Disorders, General'.

*Veterinary science.
if (MAJfirstcode eq 113) CIP6 = 51.2501.
add value labels CIP6 51.2501 'Veterinary Sciences/Veterinary Clinical Sciences, General'.
if (MAJfirstcode eq 113) CIP4 = 51.25.
add value labels CIP4 51.25 'Veterinary Biomedical and Clinical Sciences'.
*if (MAJfirstcode eq 113) CIP6 = 1.0901.
*add value labels CIP6 1.0901 'Animal Sciences, General'.
*if (MAJfirstcode eq 113) CIP4 = 1.09.
*add value labels CIP4 1.09 'Animal Sciences'.
*if (MAJfirstcode eq 113) CIP6 = 51.1104.
*add value labels CIP6 51.1104 'Pre-Veterinary Studies'.
*if (MAJfirstcode eq 113) CIP4 = 51.11.
*add value labels CIP4 51.11 'Health/Medical Preparatory Programs'.

*Other health professions.
if (MAJfirstcode eq 114) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 114) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 114) CIP6 = 51.2201.
*add value labels CIP6 51.2201 'Public Health, General'.
*if (MAJfirstcode eq 114) CIP4 = 51.22.
*add value labels CIP4 51.22 'Public Health'.
*if (MAJfirstcode eq 114) CIP6 = 51.1504.
*add value labels CIP6 51.1504 'Community Health Services/Liaison/Counseling'.
*if (MAJfirstcode eq 114) CIP4 = 51.15.
*add value labels CIP4 51.15 'Mental and Social Health Services and Allied Professions'.


*********************Social Service Professions.

*Criminal justice.
if (MAJfirstcode eq 115) CIP6 = 43.0104.
add value labels CIP6 43.0104 'Criminal Justice/Safety Studies'.
if (MAJfirstcode eq 115) CIP4 = 43.01.
add value labels CIP4 43.01 'Criminal Justice and Corrections'.
*if (MAJfirstcode eq 115) CIP6 = 43.0107.
*add value labels CIP6 43.0107 'Criminal Justice/Police Science'.

*Criminology.
if (MAJfirstcode eq 116) CIP6 = 45.0401.
add value labels CIP6 45.0401 'Criminology'.
if (MAJfirstcode eq 116) CIP4 = 45.04.
add value labels CIP4 45.04 'Criminology'.

*Forensics.
if (MAJfirstcode eq 117) CIP6 = 43.0106.
add value labels CIP6 43.0106 'Forensic Science and Technology'.
if (MAJfirstcode eq 117) CIP4 = 43.01.
add value labels CIP4 43.01 'Criminal Justice and Corrections'.

*Justice administration.
if (MAJfirstcode eq 118) CIP6 = 43.0103.
add value labels CIP6 43.0103 'Criminal Justice/Law Enforcement Administration'.
if (MAJfirstcode eq 118) CIP4 = 43.01.
add value labels CIP4 43.01 'Criminal Justice and Corrections'.
*if (MAJfirstcode eq 118) CIP6 = 43.0112.
*add value labels CIP6 43.0112 'Securities Services Administration/Management'.

*Law.
if (MAJfirstcode eq 119) CIP6 = 22.
add value labels CIP6 22 'Legal Studies, General'.
if (MAJfirstcode eq 119) CIP4 = 22.
add value labels CIP4 22 'Non-Professional General Legal Studies (Undergraduate)'.
*if (MAJfirstcode eq 119) CIP6 = 22.0001.
*add value labels CIP6 22.0001 'Pre-Law Studies'.

*Military science.
if (MAJfirstcode eq 120) CIP6 = 29.0399.
add value labels CIP6 29.0399 'Military Applied Science, Other'.
if (MAJfirstcode eq 120) CIP4 = 29.03.
add value labels CIP4 29.03 'Military Technologies'.
*if (MAJfirstcode eq 120) CIP6 = 29.9999.
*add value labels CIP6 29.9999 'Military Technologies and Applied Sciences, Other'.
*if (MAJfirstcode eq 120) CIP4 = 29.99.
*add value labels CIP4 29.99 'Military Technologies and Applied Sciences, Other'.

*Public administration, policy.
if (MAJfirstcode eq 121) CIP6 = 44.0401.
add value labels CIP6 44.0401 'Public Administration'.
if (MAJfirstcode eq 121) CIP4 = 44.04.
add value labels CIP4 44.04 'Public Administration'.
*if (MAJfirstcode eq 121) CIP6 = 44.0501.
*add value labels CIP6 44.0501 'Public Policy Analysis, General'.
*if (MAJfirstcode eq 121) CIP4 = 44.05.
*add value labels CIP4 44.05 'Public Policy Analysis'.

*Public safety and emergency management.
if (MAJfirstcode eq 122) CIP6 = 43.0302.
add value labels CIP6 43.0302 'Crisis/Emergency/Disaster Management'.
if (MAJfirstcode eq 122) CIP4 = 43.03.
add value labels CIP4 43.03 'Homeland Security'.
*if (MAJfirstcode eq 122) CIP6 = 43.0203.
*add value labels CIP6 43.0203 'Fire Science/Fire-fighting'.
*if (MAJfirstcode eq 122) CIP4 = 43.02.
*add value labels CIP4 43.02 'Fire Protection'.
*if (MAJfirstcode eq 122) CIP6 = 43.0301.
*add value labels CIP6 43.0301 'Homeland Security'.

*Social work.
if (MAJfirstcode eq 123) CIP6 = 44.0701.
add value labels CIP6 44.0701 'Social Work'.
if (MAJfirstcode eq 123) CIP4 = 44.07.
add value labels CIP4 44.07 'Social Work'.

*Urban planning.
if (MAJfirstcode eq 124) CIP6 = 4.0301.
add value labels CIP6 4.0301 'City/Urban, Community and Regional Planning'.
if (MAJfirstcode eq 124) CIP4 = 4.03.
add value labels CIP4 4.03 'City/Urban, Community and Regional Planning'.


*********************All Other.

*Computer information systems.
if (MAJfirstcode eq 125) CIP6 = 11.0501.
add value labels CIP6 11.0501 'Computer Systems Analysis/Analyst'.
if (MAJfirstcode eq 125) CIP4 = 11.05.
add value labels CIP4 11.05 'Computer Systems Analysis'.

*Family and consumer studies.
if (MAJfirstcode eq 126) CIP6 = 19.0701.
add value labels CIP6 19.0701 'Human Development and Family Studies, General'.
if (MAJfirstcode eq 126) CIP4 = 19.07.
add value labels CIP4 19.07 'Human Development, Family Studies, and Related Services'.
*if (MAJfirstcode eq 126) CIP6 = 19.0101.
*add value labels CIP6 19.0101 'Family and Consumer Sciences/Human Sciences, General'.
*if (MAJfirstcode eq 126) CIP4 = 19.01.
*add value labels CIP4 19.01 'Family and Consumer Sciences/Human Sciences, General'.

*General studies.
if (MAJfirstcode eq 127) CIP6 = 24.0102.
add value labels CIP6 24.0102 'General Studies'.
if (MAJfirstcode eq 127) CIP4 = 24.01.
add value labels CIP4 24.01 'Liberal Arts and Sciences, General Studies and Humanities'.

*Information systems.
if (MAJfirstcode eq 128) CIP6 = 11.0401.
add value labels CIP6 11.0401 'Information Science/Studies'.
if (MAJfirstcode eq 128) CIP4 = 11.04.
add value labels CIP4 11.04 'Information Science/Studies'.
*if (MAJfirstcode eq 128) CIP6 = 11.0901.
*add value labels CIP6 11.0901 'Computer Systems Networking and Telecommunications'.
*if (MAJfirstcode eq 128) CIP4 = 11.09.
*add value labels CIP4 11.09 'Computer Systems Networking and Telecommunications'.

*Information technology.
if (MAJfirstcode eq 129) CIP6 = 11.0103.
add value labels CIP6 11.0103 'Information Technology'.
if (MAJfirstcode eq 129) CIP4 = 11.01.
add value labels CIP4 11.01 'Computer and Information Sciences, General'.

*Liberal arts and sciences.
if (MAJfirstcode eq 130) CIP6 = 24.0101.
add value labels CIP6 24.0101 'Liberal Arts and Sciences/Liberal Studies'.
if (MAJfirstcode eq 130) CIP4 = 24.01.
add value labels CIP4 24.01 'Liberal Arts and Sciences, General Studies and Humanities'.

*Multi, Interdisciplinary studies.
if (MAJfirstcode eq 131) CIP6 = 30.
add value labels CIP6 30 'Multi-/InterdisCIP6linary Studies, General'.
if (MAJfirstcode eq 131) CIP4 = 30.
add value labels CIP4 30 'Multi-/Interdisciplinary Studies, General'.

*Network security and systems.
if (MAJfirstcode eq 132) CIP6 = 11.1003.
add value labels CIP6 11.1003 'Computer and Information Systems Security/Information Assurance'.
if (MAJfirstcode eq 132) CIP4 = 11.1.
add value labels CIP4 11.1 'Computer/Information Technology Administration and Management'.

*Other computer science and technology.
if (MAJfirstcode eq 133) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 133) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 133) CIP6 = 11.0201.
*add value labels CIP6 11.0201 'Computer Programming/Programmer, General'.
*if (MAJfirstcode eq 133) CIP4 = 11.02.
*add value labels CIP4 11.02 'Computer Programming'.
*if (MAJfirstcode eq 133) CIP6 = 50.0411.
*add value labels CIP6 50.0411 'Game and Interactive Media Design'.
*if (MAJfirstcode eq 133) CIP4 = 50.04.
*add value labels CIP4 50.04 'Design and Applied Arts'.

*Parks, recreation, leisure studies, sports mgmt..
if (MAJfirstcode eq 134) CIP6 = 31.0504.
add value labels CIP6 31.0504 'Sport and Fitness Administration/Management'.
if (MAJfirstcode eq 134) CIP4 = 31.05.
add value labels CIP4 31.05 'Health and Physical Education/Fitness'.
*if (MAJfirstcode eq 134) CIP6 = 31.0301.
*add value labels CIP6 31.0301 'Parks, Recreation and Leisure Facilities Management, General'.
*if (MAJfirstcode eq 134) CIP4 = 31.03.
*add value labels CIP4 31.03 'Parks, Recreation and Leisure Facilities Management'.
*if (MAJfirstcode eq 134) CIP6 = 31.0101.
*add value labels CIP6 31.0101 'Parks, Recreation and Leisure Studies '.
*if (MAJfirstcode eq 134) CIP4 = 31.01.
*add value labels CIP4 31.01 'Parks, Recreation and Leisure Studies'.

*Professional studies (general).
if (MAJfirstcode eq 135) CIP6 = 44.
add value labels CIP6 44 'Human Services, General'.
if (MAJfirstcode eq 135) CIP4 = 44.
add value labels CIP4 44 'Human Services, General'.

*Technical, vocational studies.
if (MAJfirstcode eq 136) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 136) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 136) CIP6 = 15.0803.
*add value labels CIP6 15.0803 'Automotive Engineering Technology/Technician'.
*if (MAJfirstcode eq 136) CIP4 = 15.08.
*add value labels CIP4 15.08 'Mechanical Engineering Related Technologies/Technicians'.

*Theological studies, ministry.
if (MAJfirstcode eq 137) CIP6 = 39.0601.
add value labels CIP6 39.0601 'Theology/Theological Studies'.
if (MAJfirstcode eq 137) CIP4 = 39.06.
add value labels CIP4 39.06 'Theological and Ministerial Studies'.
*if (MAJfirstcode eq 137) CIP6 = 39.0201.
*add value labels CIP6 39.0201 'Bible/Biblical Studies'.
*if (MAJfirstcode eq 137) CIP4 = 39.02.
*add value labels CIP4 39.02 'Bible/Biblical Studies'.

*Other, not listed.
if (MAJfirstcode eq 138) CIP6 = 88.9999.
add value labels CIP6 88.9999 'Inadequate Match'.
if (MAJfirstcode eq 138) CIP4 = 88.99.
add value labels CIP4 88.99 'Inadequate Match'.
*if (MAJfirstcode eq 138) CIP6 = 49.0101.
*add value labels CIP6 49.0101 'Aeronautics/Aviation/Aerospace Science and Technology, General'.
*if (MAJfirstcode eq 138) CIP4 = 49.01.
*add value labels CIP4 49.01 'Air Transportation'.
*if (MAJfirstcode eq 138) CIP6 = 12.0504.
*add value labels CIP6 12.0504 'Restaurant, Culinary, and Catering Management/Manager'.
*if (MAJfirstcode eq 138) CIP4 = 12.05.
*add value labels CIP4 12.05 'Culinary Arts and Related Services'.


*********************Undecided, undeclared.

*Undecided, undeclared.
if (MAJfirstcode eq 999) CIP6 = 89.9999.
add value labels CIP6 89.9999 'Undecided, Undeclared'.
if (MAJfirstcode eq 999) CIP4 = 89.99.
add value labels CIP4 89.99 'Undecided, Undeclared'.


frequencies CIP6 CIP4.




Engagement by Student Characteristics

Basic approaches to exploring topical areas of engagement by student characteristics.

The SPSS syntax below presents the percentage of students who frequently (very often or often) engaged with faculty in various types of activities arrayed by institution-provided sex and class level. The syntax can be run from a NSSE institutional data file.


*********************************************************.
NSSE SAMPLE ANALYSES AND SYNTAX
--FACULTY ENGAGEMENT BY GENDER AND CLASS LEVEL.
*********************************************************.

*********************************************************.
****RECODE INTO 'FREQUENTLY' EXPERIENCED .

RECODE SFcareer SFotherwork SFdiscuss SFperform (1, 2 = 0) (3, 4 = 1)
INTO fSFcareer fSFotherwork fSFdiscuss fSFperform.

VALUE LABELS fSFcareer fSFotherwork fSFdiscuss fSFperform 0 'Infrequently' 1 'Frequently'.

VARIABLE LEVEL fSFcareer fSFotherwork fSFdiscuss fSFperform (ordinal).

FREQUENCIES fSFcareer fSFotherwork fSFdiscuss fSFperform.



****CREATE TABLE USING CTABLES COMMAND.
****.
****NOTE: If using NSSE 2013 data replace 'IRsex' with 'IRgender'.
****.

CTABLES
/VLABELS VARIABLES=fSFcareer fSFotherwork fSFdiscuss fSFperform IRclass IRsex DISPLAY=DEFAULT
/TABLE (fSFcareer + fSFotherwork + fSFdiscuss + fSFperform) [COUNT COLPCT F4.0] BY IRclass > IRsex
/CATEGORIES VARIABLES = fSFcareer fSFotherwork fSFdiscuss fSFperform IRsex ORDER=A KEY=VALUE
EMPTY=INCLUDE
/CATEGORIES VARIABLES = IRclass [1, 4] EMPTY=INCLUDE.


****CREATE PERCENTAGES USING FREQUENCIES COMMAND.
****VALID PERCENT MATCHES CTABLE

**FIRST-YEAR FEMALE.
TEMPORARY.
SELECT IF (IRclass eq 1 and IRsex eq 0).
FREQUENCIES fSFcareer fSFotherwork fSFdiscuss fSFperform.

**FIRST-YEAR MALE.
TEMPORARY.
SELECT IF (IRclass eq 1 and IRsex eq 1).
FREQUENCIES fSFcareer fSFotherwork fSFdiscuss fSFperform.

**SENIOR FEMALE.
TEMPORARY.
SELECT IF (IRclass eq 4 and IRsex eq 0).
FREQUENCIES fSFcareer fSFotherwork fSFdiscuss fSFperform.

**SENIOR MALE.
TEMPORARY.
SELECT IF (IRclass eq 4 and IRsex eq 1).
FREQUENCIES fSFcareer fSFotherwork fSFdiscuss fSFperform.

To estimate the number of pages of assigned writing, the average number of writing assignments of a given page-length was multiplied by an approximate number of pages for the assignment type.

*********************************************************.
WRITING BY MAJOR FIELD CATEGORY.
*********************************************************.

***** ESTIMATED PAGES OF ASSIGNED WRITING.

RECODE wrshort (1=0) (2=4.5) (3=12) (4=24) (5=39) (6=54) (7=69) INTO wr1.
RECODE wrmed (1=0) (2=12) (3=32) (4=64) (5=104) (6=144) (7=184) INTO wr2.
RECODE wrlong (1=0) (2=22.5) (3=60) (4=120) (5=195) (6=270) (7=345) INTO wr3.
EXECUTE.

COMPUTE wrpages=wr1+wr2+wr3.
VARIABLE LEVEL wrpages (SCALE).
VARIABLE LABELS wrpages 'Estimated pages of assigned writing'.
EXECUTE.
DELETE VARIABLES wr1 wr2 wr3.

*****CREATE TABLES BY MAJOR FIELD CATEGORY.
CTABLES
/VLABELS VARIABLES=MAJfirstcol IRclass wrpages DISPLAY=DEFAULT
/TABLE MAJfirstcol [C] BY IRclass [C] > wrpages [S][COUNT MEAN]
/CATEGORIES VARIABLES=MAJfirstcol ORDER=A KEY=VALUE EMPTY=INCLUDE
/CATEGORIES VARIABLES=IRclass [1, 4] EMPTY=INCLUDE.


*********************************************************.
HIGH-IMPACT PRACTICES BY STUDENT CHARACTERISTICS
This syntax will recreate the Percent Participation in High-Impact Practices by Student
Characteristics table in the High-Impact Practices report.
*********************************************************.

*********************************************************.
***** RECODE AND FLAG PARTICIPATION IN HIGH-IMPACT PRACTICES.

RECODE intern leader learncom abroad research capstone (1, 2, 3 = 0) (4 = 1) INTO
internR leaderR learncomR abroadR researchR capstoneR.
VALUE LABELS internR leaderR learncomR abroadR researchR capstoneR 0 'Not Done' 1 'Done or in progress'.
RECODE servcourse (4, 3, 2=1) (1=0) INTO servcourseR.
VALUE LABELS servcourseR 0 'None' 1 'At least some'.
EXECUTE.

*********************************************************.
***** RECODE AGE INTO TRADITIONAL AGE AND NOT TRADITIONAL AGE.
NUMERIC dAge (F4.0).
VARIABLE LABELS dAge 'Flag for traditionally aged students (>15; <21 for FY, <25 for SR)'.
VALUE LABELS dAge 0 'Not traditional age' 1 'Traditional age (>15; <21 for FY, <25 for SR)'.
RECODE age (SYSMIS=SYSMIS) (ELSE=0) INTO dAge.
EXECUTE.
IF (IRclass=1 AND age GE 16 AND age LT 21) dAge=1.
IF (IRclass=4 AND age GE 16 AND age LT 25) dAge=1.
EXECUTE.

*********************************************************.
***** RECODE LIVING INTO ON CAMPUS AND OFF CAMPUS.
NUMERIC oncampus (F4.0).
RECODE living (1 THRU 2 =1) (3 THRU 5=0) INTO oncampus.
VARIABLE LABELS oncampus 'Student living on campus (collapsed recode of living)'.
VALUE LABELS oncampus 0 'No' 1 'Yes'.
EXECUTE.

**** FOR CANADIAN INSTITUTIONS RECODE LIVING_CA TO ONCAMPUS.
IF (living_ca LE 2) oncampus=1.
IF (living_ca GE 3) oncampus=0.
EXECUTE.

*********************************************************.
***** CREATE FIRST-GENERATION STATUS.
NUMERIC firstgen (F4.0).
RECODE parented (1 thru 4=1) (5 thru 7=0) INTO firstgen.
VARIABLE LABELS firstgen "First-Generation Status (neither parent/guardian holds a bachelor's degree)".
FORMATS firstgen(F4.0).
VALUE LABELS firstgen 0 'No' 1 'Yes'.
EXECUTE.

**** FOR CANADIAN INSTITUTIONS RECODE PARENTED_CA TO FIRSTGEN.
IF (parented_ca LE 4) firstgen = 1.
IF (parented_ca GT 4) firstgen = 0.
EXECUTE.

*********************************************************.
***** SYNTAXT TO CREATE TABLE.
****NOTE: If using NSSE 2013 data replace 'IRsex' with 'IRgender'.

CTABLES /TABLE (IRsex + IRrace + dage + FirstGen + IRenrollment + oncampus + MAJfirstCol) [COUNT ROWPCT F4.0]
BY IRclass > (learncomR + servcourseR + researchR + internR + abroadR + capstoneR)
/CATEGORIES VARIABLES = IRsex IRrace dage FirstGen IRenrollment oncampus MAJfirstCol TOTAL=NO EMPTY=INCLUDE
/CATEGORIES VARIABLES = IRrace [1, 2, 3, 4, 5, 6, 7, 8, 9] EMPTY=INCLUDE
/CATEGORIES VARIABLES = dAge [1, 0] EMPTY=INCLUDE
/CATEGORIES VARIABLES = MAJfirstcol [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 999] EMPTY=INCLUDE
/CATEGORIES VARIABLES = learncomR servcourseR researchR internR abroadR capstoneR [0, 1, SUBTOTAL].

Computing Engagement Indicators

 

Although Engagement Indicators are included in each institution's NSSE data file, an SPSS syntax to compute them on your own is available below. Use the syntax to understand how the indicators are calculated.

*********************************************************.
ENGAGEMENT INDICATOR SYNTAX
Note that Engagement Indicator scores are in the institutional data file and may cause an error
message that the variable already exists to display.
*********************************************************.

*********************************************************.
****HIGHER-ORDER LEARNING.
NUMERIC HO (F8.0).
VARIABLE LEVEL HO (SCALE).
VARIABLE LABELS HO 'Higher-Order Learning'.
COMPUTE HOapplyh=(HOapply-1)*20.
COMPUTE HOanalyzeh=(HOanalyze-1)*20.
COMPUTE HOevaluateh=(HOevaluate-1)*20.
COMPUTE HOformh=(HOform-1)*20.
EXECUTE.
COMPUTE HO=mean.4(HOapplyh, HOanalyzeh, HOevaluateh, HOformh).
EXECUTE.
DELETE VARIABLES HOapplyh HOanalyzeh HOevaluateh HOformh.

*********************************************************.
****REFLECTIVE AND INTEGRATIVE LEARNING.
****Compute when a respondent has answered at least 6 of the 7 items.
NUMERIC RI (F8.0).
VARIABLE LEVEL RI (SCALE).
VARIABLE LABELS RI 'Reflective and Integrative Learning'.
COMPUTE RIintegrateh=(RIintegrate-1)*20.
COMPUTE RIsocietalh=(RIsocietal-1)*20.
COMPUTE RIdiverseh=(RIdiverse-1)*20.
COMPUTE RIownviewh=(RIownview-1)*20.
COMPUTE RIperspecth=(RIperspect-1)*20.
COMPUTE RInewviewh=(RInewview-1)*20.
COMPUTE RIconnecth=(RIconnect-1)*20.
EXECUTE.
COMPUTE RI=mean.6(RIintegrateh, RIsocietalh, RIdiverseh, RIownviewh, RIperspecth, RInewviewh, RIconnecth).
EXECUTE.
DELETE VARIABLES RIintegrateh RIsocietalh RIdiverseh RIownviewh RIperspecth RInewviewh RIconnecth.

*********************************************************.
****QUANTITATIVE REASONING.
NUMERIC QR (F8.0).
VARIABLE LEVEL QR (SCALE).
VARIABLE LABELS QR 'Quantitative Reasoning'.
COMPUTE QRconcludeh=(QRconclude-1)*20.
COMPUTE QRproblemh=(QRproblem-1)*20.
COMPUTE QRevaluateh=(QRevaluate-1)*20.
EXECUTE.
COMPUTE QR=mean.3(QRconcludeh, QRproblemh, QRevaluateh).
EXECUTE.
DELETE VARIABLES QRconcludeh QRproblemh QRevaluateh.

*********************************************************.
****LEARNING STRATEGIES.
NUMERIC LS (F8.0).
VARIABLE LEVEL LS (SCALE).
VARIABLE LABELS LS 'Learning Strategies'.
COMPUTE LSreadingh=(LSreading-1)*20.
COMPUTE LSnotesh=(LSnotes-1)*20.
COMPUTE LSsummaryh=(LSsummary-1)*20.
EXECUTE.
COMPUTE LS=mean.3(LSreadingh, LSnotesh, LSsummaryh).
EXECUTE.
DELETE VARIABLES LSreadingh LSnotesh LSsummaryh.

*********************************************************.
****COLLABORATIVE LEARNING.
NUMERIC CL (F8.0).
VARIABLE LEVEL CL (SCALE).
VARIABLE LABELS CL 'Collaborative Learning'.
COMPUTE CLaskhelph=(CLaskhelp-1)*20.
COMPUTE CLexplainh=(CLexplain-1)*20.
COMPUTE CLstudyh=(CLstudy-1)*20.
COMPUTE CLprojecth=(CLproject-1)*20.
EXECUTE.
COMPUTE CL=mean.4(CLaskhelph, CLexplainh, CLstudyh, CLprojecth).
EXECUTE.
DELETE VARIABLES CLaskhelph CLexplainh CLstudyh CLprojecth.

*********************************************************.
****DISCUSSIONS WITH DIVERSE OTHERS.
NUMERIC DD (F8.0).
VARIABLE LEVEL DD (SCALE).
VARIABLE LABELS DD 'Discussions with Diverse Others'.
COMPUTE DDraceh=(DDrace-1)*20.
COMPUTE DDeconomich=(DDeconomic-1)*20.
COMPUTE DDreligionh=(DDreligion-1)*20.
COMPUTE DDpoliticalh=(DDpolitical-1)*20.
EXECUTE.
COMPUTE DD=mean.4(DDraceh, DDeconomich, DDreligionh, DDpoliticalh).
EXECUTE.
DELETE VARIABLES DDraceh DDeconomich DDreligionh DDpoliticalh.

*********************************************************.
****STUDENT-FACULTY INTERACTION.
NUMERIC SF (F8.0).
VARIABLE LEVEL SF (SCALE).
VARIABLE LABELS SF 'Student-Faculty Interaction'.
COMPUTE SFcareerh=(SFcareer-1)*20.
COMPUTE SFotherworkh=(SFotherwork-1)*20.
COMPUTE SFdiscussh=(SFdiscuss-1)*20.
COMPUTE SFperformh=(SFperform-1)*20.
EXECUTE.
COMPUTE SF=mean.4(SFcareerh, SFotherworkh, SFdiscussh, SFperformh).
EXECUTE.
DELETE VARIABLES SFcareerh SFotherworkh SFdiscussh SFperformh.

*********************************************************.
****EFFECTIVE TEACHING PRACTICES.
****Compute when a respondent has answered at least 4 of the 5 items.
NUMERIC ET (F8.0).
VARIABLE LEVEL ET (SCALE).
VARIABLE LABELS ET 'Effective Teaching Practices'.
COMPUTE ETgoalsh=(ETgoals-1)*20.
COMPUTE ETorganizeh=(ETorganize-1)*20.
COMPUTE ETexampleh=(ETexample-1)*20.
COMPUTE ETdraftfbh=(ETdraftfb-1)*20.
COMPUTE ETfeedbackh=(ETfeedback-1)*20.
EXECUTE.
COMPUTE ET=mean.4(ETgoalsh, ETorganizeh, ETexampleh, ETdraftfbh, ETfeedbackh).
EXECUTE.
DELETE VARIABLES ETgoalsh ETorganizeh ETexampleh ETdraftfbh ETfeedbackh.

*********************************************************.
****QUALITY OF INTERACTIONS.
****Compute when a respondent has answered at least 4 of the 5 items.
NUMERIC QI (F8.0).
VARIABLE LEVEL QI (SCALE).
VARIABLE LABELS QI 'Quality of Interactions'.
COMPUTE QIstudenth=(QIstudent-1)*10.
COMPUTE QIadvisorh=(QIadvisor-1)*10.
COMPUTE QIfacultyh=(QIfaculty-1)*10.
COMPUTE QIstaffh=(QIstaff-1)*10.
COMPUTE QIadminh=(QIadmin-1)*10.
EXECUTE.
COMPUTE QI=mean.4(QIstudenth, QIadvisorh, QIfacultyh, QIstaffh, QIadminh).
EXECUTE.
DELETE VARIABLES QIstudenth QIadvisorh QIfacultyh QIstaffh QIadminh.

*********************************************************.
****SUPPORTIVE ENVIRONMENT.
****Compute when a respondent has answered at least 7 of the 8 items.
NUMERIC SE (F8.0).
VARIABLE LEVEL SE (SCALE).
VARIABLE LABELS SE 'Supportive Environment'.
COMPUTE SEacademich=(SEacademic-1)*20.
COMPUTE SElearnsuph=(SElearnsup-1)*20.
COMPUTE SEdiverseh=(SEdiverse-1)*20.
COMPUTE SEsocialh=(SEsocial-1)*20.
COMPUTE SEwellnessh=(SEwellness-1)*20.
COMPUTE SEnonacadh=(SEnonacad-1)*20.
COMPUTE SEactivitiesh=(SEactivities-1)*20.
COMPUTE SEeventsh=(SEevents-1)*20.
EXECUTE.
COMPUTE SE=mean.7(SEacademich, SElearnsuph, SEdiverseh, SEsocialh, SEwellnessh,
SEnonacadh, SEactivitiesh, SEeventsh).
EXECUTE.
DELETE VARIABLES SEacademich SElearnsuph SEdiverseh SEsocialh SEwellnessh
SEnonacadh SEactivitiesh SEeventsh.

Creating Other Scales

In addition to the Engagement Indicators, NSSE items can be grouped into other measures for supplemental analysis. The links below provide code for computing summary scores for satisfaction and perceived gains.

Two scales are available that contribute to efforts to assess overall student satisfaction with the undergraduate experience. Use the SPSS syntax linked below to create the following Satisfaction Scales:

Overall Satisfaction (2 items)
Overall Satisfaction plus Quality of Campus Relationships (7 items)

*********************************************************.
SYNTAX TO CREATE SATISFACTION SCALES
2 satisfaction scales will be created
*********************************************************.

*******Overall Satisfaction (2 items)***********.
COMPUTE evalexpX = (evalexp-1)*20.
COMPUTE sameinstX = (sameinst-1)*20.
EXECUTE.

***Take the mean of the 2 items.
COMPUTE SToverall = mean.2(evalexpX, sameinstX).
VARIABLE LABELS SToverall "Overall Satisfaction".
EXECUTE.

*********************************************************.
****Satisfaction plus Quality of Campus Relationship (7 items).
****A scale will be created only if the students have answered 6 of 7 items.

MISSING VALUES QIstudent QIadvisor QIfaculty QIstaff QIadmin (9).
COMPUTE QIstudentX = (QIstudent-1)*10.
COMPUTE QIadvisorX=(QIadvisor-1)*10.
COMPUTE QIfacultyX=(QIfaculty-1)*10.
COMPUTE QIstaffX=(QIstaff-1)*10.
COMPUTE QIadminX=(QIadmin-1)*10.
EXECUTE.

***Take the mean of the 7 items when a respondent has at least 6 of the 7 items.
COMPUTE STqcr = mean.6(evalexpX, sameinstX, QIstudentX, QIadvisorX, QIfacultyX, QIstaffX, QIadminX).
VARIABLE LABELS STqcr "Satisfaction plus Quality of Campus Relationships".
EXECUTE.

A scale is provided which explores the degree to which students reported having made gains in a variety of personal, practical, and general education competency areas as a result of their undergraduate education.

*********************************************************.

COMPUTE pgwriteX=(pgwrite-1)*20.
COMPUTE pgspeakX=(pgspeak-1)*20.
COMPUTE pgthinkX=(pgthink-1)*20.
COMPUTE pganalyzeX=(pganalyze-1)*20.
COMPUTE pgworkX=(pgwork-1)*20.
COMPUTE pgothersX=(pgothers-1)*20.
COMPUTE pgvaluesX=(pgvalues-1)*20.
COMPUTE pgdiverseX=(pgdiverse-1)*20.
COMPUTE pgprobsolveX=(pgprobsolve-1)*20.
COMPUTE pgcitizenX=(pgcitizen-1)*20.
EXECUTE.

***Take the mean of the 10 items when a respondent has at least 9 of the 10 items.
COMPUTE pg=mean.9(pgwriteX, pgspeakX, pgthinkX, pganalyzeX, pgworkX, pgothersX,
pgvaluesX, pgdiverseX, pgprobsolveX, pgcitizenX).
EXECUTE.

Evidence-Based Improvement in Higher Education

Center for Postsecondary Research
Indiana University
School of Education
201 N. Rose Avenue
Bloomington, IN 47405-1006
Phone: 812.856.5824
Email: