Output Table organized by groups and changing order of variables based on ranking system

[Beth Unger CCCC]

Good morning,

About the data (dataex below)

1. There are multiple schools
2. And there may be more than one program associated with each school followed by the courses in each program
3. Depending the type of occupation which connects to the programs, determines the order of the variables (thinkpercent, interactercomputer, etc)

My goal:
To produce a table for each of the school's programs, listing the courses in the program in the first column followed by the correct order for the other variables (thinkpercent, interactercomputer, etc) which are ranked according to program/occupation

Data Example:
1. Lines 1/50 of data set. Note: It does not include the key that shows the order depending on the type of program.
2. I created a key that presents the list the order of the variables (thinkpercent, interactercomputer, etc) according to program and occupation. It is attached as a csv file.
a. There is an indicator variable, Omitted,. I must know which variables were omitted.

I produced a generic table as a guide. It too is attached as example.

* Example generated by -dataex-. For more info, type help dataex
clear
input byte SchoolCode str8 CourseCode byte prog_num str57 CourseLabel long CourseCodeNum float(thinkpercent interactcomputepercent neworganizeplanpercent)
1 "ENT260"  1 "ENT260 Industrial Control Systems"                       69  46.66667         .        .
1 "ENT185"  1 "ENT 185 Engineering Computer Applications"               64         . 23.076923        .
1 "ENT238"  1 "ENT 238 Elements of Machines"                            67         .         .        .
1 "ENT244"  1 "ENT 244 Hydraulics and Pneumatics"                       68 26.666666         .        .
1 "ENT235"  1 "Microprocessors and Digital Circuits"                    66         .         .        .
1 "ENT225"  1 "ENT225 Introduction to Computer Aided Manufacturing"     65         .         .        .
1 "ENT151"  1 "ENT151 Introduction to Manufacturing"                   62         .         .        .
1 "ENT122"  1 "ENT122 Computer Aided Drafting/Design I"                 60         .         .        .
1 "ENT152"  1 "ENT152 Advanced Manufacturing"                           63         .         .        .
1 "ENT129"  1 "ENT129 Introduction to Electricity and Electronics"      61         .         .        .
1 "ENT152"  2 "ENT152 Advanced Manufacturing"                           63         .         .        .
1 "ENT235"  2 "Microprocessors and Digital Circuits"                    66         .         .        .
1 "ENT129"  2 "ENT129 Introduction to Electricity and Electronics"      61         .         .        .
1 "ENT244"  2 "ENT 244 Hydraulics and Pneumatics"                       68 26.666666         .        .
1 "ENT225"  2 "ENT225 Introduction to Computer Aided Manufacturing"     65         .         .        .
1 "ENT238"  2 "ENT 238 Elements of Machines"                            67         .         .        .
1 "ENT260"  2 "ENT260 Industrial Control Systems"                       69  46.66667         .        .
1 "ENT151"  2 "ENT151 Introduction to Manufacturing"                   62         .         .        .
1 "ENT122"  2 "ENT122 Computer Aided Drafting/Design I"                 60         .         .        .
1 "ENT185"  2 "ENT 185 Engineering Computer Applications"               64         . 23.076923        .
2 "EGR211"  1 "EGR 211 Programmable Control Systems"                  31         .        50        .
2 "EGR103"  1 "EGR 103 Computer Skills for Engineers and Technicians" 24        50         .        .
2 "EGR151"  2 "EGR151 Electrical Machinery"                            29  42.85714         .        .
2 "EGR211"  2 "EGR 211 Programmable Control Systems"                  31         .        50        .
2 "EGR113"  2 "EGR 113 Introduction to Robotics"                      27 33.333332         .        .
2 "EGR211"  5 "EGR 211 Programmable Control Systems"                  31         .        50        .
2 "EGR103"  5 "EGR 103 Computer Skills for Engineers and Technicians" 24        50         .        .
2 "EGR111"  7 "EGR 111 Fundamentals of Manual Machining"              25 20.833334         .        .
2 "CAD112"  7 "CAD 112 Advanced Mechanical Design with Solidworks"     7  46.15385  7.692307        .
2 "EGR299"  7 "EGR 299 Engineering Projects"                          33  23.52941         .        .
2 "EGR113"  7 "EGR 113 Introduction to Robotics"                      27 33.333332         .        .
2 "EGR172"  7 "EGR 172 Material Science"                              30  22.72727         .        .
2 "EGR215"  7 "EGR 215 Lean Six Sigma"                                32        10         .        .
2 "CAD211"  7 "CAD 211 Computer Aided Manufacturing"                  14  6.060606  6.060606 6.060606
2 "EGR151"  7 "EGR151 Electrical Machinery"                            29  42.85714         .        .
2 "EGR103"  7 "EGR 103 Computer Skills for Engineers and Technicians" 24        50         .        .
2 "CAD111"  7 "CAD 111 Mechanical Design with Solidworks"              6  54.54546  9.090909        .
2 "EGR115"  7 "EGR 115 Manufacturing Processes & Measurement"         28         .         .        .
2 "EGR211"  7 "EGR 211 Programmable Control Systems"                  31         .        50        .
2 "EGR112"  7 "EGR 112 Automated Machining"                           26  8.571428  2.857143 5.714286
2 "EGR103"  9 "EGR 103 Computer Skills for Engineers and Technicians" 24        50         .        .
2 "EGR151"  9 "EGR151 Electrical Machinery"                            29  42.85714         .        .
2 "CAD111"  9 "CAD 111 Mechanical Design with Solidworks"              6  54.54546  9.090909        .
2 "EGR172"  9 "EGR 172 Material Science"                              30  22.72727         .        .
2 "CAD112" 12 "CAD 112 Advanced Mechanical Design with Solidworks"     7  46.15385  7.692307        .
2 "EGR111" 12 "EGR 111 Fundamentals of Manual Machining"              25 20.833334         .        .
2 "CAD111" 12 "CAD 111 Mechanical Design with Solidworks"              6  54.54546  9.090909        .
2 "CAD211" 12 "CAD 211 Computer Aided Manufacturing"                  14  6.060606  6.060606 6.060606
2 "EGR112" 12 "EGR 112 Automated Machining"                           26  8.571428  2.857143 5.714286
2 "EGR172" 12 "EGR 172 Material Science"                              30  22.72727         .        .
end
label values SchoolCode school_code_label2
label def school_code_label2 1 "Berkshire", modify
label def school_code_label2 2 "Bristol", modify
label values prog_num program_code_label
label def program_code_label 1 "Mechatronics and Robotics AS", modify
label def program_code_label 2 "Mechatronics and Robotics Cert.", modify
label def program_code_label 5 "Electrical & Computer Eng. AS", modify
label def program_code_label 7 "Biomedical AS", modify
label def program_code_label 9 "Mechanical AS", modify
label def program_code_label 12 "Eng. Design Cert.", modify
label values CourseCodeNum CourseCodeNum
label def CourseCodeNum 6 "CAD111", modify
label def CourseCodeNum 7 "CAD112", modify
label def CourseCodeNum 14 "CAD211", modify
label def CourseCodeNum 24 "EGR103", modify
label def CourseCodeNum 25 "EGR111", modify
label def CourseCodeNum 26 "EGR112", modify
label def CourseCodeNum 27 "EGR113", modify
label def CourseCodeNum 28 "EGR115", modify
label def CourseCodeNum 29 "EGR151", modify
label def CourseCodeNum 30 "EGR172", modify
label def CourseCodeNum 31 "EGR211", modify
label def CourseCodeNum 32 "EGR215", modify
label def CourseCodeNum 33 "EGR299", modify
label def CourseCodeNum 60 "ENT122", modify
label def CourseCodeNum 61 "ENT129", modify
label def CourseCodeNum 62 "ENT151", modify
label def CourseCodeNum 63 "ENT152", modify
label def CourseCodeNum 64 "ENT185", modify
label def CourseCodeNum 65 "ENT225", modify
label def CourseCodeNum 66 "ENT235", modify
label def CourseCodeNum 67 "ENT238", modify
label def CourseCodeNum 68 "ENT244", modify
label def CourseCodeNum 69 "ENT260", modify

Thanks in advance,
Beth from 4Cs