How to pass account numbers through SAS Macro

[Ajitesh]

Hi,

I have 10000 account numbers and i just want to pass all the account numbers one by one through SAS Macro.  I am using this query-

proc sql;

create table abc

select * from xyz where account in (want to pass accounts through SAS Macro);

quit;

[PaigeMiller]

Assuming the account numbers are in a SAS data set which I will name HAVE, and the variable is named ACCOUNTID

proc sql;
create table abc
select * from xyz where account in (select distinct accountid from have);
quit;

No macro needed.

[Ajitesh]

Thanks for your reply but you did not understand my question. I want to create macro and want to pass all the accounts through macro. And i know proc sql query.

[PaigeMiller]

So please provide a little more information ... what is this macro supposed to do? Can you show, as an example, non-macro code that works for one account number?

[Tom]

This sounds like an XY problem. http://xyproblem.info/

Please explain what you are trying to do (the larger picture). Explain in more detail what do you want this macro to do? How does being able to do that help with the larger problem?