macro parameter

[lc7033907]

Thank you, Tom. Now I am much clearer about these macro functions. Really appreciate. 

[ballardw]

Why your attempt doesn't work:

When you have this

proc print data=admit;
   where name  in ("&name");
run;

And name is

Murry. W, Almers. C

Then the Proc print resolves to

proc print data=admit;
   where name  in ("Murry. W, Almers. C");
run;

Which is not the same as the code that executes because each separate value in the IN comparison needs to be separately quoted.

[lc7033907]

Yes, you are right, ballardw. Actually I realized this point, but I don't know how to correct it, I mean how to use a macro to solve this problem. Now I got ideas from this post, thanks.