topic Need to extract a char between special char from a string in SAS Programming

Need to extract a char between special char from a string

santosh_pat69 — Fri, 03 Jun 2016 16:03:56 GMT

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

Re: Need to extract a char between special char from a string

BrunoMueller — Fri, 03 Jun 2016 16:43:18 GMT

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

Re: Need to extract a char between special char from a string

santosh_pat69 — Fri, 03 Jun 2016 18:19:46 GMT

Hi,

Thank you!!!

I was not able to remember this.