topic Re: Finding the last word in a string in SAS Programming

Finding the last word in a string

SASAna — Fri, 24 Jan 2020 21:34:04 GMT

Hi SAS users,

i need some help in going to last word which is after last slash (/) and get word "file" ( scan and find the first word after first underscore(_)

currently i am printing all words.

%let filenm=/path1/div1/test1/list1/file_client_case1;



data run_type;
length type $30;
do i=1 to countw("&filenm.","/");
type=scan("&filenm.",i,"/");
output;
end;
run;

Thanks,

Ana

Re: Finding the last word in a string

novinosrin — Fri, 24 Jan 2020 21:36:27 GMT


%let filenm=/path1/div1/test1/list1/file_client_case1;



data run_type;
length type $30;
type=scan(scan("&filenm.",-1,"/"),1,'_');
run;

Re: Finding the last word in a string

SASAna — Fri, 24 Jan 2020 21:43:09 GMT

Thanks for the help . It worked very well.