02-17-2017 11:11 PM
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.
For no i used Substring function (SUBSTR(t1.ACAD_PROGRAM,1,4) but it extracts first 4 characters and gives following output
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
Any help is greatly appreciated.
02-18-2017 10:31 AM
Yes, you can use that function in EG.
The method is to use the query builder, and create a new advanced expression. You can then put the function into the expression.