topic Substring with condition in SAS Programming

Substring with condition

trungcva112 — Sat, 30 Dec 2017 01:56:33 GMT

Hi everyone,

I have the following data with company name and TIC code.

Now with TIC code that have character '.' , I would like to extract only characters before the '.'

For example, TIC code CAVR.1 will be sub-stringed to CAVR

The output looks like this:

Can anyone help me with this, please? Any idea would be much appreciated

SASKiwi — Sat, 30 Dec 2017 02:17:56 GMT

TIC = scan(TIC, 1, '.');

The SCAN function gets the first word in the string where the word boundary is a dot.

PeterClemmensen — Sat, 30 Dec 2017 20:51:07 GMT

data have;
input Company$ TIC$;
datalines;
A	CAVR.1
B	CAB.3
C	4330B
;

data want;
   set have;
   tic=scan(TIC, 1, '.');
run;