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
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
Hi,
Thank you!!!
I was not able to remember this.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.