topic remove characters! in SAS Programming

remove characters!

vxhong17 — Fri, 17 Jan 2014 10:14:54 GMT

Hi Everyone,

I have one variable with the year. I want to remove the year. Could you let me know how to do so? Thank you!

For example,

Name

ABB3 (1942)

A12

A1E (2001)

AM2E (2012)

I want to have:

Name

ABB3

A12

A1E

AM2E

Re: remove characters!

LinusH — Fri, 17 Jan 2014 10:54:18 GMT

There is a bunch of character string function that you can exploit, such as substr, findc...

This must be one of the most common topics (beside date handling), a lot of examples are available on these forums, and support.sas.com.

Re: remove characters!

VarunIyer — Fri, 17 Jan 2014 11:07:08 GMT

Look at the Scan function to get all the characters before the bracket "(".

Re: remove characters!

pradeepalankar — Fri, 17 Jan 2014 11:11:04 GMT

Hi,

you can try this:

data test;

input Name $20.;

name=scan(name,1,'(');

cards;

ABB3 (1942)

A12

A1E (2001)

AM2E (2012)

;

run;

Re: remove characters!

vxhong17 — Sun, 19 Jan 2014 22:13:07 GMT

Hi pradeepalankar, LinusH, and Varunlyer,

Thank you for your help!