Macro

[deleted_user]

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

[SAS83]

t Message was edited by: Ravi Mantripragada

[SAS83]

%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;

[SAS83]

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;

[SAS83]

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

[deleted_user]

Ravi ,Thanks for your information !!!