Your SAS programs, embedded in web apps and elsewhere

locating a string in a string in an SP

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 84
Accepted Solution

locating a string in a string in an SP

I tried this 

 

 

%macro getserver;

  %LET x=index(&_srvname, "uview");

 %IF x > 0 %THEN %LET server=https://&_srvname&_url; %ELSE %LET server=http://&_srvname:&_srvport&_url;

%mend;

 

 

x seems to evaluate to "index(sas2.domain.com,"uview");" how would I get it to evaluate to a numeric value


Accepted Solutions
Solution
‎05-03-2017 10:23 AM
SAS Super FREQ
Posts: 709

Re: locating a string in a string in an SP

Since you are using the macro language you also have to use macro functions like %INDEX

 

Please note, that in the macro language you do not need the quotes around text. So your example would look like:

%LET x = %index(&_srvname, uview);

Bruno

View solution in original post


All Replies
Solution
‎05-03-2017 10:23 AM
SAS Super FREQ
Posts: 709

Re: locating a string in a string in an SP

Since you are using the macro language you also have to use macro functions like %INDEX

 

Please note, that in the macro language you do not need the quotes around text. So your example would look like:

%LET x = %index(&_srvname, uview);

Bruno

Super User
Posts: 5,516

Re: locating a string in a string in an SP

Building upon what Bruno has mentioned ...

 

Once you follow his advice, you would need to change the way you refer to the macro variable X by adding an ampersand:

 

%if &X > 0 %then ...

 

Alternatively, just get rid of X entirely:

 

%if %index(&_srvname, uview) > 0 %then ...

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 283 views
  • 1 like
  • 3 in conversation