topic Scan or substr in SAS Programming

Scan or substr

sam1231 — Wed, 15 May 2019 15:00:31 GMT

hi,

I am trying to get below word from dataset value.

ert_demo.sas

demo.sas

v_demo.sas

How to scan 'demo' from all 3 with one code?

Re: Scan or substr

PaigeMiller — Wed, 15 May 2019 15:05:27 GMT

The FIND command will obtain the starting position of 'demo' in the character variable named TEXT

data want;
    set have;
    where = find(text,'demo');
run;

Re: Scan or substr

Kurt_Bremser — Wed, 15 May 2019 15:07:32 GMT

Double use of scan():

data have;
input longstr :$32.;
datalines;
ert_demo.sas
demo.sas
v_demo.sas
;

data want;
set have;
shortstr = scan(scan(longstr,1,'.'),-1,'_');
run;

proc print data=want noobs;
run;

Result:

longstr         shortstr

ert_demo.sas      demo  
demo.sas          demo  
v_demo.sas        demo