remove characters!

[vxhong17]

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

[LinusH]

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.

[VarunIyer]

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

[pradeepalankar · Accepted solution]

Hi,

you can try this:

data test;

input Name $20.;

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

cards;

ABB3 (1942)

A12

A1E (2001)

AM2E (2012)

;

run;

[vxhong17]

Hi pradeepalankar, LinusH, and Varunlyer,

Thank you for your help!