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

Hi, I want to find non missing value between col id1 and id2 and then place it in variable x like below. Is there any alternative function to solve this if more variables are there.   data new; input id1 id2 $; cards; 1 11 2 . . 3 . . . abc 7 . ; run; data new1; set new; if id1 eq . then x=id2; else if id1 ne . then x=id1; else x=.; run; ... View more

In my dataset, I want to display those records containing special character.Also  a column should be added containing the list of spl char. e.g. data have;    input id string :$100.;    cards; 1 Asthma!I 2 Anaphylexia@#T 3 The Government has called for the immediate release of an Irishman $$$1O 4 He is suffereinΣg from Jaund■ce 5 Film¶city looks go§d 6 The IÉnternational @l¥mpic Committee has moved to cÄlm fears 7 IV.D10W250 8 I fell in river 9 Singapore will add two new subway lines and expand three existing lines Output should be like this ID     string                                  specialchar 1     Asthma!I                                     ! 2    Anaphylexia@#T                         @# etc... ... View more

Hello !! I want to retrieve null date from a table but getting below error. Date retrieval will be null or in '00-___-0000' format (dd-mon-yyyy) proc sql; select date from tablex where (date is null or date like '00-___-0000') ; quit; Error in log---Invalid date/time/datetime constant '00-___-0000'd. Can anyone help me. Advance thanks ... View more