Substring with condition

[trungcva112]

Hi everyone,

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

Company	TIC
A	CAVR.1
B	CAB.3
C	4330B

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:

Company	TIC
A	CAVR
B	CAB
C	4330B

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

[SASKiwi · Accepted solution]

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

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

[PeterClemmensen]

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

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