topic Re: Help needed in SAS Data Management

Keep only alphanumeric characters from character string

Ela_84 — Mon, 30 Jul 2018 09:44:53 GMT

Hi there,

I have a simple query i want to execute and I'm finding it hard, as I'm new to this.

I have a list off "Agreement" numbers but they have character and numeric values and I just want to extract the characters into a new column.

Example of "Agreement" number:

BAU123455L - I only need BAU

below is the code I used but getting no results.

if substr(left(Agreement),3) = 'BRN'

Re: Help needed

RW9 — Mon, 30 Jul 2018 09:43:10 GMT

Something like:

want=compress(agreement,"","ka");

You can find details of the options k and a in the documentation:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212246.htm

Re: Keep only alphanumeric characters from character string

smicha — Mon, 30 Jul 2018 09:49:48 GMT

Just define a new variable with the function you are using. Check the example below.

data test;
	agreement = '  BAU123455L';
	newcol = substr(left(agreement),1,3);
run;

Re: Help needed

Ela_84 — Mon, 30 Jul 2018 09:51:44 GMT

Hi RW9,

Thank you for your quick response - it works but I only want the first 3 characters - this is bring the letter at the end as well and I just need the first 3 characters?

Re: Help needed

RW9 — Mon, 30 Jul 2018 09:56:08 GMT

For future note, good idea to post test data (form of a datastep) and required output, so we can see input and output. Something like:

want=substr(compress(agreement,"","ka"),1,3);

Should work.

Re: Help needed

Ela_84 — Mon, 30 Jul 2018 09:59:41 GMT

Thank you so much RW9.

This has helped, in future I will share more info. this was my first time I submitted a question and you guys are very helpful.

Thank you again.

Re: Help needed

TomKari — Mon, 30 Jul 2018 14:18:29 GMT

Glad you got a good answer! Another suggestion...in the future, give your post a meaningful title, something like what RW9 edited it to. It makes it easer to decide whether to take a look at it or not.

Tom