Scan or substr

[sam1231]

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?       

[PaigeMiller]

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;

[Kurt_Bremser · Accepted solution]

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