topic Re: Macro in SAS Procedures

Macro

deleted_user — Tue, 01 Mar 2011 18:08:46 GMT

Hi Friends,

I am getting an error while substituting values to this macro code. Please let me the error in this code.

%macro cnt_inv(tbl=, vr=, st=, part= , ds=);
PROC SQL;
create table &tbl. as
select count(*) as &vr. from &ds.
where com in (&st.) and (&part.)
group by userid ;
quit;
%mend cnt_inv;

Thanks in Advance
Raj

Re: Macro

SAS83 — Tue, 01 Mar 2011 18:56:50 GMT

t Message was edited by: Ravi Mantripragada

Re: Macro

SAS83 — Tue, 01 Mar 2011 18:59:24 GMT

%macro cnt_inv(tbl=, vr=, st=, part= , ds=);
PROC SQL;
create table &tbl. as
select count(*) as &vr. from &ds.
where com in ( (&st.) , (&part.) )group by userid ;
quit;
%mend cnt_inv;

Re: Macro

SAS83 — Tue, 01 Mar 2011 19:00:42 GMT

OR this should do it.. I think this should work..

%macro cnt_inv(tbl=, vr=, st=, part= , ds=);
PROC SQL;
create table &tbl. as
select count(*) as &vr. from &ds.
where com in (&st. , &part.)
group by userid ;
quit;
%mend cnt_inv;

Re: Macro

SAS83 — Tue, 01 Mar 2011 19:04:12 GMT

There should not be any period after the name of the macro..

like &UID not &UID.

Where you need to use period after &CUT in the below example.

C:\ ...\&CUT..xls

Re: Macro

deleted_user — Tue, 01 Mar 2011 19:25:20 GMT

Ravi ,Thanks for your information !!!