/* inspect the variable major .The variable major should contain only one major for ex:physics or science .some observations has two majors listed in this variable seperated by the word "and"(always in low case),such as maths and social . use the word and to identify the a second major and if founf put the second major in a new variable named second_major .when they are two majors the original major should be modified so that it contains only first major . What is the ffrequency of variable major*/ data subject; set subjects; if count(major,'and')>0 then do; major=tranwrd(major,'and','&'); end; if count(major,'&')>0 then second_major=scan(major,2,'&'); if count(major,'&')>0 or count(major,'&')=0 then major=scan(strip(major),1,'&'); run; proc freq data=subject; table major; run;
... View more