BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
devarayalu
Fluorite | Level 6

Can any one help me here?

%macro one;

%if %index("devara", "deva")  %then %put exists;

%mend;

%one;

Thank you in advance

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

Also confusing the rules for strings between macro and datastep code.

Try using this line:

 

%if %index(devara, deva) %then %put exists

Macro literals do not need quotes to delimit but data step string literals do. Since macro variables would be reference by &var then without the & the macro processor treats what follows as string literal.

And you original code failed because "deva" did not occur within the source string.

View solution in original post

2 REPLIES 2
Jagadishkatam
Amethyst | Level 16

the above macro is working, however since the index function is unable to find the text "deva" including the quotes in "devara" it is not displaying anything in the log. Please try the below code and check the log you will find not exists in the log.

%macro one;

%if %index("devara", "deva")  %then %put exists;

%else %put not exists;

%mend;

%one;

Thanks,
Jag
ballardw
Super User

Also confusing the rules for strings between macro and datastep code.

Try using this line:

 

%if %index(devara, deva) %then %put exists

Macro literals do not need quotes to delimit but data step string literals do. Since macro variables would be reference by &var then without the & the macro processor treats what follows as string literal.

And you original code failed because "deva" did not occur within the source string.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 954 views
  • 0 likes
  • 3 in conversation