How to get part of a string

[mauri0623]

Hello all.,

I have the following strings that I am only interested in getting the 20AL05, 20AL03, 20AL09.

AB290363, 20AL05

IA000074 20AL03

PIV#IA000080 20AL09

Please help me with what function and how I will be able to achieve this.

[novinosrin · Accepted solution]

Hi @mauri0623  Assuming I understand your Data structure/layout

data have;
input string $30.;
cards;
AB290363, 20AL05
IA000074 20AL03
PIV#IA000080 20AL09
;

data want;
set have;
want=scan(string,-1,', ');
run;

[andreas_lds]

Instead of telling scan to search from right to left by using a negative index, you could use the fourth parameter:

part = scan(string, 1, ', ', 'b');