SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only

  • 1.  Syntax to recode variable - help!

    Posted Mon November 07, 2022 01:27 PM
    Hello, I have a dataset that lists 7 million rows of data. One of the variables is the course the student is enrolled in. There are numerous options. I want to code 29 classes as "1" and the other 244 classes as "0." My syntax is not working. Can you help? 

    RECODE SERVICEX (ADVANCED QUANT REASONING, ALGEBRA I, ALGEBRA I (ALG 1), ALGEBRA II, ALGEBRA II (ALG2), AP ENVIRONMENTAL SCIENCE, AP PHYSICS 1, AP PHYSICS 2, AP PHYSICS C, AP STATISTICS (APSTATS), AQUATIC SCIENCE (AQUA SCI), BIOLOGY, BIOLOGY (BIO), CHEMISTRY, CHEMISTRY (CHEM), COLGE PREP COURSE MATHEMATICS, COMPUTER SCIENCE I, ENVIRONMENTAL SYSTEMS-ENVIRSYS, GEOMETRY, GEOMETRY (GEOM), IB BIOLOGY (IB-BIO), IB ENVR SYS & SOC (IBENVIRS), INDEP STUDY IN MATH (1ST TIME), INDEP STUDY IN MATH (2ND TIME), INDPT STDY IN TECH APS 1ST TME, INDPT STDY IN TECH APS 2ND TME, INTEGRATED PHYSICS/CHEMISTRY, MATHEMATICAL MODELS W/APPLCTN, PHYSICS, PHYSICS (PHYSICS), PRECALCULUS (PRE CALC), ROBOTICS PROGRAMMING & DESIGN=1).

    ------------------------------
    Debra Dean
    ------------------------------

    #SPSSStatistics


  • 2.  RE: Syntax to recode variable - help!

    Posted Mon November 07, 2022 01:44 PM
    Try creating a new variable, like this:

    COMPUTE NEW_CODE=0.
    IF ANY(SERVICEX, 'ADVANCED QUANT REASONING', 'ALGEBRA I',
    'ALGEBRA I (ALG 1)', 'ALGEBRA II', 'ALGEBRA II (ALG2)',
    'AP ENVIRONMENTAL SCIENCE', 'AP PHYSICS 1', 'AP PHYSICS 2',
    'AP PHYSICS C', 'AP STATISTICS (APSTATS)', 'AQUATIC SCIENCE (AQUA SCI)',
    'BIOLOGY', 'BIOLOGY (BIO)', 'CHEMISTRY', 'CHEMISTRY (CHEM)',
    'COLGE PREP COURSE MATHEMATICS', 'COMPUTER SCIENCE I',
    'ENVIRONMENTAL SYSTEMS-ENVIRSYS', 'GEOMETRY',
    'GEOMETRY (GEOM)', 'IB BIOLOGY (IB-BIO)', 'IB ENVR SYS & SOC (IBENVIRS)',
    'INDEP STUDY IN MATH (1ST TIME)', 'INDEP STUDY IN MATH (2ND TIME)',
    'INDPT STDY IN TECH APS 1ST TME', 'INDPT STDY IN TECH APS 2ND TME',
    'INTEGRATED PHYSICS/CHEMISTRY', 'MATHEMATICAL MODELS W/APPLCTN',
    'PHYSICS', 'PHYSICS (PHYSICS)', 'PRECALCULUS (PRE CALC)',
    'ROBOTICS PROGRAMMING & DESIGN') NEW_CODE=1.
    EXECUTE.

    ** Just rename new_code to whatever sensible name you want.

    ------------------------------
    Rick Marcantonio
    Quality Assurance
    IBM
    ------------------------------

    Original Message


Related Content