Thanks a bunch for this code. It seems to be working, but not quite there. I ran it with my data and it's still throwing out people. I think maybe it's because there are BFA, BMU type of degrees also. Here I have attached the data I have, you can take a look what I mean. If you can help me to the end I'll appreciate it eternally. This is really some important to what i'm doing. For the list of majors, I simply did a proc freq(or Proc SQL) to see a list of all majors and then pasted to your datalines step, after removing the suffix of BA, BS, BMU... etc.
... View more