Good day community!
I need help identifying the issue with the code below. I want to replace the variable "program_type" to "Multiple Pathways Program" for all values that are not "Middle School Basketball". When I run the code listed below it changed all values to "Multiple Pathways Program." What is the issue here? I appreciate your help!
replace program_type="Multiple Pathways" if program_type!=" Middle School Basketball"
ORIGINAL DATA
[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 dbn str58 psal_name int psal_code byte sport_code str43 sport_name float(group_sport_id check_total_team) str15 program_type
"01M332" "University Neighborhood Middle School" 1332 90 " Middle Schools Basketball Boys" 1 2 " Middle Schools"
"01M332" "University Neighborhood Middle School" 1332 91 " Middle Schools Basketball Girls" 2 2 " Middle Schools"
"01M450" "East Side Community" 1420 6 "Baseball Boys Varsity" 1 8 "Baseball Boys V"
"01M450" "East Side Community" 1420 2 "Basketball Boys Jr. Varsity" 2 8 "Basketball Boys"
"01M450" "East Side Community" 1420 1 "Basketball Boys Varsity" 3 8 "Basketball Boys"
"01M450" "East Side Community" 1420 3 "Basketball Girls Varsity" 4 8 "Basketball Girl"
"01M450" "East Side Community" 1420 12 "Soccer Boys Varsity" 5 8 "Soccer Boys Var"
"01M450" "East Side Community" 1420 21 "Soccer Girls Varsity" 6 8 "Soccer Girls Va"
"01M450" "East Side Community" 1420 22 "Softball Girls Varsity" 7 8 "Softball Girls "
"01M450" "East Side Community" 1420 26 "Volleyball Girls Varsity" 8 8 "Volleyball Girl"
"01M539" "Nest+M" 1538 68 "Badminton Girls Varsity" 1 12 "Badminton Girls"
"01M539" "Nest+M" 1538 1 "Basketball Boys Varsity" 2 12 "Basketball Boys"
"01M539" "Nest+M" 1538 3 "Basketball Girls Varsity" 3 12 "Basketball Girl"
"01M539" "Nest+M" 1538 54 "Fencing Boys Varsity" 4 12 "Fencing Boys Va"
"01M539" "Nest+M" 1538 55 "Fencing Girls Varsity" 5 12 "Fencing Girls V"
"01M539" "Nest+M" 1538 35 "Indoor Track Boys" 6 12 "Indoor Track Bo"
"01M539" "Nest+M" 1538 32 "Indoor Track Girls" 7 12 "Indoor Track Gi"
"01M539" "Nest+M" 1538 12 "Soccer Boys Varsity" 8 12 "Soccer Boys Var"
"01M539" "Nest+M" 1538 21 "Soccer Girls Varsity" 9 12 "Soccer Girls Va"
"01M539" "Nest+M" 1538 22 "Softball Girls Varsity" 10 12 "Softball Girls "
"01M539" "Nest+M" 1538 66 "Table Tennis Girls Varsity" 11 12 "Table Tennis Gi"
"01M539" "Nest+M" 1538 26 "Volleyball Girls Varsity" 12 12 "Volleyball Girl"
"01M292" "Orchard Collegiate Academy" 1552 16 "Volleyball Boys Varsity" 1 2 "Volleyball Boys"
"01M292" "Orchard Collegiate Academy" 1552 26 "Volleyball Girls Varsity" 2 2 "Volleyball Girl"
"01M458" "Forsyth / Cascades" 1561 49 "Basketball Boys Multiple Pathways League" 1 1 "Basketball Boys"
"01M696" "Bard High School Early College" 1569 6 "Baseball Boys Varsity" 1 12 "Baseball Boys V"
"01M696" "Bard High School Early College" 1569 1 "Basketball Boys Varsity" 2 12 "Basketball Boys"
"01M696" "Bard High School Early College" 1569 3 "Basketball Girls Varsity" 3 12 "Basketball Girl"
"01M696" "Bard High School Early College" 1569 33 "Cross Country Boys" 4 12 "Cross Country B"
"01M696" "Bard High School Early College" 1569 34 "Cross Country Girls" 5 12 "Cross Country G"
"01M696" "Bard High School Early College" 1569 30 "Outdoor Track Boys" 6 12 "Outdoor Track B"
"01M696" "Bard High School Early College" 1569 31 "Outdoor Track Girls" 7 12 "Outdoor Track G"
"01M696" "Bard High School Early College" 1569 12 "Soccer Boys Varsity" 8 12 "Soccer Boys Var"
"01M696" "Bard High School Early College" 1569 21 "Soccer Girls Varsity" 9 12 "Soccer Girls Va"
"01M696" "Bard High School Early College" 1569 14 "Tennis Boys Varsity" 10 12 "Tennis Boys Var"
"01M696" "Bard High School Early College" 1569 24 "Tennis Girls Varsity" 11 12 "Tennis Girls Va"
"01M696" "Bard High School Early College" 1569 26 "Volleyball Girls Varsity" 12 12 "Volleyball Girl"
"01M515" "Lower East Side Prep" 1854 49 "Basketball Boys Multiple Pathways League" 1 3 "Basketball Boys"
"01M515" "Lower East Side Prep" 1854 73 "Soccer Boys Multiple Pathways League" 2 3 "Soccer Boys Mul"
"01M515" "Lower East Side Prep" 1854 71 "Table Tennis Coed Multiple Pathways League" 3 3 "Table Tennis Co"
"02M047" "American Sign Language And English" 2047 1 "Basketball Boys Varsity" 1 3 "Basketball Boys"
"02M047" "American Sign Language And English" 2047 69 "Stunt Coed Varsity" 2 3 "Stunt Coed Vars"
"02M047" "American Sign Language And English" 2047 26 "Volleyball Girls Varsity" 3 3 "Volleyball Girl"
"02M260" "The Clinton School" 2260 1 "Basketball Boys Varsity" 1 6 "Basketball Boys"
"02M260" "The Clinton School" 2260 3 "Basketball Girls Varsity" 2 6 "Basketball Girl"
"02M260" "The Clinton School" 2260 34 "Cross Country Girls" 3 6 "Cross Country G"
"02M260" "The Clinton School" 2260 12 "Soccer Boys Varsity" 4 6 "Soccer Boys Var"
"02M260" "The Clinton School" 2260 21 "Soccer Girls Varsity" 5 6 "Soccer Girls Va"
"02M260" "The Clinton School" 2260 26 "Volleyball Girls Varsity" 6 6 "Volleyball Girl"
"02M489" "Hs Economics & Finance" 2350 1 "Basketball Boys Varsity" 1 12 "Basketball Boys"
"02M489" "Hs Economics & Finance" 2350 3 "Basketball Girls Varsity" 2 12 "Basketball Girl"
"02M489" "Hs Economics & Finance" 2350 7 "Bowling Boys Varsity" 3 12 "Bowling Boys Va"
"02M489" "Hs Economics & Finance" 2350 18 "Bowling Girls Varsity" 4 12 "Bowling Girls V"
"02M489" "Hs Economics & Finance" 2350 33 "Cross Country Boys" 5 12 "Cross Country B"
"02M489" "Hs Economics & Finance" 2350 34 "Cross Country Girls" 6 12 "Cross Country G"
"02M489" "Hs Economics & Finance" 2350 61 "Flag Football Girls Varsity" 7 12 "Flag Football G"
"02M489" "Hs Economics & Finance" 2350 11 "Handball Boys Varsity" 8 12 "Handball Boys V"
"02M489" "Hs Economics & Finance" 2350 30 "Outdoor Track Boys" 9 12 "Outdoor Track B"
"02M489" "Hs Economics & Finance" 2350 31 "Outdoor Track Girls" 10 12 "Outdoor Track G"
"02M489" "Hs Economics & Finance" 2350 22 "Softball Girls Varsity" 11 12 "Softball Girls "
"02M489" "Hs Economics & Finance" 2350 24 "Tennis Girls Varsity" 12 12 "Tennis Girls Va"
"02M439" "Manhattan Village Academy" 2358 6 "Baseball Boys Varsity" 1 6 "Baseball Boys V"
"02M439" "Manhattan Village Academy" 2358 1 "Basketball Boys Varsity" 2 6 "Basketball Boys"
"02M439" "Manhattan Village Academy" 2358 3 "Basketball Girls Varsity" 3 6 "Basketball Girl"
"02M439" "Manhattan Village Academy" 2358 12 "Soccer Boys Varsity" 4 6 "Soccer Boys Var"
"02M439" "Manhattan Village Academy" 2358 21 "Soccer Girls Varsity" 5 6 "Soccer Girls Va"
"02M439" "Manhattan Village Academy" 2358 22 "Softball Girls Varsity" 6 6 "Softball Girls "
"02M425" "Hs For Leadership & Public Service" 2370 1 "Basketball Boys Varsity" 1 3 "Basketball Boys"
"02M425" "Hs For Leadership & Public Service" 2370 3 "Basketball Girls Varsity" 2 3 "Basketball Girl"
"02M425" "Hs For Leadership & Public Service" 2370 22 "Softball Girls Varsity" 3 3 "Softball Girls "
"02M407" "Institute For Collaborative Education" 2378 6 "Baseball Boys Varsity" 1 9 "Baseball Boys V"
"02M407" "Institute For Collaborative Education" 2378 1 "Basketball Boys Varsity" 2 9 "Basketball Boys"
"02M407" "Institute For Collaborative Education" 2378 3 "Basketball Girls Varsity" 3 9 "Basketball Girl"
"02M407" "Institute For Collaborative Education" 2378 32 "Indoor Track Girls" 4 9 "Indoor Track Gi"
"02M407" "Institute For Collaborative Education" 2378 12 "Soccer Boys Varsity" 5 9 "Soccer Boys Var"
"02M407" "Institute For Collaborative Education" 2378 21 "Soccer Girls Varsity" 6 9 "Soccer Girls Va"
"02M407" "Institute For Collaborative Education" 2378 22 "Softball Girls Varsity" 7 9 "Softball Girls "
"02M407" "Institute For Collaborative Education" 2378 65 "Table Tennis Boys Varsity" 8 9 "Table Tennis Bo"
"02M407" "Institute For Collaborative Education" 2378 26 "Volleyball Girls Varsity" 9 9 "Volleyball Girl"
"02M420" "Hs Health Profession/Human Services" 2380 6 "Baseball Boys Varsity" 1 15 "Baseball Boys V"
"02M420" "Hs Health Profession/Human Services" 2380 2 "Basketball Boys Jr. Varsity" 2 15 "Basketball Boys"
"02M420" "Hs Health Profession/Human Services" 2380 1 "Basketball Boys Varsity" 3 15 "Basketball Boys"
"02M420" "Hs Health Profession/Human Services" 2380 3 "Basketball Girls Varsity" 4 15 "Basketball Girl"
"02M420" "Hs Health Profession/Human Services" 2380 34 "Cross Country Girls" 5 15 "Cross Country G"
"02M420" "Hs Health Profession/Human Services" 2380 61 "Flag Football Girls Varsity" 6 15 "Flag Football G"
"02M420" "Hs Health Profession/Human Services" 2380 11 "Handball Boys Varsity" 7 15 "Handball Boys V"
"02M420" "Hs Health Profession/Human Services" 2380 20 "Handball Girls Varsity" 8 15 "Handball Girls "
"02M420" "Hs Health Profession/Human Services" 2380 32 "Indoor Track Girls" 9 15 "Indoor Track Gi"
"02M420" "Hs Health Profession/Human Services" 2380 31 "Outdoor Track Girls" 10 15 "Outdoor Track G"
"02M420" "Hs Health Profession/Human Services" 2380 12 "Soccer Boys Varsity" 11 15 "Soccer Boys Var"
"02M420" "Hs Health Profession/Human Services" 2380 21 "Soccer Girls Varsity" 12 15 "Soccer Girls Va"
"02M420" "Hs Health Profession/Human Services" 2380 22 "Softball Girls Varsity" 13 15 "Softball Girls "
"02M420" "Hs Health Profession/Human Services" 2380 38 "Volleyball Girls Jr. Varsity" 14 15 "Volleyball Girl"
"02M420" "Hs Health Profession/Human Services" 2380 26 "Volleyball Girls Varsity" 15 15 "Volleyball Girl"
"02M413" "School Of The Future" 2436 6 "Baseball Boys Varsity" 1 10 "Baseball Boys V"
"02M413" "School Of The Future" 2436 2 "Basketball Boys Jr. Varsity" 2 10 "Basketball Boys"
"02M413" "School Of The Future" 2436 1 "Basketball Boys Varsity" 3 10 "Basketball Boys"
"02M413" "School Of The Future" 2436 3 "Basketball Girls Varsity" 4 10 "Basketball Girl"
"02M413" "School Of The Future" 2436 20 "Handball Girls Varsity" 5 10 "Handball Girls "
"02M413" "School Of The Future" 2436 12 "Soccer Boys Varsity" 6 10 "Soccer Boys Var"
DATA AFTER CODE IS RAN
I need help identifying the issue with the code below. I want to replace the variable "program_type" to "Multiple Pathways Program" for all values that are not "Middle School Basketball". When I run the code listed below it changed all values to "Multiple Pathways Program." What is the issue here? I appreciate your help!
replace program_type="Multiple Pathways" if program_type!=" Middle School Basketball"
ORIGINAL DATA
[CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input str6 dbn str58 psal_name int psal_code byte sport_code str43 sport_name float(group_sport_id check_total_team) str15 program_type
"01M332" "University Neighborhood Middle School" 1332 90 " Middle Schools Basketball Boys" 1 2 " Middle Schools"
"01M332" "University Neighborhood Middle School" 1332 91 " Middle Schools Basketball Girls" 2 2 " Middle Schools"
"01M450" "East Side Community" 1420 6 "Baseball Boys Varsity" 1 8 "Baseball Boys V"
"01M450" "East Side Community" 1420 2 "Basketball Boys Jr. Varsity" 2 8 "Basketball Boys"
"01M450" "East Side Community" 1420 1 "Basketball Boys Varsity" 3 8 "Basketball Boys"
"01M450" "East Side Community" 1420 3 "Basketball Girls Varsity" 4 8 "Basketball Girl"
"01M450" "East Side Community" 1420 12 "Soccer Boys Varsity" 5 8 "Soccer Boys Var"
"01M450" "East Side Community" 1420 21 "Soccer Girls Varsity" 6 8 "Soccer Girls Va"
"01M450" "East Side Community" 1420 22 "Softball Girls Varsity" 7 8 "Softball Girls "
"01M450" "East Side Community" 1420 26 "Volleyball Girls Varsity" 8 8 "Volleyball Girl"
"01M539" "Nest+M" 1538 68 "Badminton Girls Varsity" 1 12 "Badminton Girls"
"01M539" "Nest+M" 1538 1 "Basketball Boys Varsity" 2 12 "Basketball Boys"
"01M539" "Nest+M" 1538 3 "Basketball Girls Varsity" 3 12 "Basketball Girl"
"01M539" "Nest+M" 1538 54 "Fencing Boys Varsity" 4 12 "Fencing Boys Va"
"01M539" "Nest+M" 1538 55 "Fencing Girls Varsity" 5 12 "Fencing Girls V"
"01M539" "Nest+M" 1538 35 "Indoor Track Boys" 6 12 "Indoor Track Bo"
"01M539" "Nest+M" 1538 32 "Indoor Track Girls" 7 12 "Indoor Track Gi"
"01M539" "Nest+M" 1538 12 "Soccer Boys Varsity" 8 12 "Soccer Boys Var"
"01M539" "Nest+M" 1538 21 "Soccer Girls Varsity" 9 12 "Soccer Girls Va"
"01M539" "Nest+M" 1538 22 "Softball Girls Varsity" 10 12 "Softball Girls "
"01M539" "Nest+M" 1538 66 "Table Tennis Girls Varsity" 11 12 "Table Tennis Gi"
"01M539" "Nest+M" 1538 26 "Volleyball Girls Varsity" 12 12 "Volleyball Girl"
"01M292" "Orchard Collegiate Academy" 1552 16 "Volleyball Boys Varsity" 1 2 "Volleyball Boys"
"01M292" "Orchard Collegiate Academy" 1552 26 "Volleyball Girls Varsity" 2 2 "Volleyball Girl"
"01M458" "Forsyth / Cascades" 1561 49 "Basketball Boys Multiple Pathways League" 1 1 "Basketball Boys"
"01M696" "Bard High School Early College" 1569 6 "Baseball Boys Varsity" 1 12 "Baseball Boys V"
"01M696" "Bard High School Early College" 1569 1 "Basketball Boys Varsity" 2 12 "Basketball Boys"
"01M696" "Bard High School Early College" 1569 3 "Basketball Girls Varsity" 3 12 "Basketball Girl"
"01M696" "Bard High School Early College" 1569 33 "Cross Country Boys" 4 12 "Cross Country B"
"01M696" "Bard High School Early College" 1569 34 "Cross Country Girls" 5 12 "Cross Country G"
"01M696" "Bard High School Early College" 1569 30 "Outdoor Track Boys" 6 12 "Outdoor Track B"
"01M696" "Bard High School Early College" 1569 31 "Outdoor Track Girls" 7 12 "Outdoor Track G"
"01M696" "Bard High School Early College" 1569 12 "Soccer Boys Varsity" 8 12 "Soccer Boys Var"
"01M696" "Bard High School Early College" 1569 21 "Soccer Girls Varsity" 9 12 "Soccer Girls Va"
"01M696" "Bard High School Early College" 1569 14 "Tennis Boys Varsity" 10 12 "Tennis Boys Var"
"01M696" "Bard High School Early College" 1569 24 "Tennis Girls Varsity" 11 12 "Tennis Girls Va"
"01M696" "Bard High School Early College" 1569 26 "Volleyball Girls Varsity" 12 12 "Volleyball Girl"
"01M515" "Lower East Side Prep" 1854 49 "Basketball Boys Multiple Pathways League" 1 3 "Basketball Boys"
"01M515" "Lower East Side Prep" 1854 73 "Soccer Boys Multiple Pathways League" 2 3 "Soccer Boys Mul"
"01M515" "Lower East Side Prep" 1854 71 "Table Tennis Coed Multiple Pathways League" 3 3 "Table Tennis Co"
"02M047" "American Sign Language And English" 2047 1 "Basketball Boys Varsity" 1 3 "Basketball Boys"
"02M047" "American Sign Language And English" 2047 69 "Stunt Coed Varsity" 2 3 "Stunt Coed Vars"
"02M047" "American Sign Language And English" 2047 26 "Volleyball Girls Varsity" 3 3 "Volleyball Girl"
"02M260" "The Clinton School" 2260 1 "Basketball Boys Varsity" 1 6 "Basketball Boys"
"02M260" "The Clinton School" 2260 3 "Basketball Girls Varsity" 2 6 "Basketball Girl"
"02M260" "The Clinton School" 2260 34 "Cross Country Girls" 3 6 "Cross Country G"
"02M260" "The Clinton School" 2260 12 "Soccer Boys Varsity" 4 6 "Soccer Boys Var"
"02M260" "The Clinton School" 2260 21 "Soccer Girls Varsity" 5 6 "Soccer Girls Va"
"02M260" "The Clinton School" 2260 26 "Volleyball Girls Varsity" 6 6 "Volleyball Girl"
"02M489" "Hs Economics & Finance" 2350 1 "Basketball Boys Varsity" 1 12 "Basketball Boys"
"02M489" "Hs Economics & Finance" 2350 3 "Basketball Girls Varsity" 2 12 "Basketball Girl"
"02M489" "Hs Economics & Finance" 2350 7 "Bowling Boys Varsity" 3 12 "Bowling Boys Va"
"02M489" "Hs Economics & Finance" 2350 18 "Bowling Girls Varsity" 4 12 "Bowling Girls V"
"02M489" "Hs Economics & Finance" 2350 33 "Cross Country Boys" 5 12 "Cross Country B"
"02M489" "Hs Economics & Finance" 2350 34 "Cross Country Girls" 6 12 "Cross Country G"
"02M489" "Hs Economics & Finance" 2350 61 "Flag Football Girls Varsity" 7 12 "Flag Football G"
"02M489" "Hs Economics & Finance" 2350 11 "Handball Boys Varsity" 8 12 "Handball Boys V"
"02M489" "Hs Economics & Finance" 2350 30 "Outdoor Track Boys" 9 12 "Outdoor Track B"
"02M489" "Hs Economics & Finance" 2350 31 "Outdoor Track Girls" 10 12 "Outdoor Track G"
"02M489" "Hs Economics & Finance" 2350 22 "Softball Girls Varsity" 11 12 "Softball Girls "
"02M489" "Hs Economics & Finance" 2350 24 "Tennis Girls Varsity" 12 12 "Tennis Girls Va"
"02M439" "Manhattan Village Academy" 2358 6 "Baseball Boys Varsity" 1 6 "Baseball Boys V"
"02M439" "Manhattan Village Academy" 2358 1 "Basketball Boys Varsity" 2 6 "Basketball Boys"
"02M439" "Manhattan Village Academy" 2358 3 "Basketball Girls Varsity" 3 6 "Basketball Girl"
"02M439" "Manhattan Village Academy" 2358 12 "Soccer Boys Varsity" 4 6 "Soccer Boys Var"
"02M439" "Manhattan Village Academy" 2358 21 "Soccer Girls Varsity" 5 6 "Soccer Girls Va"
"02M439" "Manhattan Village Academy" 2358 22 "Softball Girls Varsity" 6 6 "Softball Girls "
"02M425" "Hs For Leadership & Public Service" 2370 1 "Basketball Boys Varsity" 1 3 "Basketball Boys"
"02M425" "Hs For Leadership & Public Service" 2370 3 "Basketball Girls Varsity" 2 3 "Basketball Girl"
"02M425" "Hs For Leadership & Public Service" 2370 22 "Softball Girls Varsity" 3 3 "Softball Girls "
"02M407" "Institute For Collaborative Education" 2378 6 "Baseball Boys Varsity" 1 9 "Baseball Boys V"
"02M407" "Institute For Collaborative Education" 2378 1 "Basketball Boys Varsity" 2 9 "Basketball Boys"
"02M407" "Institute For Collaborative Education" 2378 3 "Basketball Girls Varsity" 3 9 "Basketball Girl"
"02M407" "Institute For Collaborative Education" 2378 32 "Indoor Track Girls" 4 9 "Indoor Track Gi"
"02M407" "Institute For Collaborative Education" 2378 12 "Soccer Boys Varsity" 5 9 "Soccer Boys Var"
"02M407" "Institute For Collaborative Education" 2378 21 "Soccer Girls Varsity" 6 9 "Soccer Girls Va"
"02M407" "Institute For Collaborative Education" 2378 22 "Softball Girls Varsity" 7 9 "Softball Girls "
"02M407" "Institute For Collaborative Education" 2378 65 "Table Tennis Boys Varsity" 8 9 "Table Tennis Bo"
"02M407" "Institute For Collaborative Education" 2378 26 "Volleyball Girls Varsity" 9 9 "Volleyball Girl"
"02M420" "Hs Health Profession/Human Services" 2380 6 "Baseball Boys Varsity" 1 15 "Baseball Boys V"
"02M420" "Hs Health Profession/Human Services" 2380 2 "Basketball Boys Jr. Varsity" 2 15 "Basketball Boys"
"02M420" "Hs Health Profession/Human Services" 2380 1 "Basketball Boys Varsity" 3 15 "Basketball Boys"
"02M420" "Hs Health Profession/Human Services" 2380 3 "Basketball Girls Varsity" 4 15 "Basketball Girl"
"02M420" "Hs Health Profession/Human Services" 2380 34 "Cross Country Girls" 5 15 "Cross Country G"
"02M420" "Hs Health Profession/Human Services" 2380 61 "Flag Football Girls Varsity" 6 15 "Flag Football G"
"02M420" "Hs Health Profession/Human Services" 2380 11 "Handball Boys Varsity" 7 15 "Handball Boys V"
"02M420" "Hs Health Profession/Human Services" 2380 20 "Handball Girls Varsity" 8 15 "Handball Girls "
"02M420" "Hs Health Profession/Human Services" 2380 32 "Indoor Track Girls" 9 15 "Indoor Track Gi"
"02M420" "Hs Health Profession/Human Services" 2380 31 "Outdoor Track Girls" 10 15 "Outdoor Track G"
"02M420" "Hs Health Profession/Human Services" 2380 12 "Soccer Boys Varsity" 11 15 "Soccer Boys Var"
"02M420" "Hs Health Profession/Human Services" 2380 21 "Soccer Girls Varsity" 12 15 "Soccer Girls Va"
"02M420" "Hs Health Profession/Human Services" 2380 22 "Softball Girls Varsity" 13 15 "Softball Girls "
"02M420" "Hs Health Profession/Human Services" 2380 38 "Volleyball Girls Jr. Varsity" 14 15 "Volleyball Girl"
"02M420" "Hs Health Profession/Human Services" 2380 26 "Volleyball Girls Varsity" 15 15 "Volleyball Girl"
"02M413" "School Of The Future" 2436 6 "Baseball Boys Varsity" 1 10 "Baseball Boys V"
"02M413" "School Of The Future" 2436 2 "Basketball Boys Jr. Varsity" 2 10 "Basketball Boys"
"02M413" "School Of The Future" 2436 1 "Basketball Boys Varsity" 3 10 "Basketball Boys"
"02M413" "School Of The Future" 2436 3 "Basketball Girls Varsity" 4 10 "Basketball Girl"
"02M413" "School Of The Future" 2436 20 "Handball Girls Varsity" 5 10 "Handball Girls "
"02M413" "School Of The Future" 2436 12 "Soccer Boys Varsity" 6 10 "Soccer Boys Var"
DATA AFTER CODE IS RAN
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str6 dbn str58 psal_name int psal_code byte sport_code str43 sport_name float(group_sport_id check_total_team) str17 program_type "01M332" "University Neighborhood Middle School" 1332 90 " Middle Schools Basketball Boys" 1 2 "Multiple Pathways" "01M332" "University Neighborhood Middle School" 1332 91 " Middle Schools Basketball Girls" 2 2 "Multiple Pathways" "01M450" "East Side Community" 1420 6 "Baseball Boys Varsity" 1 8 "Multiple Pathways" "01M450" "East Side Community" 1420 2 "Basketball Boys Jr. Varsity" 2 8 "Multiple Pathways" "01M450" "East Side Community" 1420 1 "Basketball Boys Varsity" 3 8 "Multiple Pathways" "01M450" "East Side Community" 1420 3 "Basketball Girls Varsity" 4 8 "Multiple Pathways" "01M450" "East Side Community" 1420 12 "Soccer Boys Varsity" 5 8 "Multiple Pathways" "01M450" "East Side Community" 1420 21 "Soccer Girls Varsity" 6 8 "Multiple Pathways" "01M450" "East Side Community" 1420 22 "Softball Girls Varsity" 7 8 "Multiple Pathways" "01M450" "East Side Community" 1420 26 "Volleyball Girls Varsity" 8 8 "Multiple Pathways" "01M539" "Nest+M" 1538 68 "Badminton Girls Varsity" 1 12 "Multiple Pathways" "01M539" "Nest+M" 1538 1 "Basketball Boys Varsity" 2 12 "Multiple Pathways" "01M539" "Nest+M" 1538 3 "Basketball Girls Varsity" 3 12 "Multiple Pathways" "01M539" "Nest+M" 1538 54 "Fencing Boys Varsity" 4 12 "Multiple Pathways" "01M539" "Nest+M" 1538 55 "Fencing Girls Varsity" 5 12 "Multiple Pathways" "01M539" "Nest+M" 1538 35 "Indoor Track Boys" 6 12 "Multiple Pathways" "01M539" "Nest+M" 1538 32 "Indoor Track Girls" 7 12 "Multiple Pathways" "01M539" "Nest+M" 1538 12 "Soccer Boys Varsity" 8 12 "Multiple Pathways" "01M539" "Nest+M" 1538 21 "Soccer Girls Varsity" 9 12 "Multiple Pathways" "01M539" "Nest+M" 1538 22 "Softball Girls Varsity" 10 12 "Multiple Pathways" "01M539" "Nest+M" 1538 66 "Table Tennis Girls Varsity" 11 12 "Multiple Pathways" "01M539" "Nest+M" 1538 26 "Volleyball Girls Varsity" 12 12 "Multiple Pathways" "01M292" "Orchard Collegiate Academy" 1552 16 "Volleyball Boys Varsity" 1 2 "Multiple Pathways" "01M292" "Orchard Collegiate Academy" 1552 26 "Volleyball Girls Varsity" 2 2 "Multiple Pathways" "01M458" "Forsyth / Cascades" 1561 49 "Basketball Boys Multiple Pathways League" 1 1 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 6 "Baseball Boys Varsity" 1 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 1 "Basketball Boys Varsity" 2 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 3 "Basketball Girls Varsity" 3 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 33 "Cross Country Boys" 4 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 34 "Cross Country Girls" 5 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 30 "Outdoor Track Boys" 6 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 31 "Outdoor Track Girls" 7 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 12 "Soccer Boys Varsity" 8 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 21 "Soccer Girls Varsity" 9 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 14 "Tennis Boys Varsity" 10 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 24 "Tennis Girls Varsity" 11 12 "Multiple Pathways" "01M696" "Bard High School Early College" 1569 26 "Volleyball Girls Varsity" 12 12 "Multiple Pathways" "01M515" "Lower East Side Prep" 1854 49 "Basketball Boys Multiple Pathways League" 1 3 "Multiple Pathways" "01M515" "Lower East Side Prep" 1854 73 "Soccer Boys Multiple Pathways League" 2 3 "Multiple Pathways" "01M515" "Lower East Side Prep" 1854 71 "Table Tennis Coed Multiple Pathways League" 3 3 "Multiple Pathways" "02M047" "American Sign Language And English" 2047 1 "Basketball Boys Varsity" 1 3 "Multiple Pathways" "02M047" "American Sign Language And English" 2047 69 "Stunt Coed Varsity" 2 3 "Multiple Pathways" "02M047" "American Sign Language And English" 2047 26 "Volleyball Girls Varsity" 3 3 "Multiple Pathways" "02M260" "The Clinton School" 2260 1 "Basketball Boys Varsity" 1 6 "Multiple Pathways" "02M260" "The Clinton School" 2260 3 "Basketball Girls Varsity" 2 6 "Multiple Pathways" "02M260" "The Clinton School" 2260 34 "Cross Country Girls" 3 6 "Multiple Pathways" "02M260" "The Clinton School" 2260 12 "Soccer Boys Varsity" 4 6 "Multiple Pathways" "02M260" "The Clinton School" 2260 21 "Soccer Girls Varsity" 5 6 "Multiple Pathways" "02M260" "The Clinton School" 2260 26 "Volleyball Girls Varsity" 6 6 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 1 "Basketball Boys Varsity" 1 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 3 "Basketball Girls Varsity" 2 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 7 "Bowling Boys Varsity" 3 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 18 "Bowling Girls Varsity" 4 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 33 "Cross Country Boys" 5 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 34 "Cross Country Girls" 6 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 61 "Flag Football Girls Varsity" 7 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 11 "Handball Boys Varsity" 8 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 30 "Outdoor Track Boys" 9 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 31 "Outdoor Track Girls" 10 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 22 "Softball Girls Varsity" 11 12 "Multiple Pathways" "02M489" "Hs Economics & Finance" 2350 24 "Tennis Girls Varsity" 12 12 "Multiple Pathways" "02M439" "Manhattan Village Academy" 2358 6 "Baseball Boys Varsity" 1 6 "Multiple Pathways" "02M439" "Manhattan Village Academy" 2358 1 "Basketball Boys Varsity" 2 6 "Multiple Pathways" "02M439" "Manhattan Village Academy" 2358 3 "Basketball Girls Varsity" 3 6 "Multiple Pathways" "02M439" "Manhattan Village Academy" 2358 12 "Soccer Boys Varsity" 4 6 "Multiple Pathways" "02M439" "Manhattan Village Academy" 2358 21 "Soccer Girls Varsity" 5 6 "Multiple Pathways" "02M439" "Manhattan Village Academy" 2358 22 "Softball Girls Varsity" 6 6 "Multiple Pathways" "02M425" "Hs For Leadership & Public Service" 2370 1 "Basketball Boys Varsity" 1 3 "Multiple Pathways" "02M425" "Hs For Leadership & Public Service" 2370 3 "Basketball Girls Varsity" 2 3 "Multiple Pathways" "02M425" "Hs For Leadership & Public Service" 2370 22 "Softball Girls Varsity" 3 3 "Multiple Pathways" "02M407" "Institute For Collaborative Education" 2378 6 "Baseball Boys Varsity" 1 9 "Multiple Pathways" "02M407" "Institute For Collaborative Education" 2378 1 "Basketball Boys Varsity" 2 9 "Multiple Pathways" "02M407" "Institute For Collaborative Education" 2378 3 "Basketball Girls Varsity" 3 9 "Multiple Pathways" "02M407" "Institute For Collaborative Education" 2378 32 "Indoor Track Girls" 4 9 "Multiple Pathways" "02M407" "Institute For Collaborative Education" 2378 12 "Soccer Boys Varsity" 5 9 "Multiple Pathways" "02M407" "Institute For Collaborative Education" 2378 21 "Soccer Girls Varsity" 6 9 "Multiple Pathways" "02M407" "Institute For Collaborative Education" 2378 22 "Softball Girls Varsity" 7 9 "Multiple Pathways" "02M407" "Institute For Collaborative Education" 2378 65 "Table Tennis Boys Varsity" 8 9 "Multiple Pathways" "02M407" "Institute For Collaborative Education" 2378 26 "Volleyball Girls Varsity" 9 9 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 6 "Baseball Boys Varsity" 1 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 2 "Basketball Boys Jr. Varsity" 2 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 1 "Basketball Boys Varsity" 3 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 3 "Basketball Girls Varsity" 4 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 34 "Cross Country Girls" 5 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 61 "Flag Football Girls Varsity" 6 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 11 "Handball Boys Varsity" 7 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 20 "Handball Girls Varsity" 8 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 32 "Indoor Track Girls" 9 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 31 "Outdoor Track Girls" 10 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 12 "Soccer Boys Varsity" 11 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 21 "Soccer Girls Varsity" 12 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 22 "Softball Girls Varsity" 13 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 38 "Volleyball Girls Jr. Varsity" 14 15 "Multiple Pathways" "02M420" "Hs Health Profession/Human Services" 2380 26 "Volleyball Girls Varsity" 15 15 "Multiple Pathways" "02M413" "School Of The Future" 2436 6 "Baseball Boys Varsity" 1 10 "Multiple Pathways" "02M413" "School Of The Future" 2436 2 "Basketball Boys Jr. Varsity" 2 10 "Multiple Pathways" "02M413" "School Of The Future" 2436 1 "Basketball Boys Varsity" 3 10 "Multiple Pathways" "02M413" "School Of The Future" 2436 3 "Basketball Girls Varsity" 4 10 "Multiple Pathways" "02M413" "School Of The Future" 2436 20 "Handball Girls Varsity" 5 10 "Multiple Pathways" "02M413" "School Of The Future" 2436 12 "Soccer Boys Varsity" 6 10 "Multiple Pathways" end
Comment