topic Re: How to remove words after '\' in a string? in SAS Programming

How to remove words after '\' in a string?

vicky07 — Fri, 27 Apr 2018 03:07:48 GMT

Hello,

I have a macro variable something like below and i want to remove the string after the last '\'. and store the output in macro

%let path = D:\input\sas\files\today\chart_data*.sas7bdat;

Expected output is:

D:\input\sas\files\today\

Basically i want to remove all the words after the last '\'. Can someone please help me to get the desired output? Thanks.

Re: How to remove words after '\' in a string?

LinusH — Fri, 27 Apr 2018 03:52:22 GMT

Take a look at the findc() and %substr() functions.

Re: How to remove words after '\' in a string?

novinosrin — Fri, 27 Apr 2018 03:53:10 GMT

One easy and lazy way:

%let path = D:\input\sas\files\today\chart_data*.sas7bdat;

data _null_;
k="&path";
call scan(k, -1, position, length,'\');
substr(k,position,length)=' ';
call symputx('path',k);
run;

%put &path;

However, I challenge you to accomplish the same with %syscall with call scan in open code or rxchange

Re: How to remove words after '\' in a string?

RW9 — Fri, 27 Apr 2018 08:05:41 GMT

You could double reverse it:

data want;
  pth=reverse(scan(reverse("&path."),1,"\"));
run;

Basically reverse the string, scna off the first block based on \ delimiter, then reverse the result.

Re: How to remove words after '\' in a string?

Ksharp — Fri, 27 Apr 2018 13:12:25 GMT

%let path = D:\input\sas\files\today\chart_data*.sas7bdat;
%let want=%sysfunc(prxchange(s/[^\\\/]+$//,1,&path));

%put &want;

Re: How to remove words after '\' in a string?

vicky07 — Fri, 27 Apr 2018 13:24:54 GMT

It worked. Thank You!

Re: How to remove words after '\' in a string?

vicky07 — Fri, 27 Apr 2018 13:25:35 GMT

Got it, Thank You!

Re: How to remove words after '\' in a string?

vicky07 — Fri, 27 Apr 2018 13:26:21 GMT

I will give it a try with %syscall, thank you!