topic Re: How to format macro parameter in SAS Enterprise Guide

How to format macro parameter

deleted_user — Mon, 16 Apr 2007 12:55:20 GMT

I am trying to format a macro call from within a datastep using the call execute statement. I have not figured out how to format the parameter.
The parameter needed is a list of quoted strings:
'0001','0002','0003','0004'

When I EXECUTE I get the following error:
ERROR: More positional parameters found than defined.

So apparently my list is being interpretted as 4 parameters rather than one.
How can I get this parameter to pass through OK?

my code:
CALL EXECUTE ( '%getInfo(' || cust_nbrs || ');');

Re: How to format macro parameter

deleted_user — Tue, 17 Apr 2007 18:20:13 GMT

Archie,

Your better off using Proc Sql for something like this.

Post more of your code and see if I can help you further.

Re: How to format macro parameter

deleted_user — Wed, 18 Apr 2007 12:03:38 GMT

Hi,

try this:
CALL EXECUTE ( '%getInfo(%quote(' || cust_nbrs || '))');

Hope this works.

Re: How to format macro parameter

deleted_user — Wed, 18 Apr 2007 13:07:45 GMT

No, that does nothing, I tried all the functions like that I could find. Only work around I could come up with is to create indexed global variables for each parameter string, and then call the macro with each global parameter after the data step is done. What a pain!!!

Re: How to format macro parameter

deleted_user — Wed, 18 Apr 2007 14:41:34 GMT

Oops....I spoke too soon....this actually does work !!!

Thank you for your thoughtfullness!!!