topic Re: How to pass account numbers through SAS Macro in New SAS User

How to pass account numbers through SAS Macro

Ajitesh — Fri, 22 Nov 2019 18:54:50 GMT

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;

Re: How to pass account numbers through SAS Macro

PaigeMiller — Fri, 22 Nov 2019 19:38:24 GMT

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.

Re: How to pass account numbers through SAS Macro

Ajitesh — Sat, 23 Nov 2019 04:56:19 GMT

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.

Re: How to pass account numbers through SAS Macro

PaigeMiller — Sat, 23 Nov 2019 11:58:43 GMT

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?

Re: How to pass account numbers through SAS Macro

Tom — Sat, 23 Nov 2019 17:53:06 GMT

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?