topic Re: Extract Characters from Column in SAS Enterprise Guide

Extract Characters from Column

sushil540 — Sat, 18 Feb 2017 04:11:08 GMT

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

Miracle — Sat, 18 Feb 2017 04:39:58 GMT

I don't use EG and I wonder if major=scan(Acadmic_Program,1); will work in EG.

TomKari — Sat, 18 Feb 2017 15:31:43 GMT

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.

sushil540 — Tue, 21 Feb 2017 16:02:39 GMT

Thank you. It worked