Hello, I am trying to extract Characters (Major) from a Field (Acadmic Program) Example Below is Acadmic_Program that has Major and Degree. I am tryint to create a computed column in SAS enterprise Guide to extract the Majors. ENGL.AA MATH.AS PSY.AAS For no i used Substring function (SUBSTR(t1.ACAD_PROGRAM,1,4) but it extracts first 4 characters and gives following output ENGL MATH PSY. How do i elimate the Period. I tried find function like in excel but it doesnt seem to work the same way My output should be ENGL MATH PSY Any help is greatly appreciated. Thank you
... View more