Hi,
From the University table, I need to give score (0 or 1) for Teachers in different category/subcat of different subjects.
How can I transpose the data by adding three new columns (varible, category, subcategory) into the master sheet. The categorization data is available in ' lookup' table.
My desired output (added for one Teacher)
seq
Teacher
Surname
Email
Variable
Category
Subcategory
Trainer
Beginner
Medium
Expert
Mastery
1
Harish
KK
abc@gmail.com
English
Arts
Syllabus1
0
0
1
0
0
1
Harish
KK
abc@gmail.com
History
Arts
Syllabus1
1
0
0
0
0
1
Harish
KK
abc@gmail.com
Geography
Arts
Syllabus2
1
0
0
0
0
1
Harish
KK
abc@gmail.com
Math
Development
Syllabus3
0
1
0
0
0
1
Harish
KK
abc@gmail.com
Science
Development
Syllabus4
0
0
0
1
0
1
Harish
KK
abc@gmail.com
Economics
Emerging
Syllabus1
0
0
1
0
0
1
Harish
KK
abc@gmail.com
IT
Emerging
Syllabus2
1
0
0
0
0
1
Harish
KK
abc@gmail.com
Civics
Emerging
Syllabus3
0
0
0
0
1
1
Harish
KK
abc@gmail.com
Other
Emerging
Syllabus2
1
0
0
0
0
data University;
length Teacher $ 10 email $20;
input seq $ Teacher $ Surname $ Email $ English $ History $ Geography $ Math $ Science $ Economics $ IT $ Civics $ Other $;
cards;
1 Aristotle KK abc@gmail.com Medium Trainer Trainer Beginner Expert Medium Trainer Mastery Trainer
2 Vem KK1 abc@gmail.com Trainer Beginner Trainer Mastery Trainer Medium Medium Expert Beginner
3 Charm KK2 abc@gmail.com Medium Trainer Beginner Trainer Trainer Medium Trainer Trainer Trainer
4 Newton KK3 abc@gmail.com Trainer Beginner Beginner Mastery Trainer Medium Medium Trainer Trainer
5 Grammy KK4 abc@gmail.com Beginner Expert Trainer Expert Trainer Medium Trainer Expert Trainer
6 Rambo KK5 abc@gmail.com Trainer Beginner Trainer Trainer Trainer Trainer Trainer Trainer Mastery
7 Nikki KK6 abc@gmail.com Medium Medium Expert Expert Trainer Trainer Trainer Trainer Trainer
8 Leo KK7 abc@gmail.com Mastery Trainer Trainer Trainer Trainer Mastery Trainer Medium Trainer
9 Fishcer KK8 abc@gmail.com Trainer Trainer Trainer Trainer Trainer Expert Trainer Expert Trainer
;
run;
data lookup;
length variab $10 Category Sub_Category $20 ;
input variab $ Category $ Sub_Category $;
cards;
English Arts Syllabus1
History Arts Syllabus1
Geography Arts Syllabus2
Math Development Syllabus3
Science Development Syllabus4
Economics Emerging Syllabus1
IT Emerging Syllabus2
Civics Emerging Syllabus3
Other Emerging Syllabus2
;run;
proc sort data=university; by Teacher;run;
proc sort data=lookup;by variab;run;
... View more