Need to extract a char between special char from a string

[santosh_pat69]

Hi Experts,

I am trying to extract the list of SAS program names from a dataset, i have hundreds of them and the special chars are present at

for example

/xxxx/abcde/abcdefgh.sas

/xxxx/abcde/lkml/abcdefguh.sas

/xxxx/abcde/lkml555/abguh.sas

I am trying to get the output as

abcdefgh.sas

abcdefguh.sas

abguh.sas

[BrunoMueller]

Hi

The SCAN function can help you with that, see example below.

data want;
  infile cards;
  input
    pgmname : $256.
  ;
  justPgm = scan(pgmname, -1, "/");
cards;
/xxxx/abcde/abcdefgh.sas
/xxxx/abcde/lkml/abcdefguh.sas

/xxxx/abcde/lkml555/abguh.sas
;

check the doc for more details.

Bruno

[santosh_pat69 · Accepted solution]

Hi,

Thank you!!!

I was not able to remember this.