topic Re: Storing my project name from my project path into a macro variable in SAS Enterprise Guide

Storing my project name from my project path into a macro variable

ctisseuil — Wed, 24 Mar 2021 10:05:56 GMT

Hi,

I'd like to store the project name from my project path into a macro variable...

For example, let say my path is '/myprojectpath/filename'. I want to store the macro variable 'filename'.

Here is the macro that I have started to develop, without success :

%macro prgname;
%let s = &_CLIENTPROJECTPATH.;
%let delims = '\';
%let n = %sysfunc(countw(&s, &delims));
%let words = %sysfunc(scan(&s, 1:&n, &delims));
%mend prgname;

Could you highlight me ?

Thanks for your attention.

Clément

Re: Storing my project name from my project path into a macro variable

ctisseuil — Wed, 24 Mar 2021 10:38:01 GMT

Ok,

I think I have a better code than the previous one but still does not work...

%let fname = %sysfunc(scan(&_CLIENTPROJECTPATH,-1,"\"));
%put &fname;

Any ideas ?

Re: Storing my project name from my project path into a macro variable

andreas_lds — Wed, 24 Mar 2021 10:39:05 GMT

The scan function has an option to start searching from the end of the string, called "B". Or you could use a negative number as second argument, so something like

%let cpp = %sysfunc(dequote(&_ClientProjectPath));
%let words = %sysfunc(scan(&cpp, -1, %str(\)));

should work.

Re: Storing my project name from my project path into a macro variable

ctisseuil — Wed, 24 Mar 2021 10:58:07 GMT

Thank you Andreas,

It works perfectly !

Re: Storing my project name from my project path into a macro variable

PhilC — Wed, 24 Mar 2021 12:36:52 GMT

%let name=%sysfunc(tranwrd(&_CLIENTPROJECTNAME,&_CLIENTPROJECTPATH,));