topic Re: How to get part of a string in SAS Programming

How to get part of a string

mauri0623 — Thu, 10 Oct 2019 17:06:09 GMT

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 — Thu, 10 Oct 2019 17:10:54 GMT

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 — Fri, 11 Oct 2019 04:58:51 GMT

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');