topic Re: Help with Macro in SAS Programming

Help with Macro

Pritish — Thu, 03 Mar 2011 21:20:43 GMT

Hi,

Currently, I am having two proc sql statement where one get's the count of the data and the other sql query creates a new table based on that count. I am trying to create a macro as both the query as same but not able to figure how can I achieve both results?

Any suggestions would be highly appreciated.

Re: Help with Macro

SPR — Thu, 03 Mar 2011 21:42:44 GMT

Hello Pritish,

If you would like a detailed answer, please give an example of data, desired result and your code.

Sincerely,
SPR

Re: Help with Macro

Pritish — Thu, 03 Mar 2011 21:52:04 GMT

1.
proc sql;
select count (distinct emp) into: emp_cnt
from emp;
quit;

2.
proc sql;
create table emp_new as
select count (distinct emp) as emp_cnt
from emp;
quit;

I have this two queries. I want to avoid unnecessary code so trying to go for Macro. Message was edited by: Pritish

Re: Help with Macro

FriedEgg — Thu, 03 Mar 2011 21:55:25 GMT

I don't really see a macro being necessary to accomplish this task.

data emp_new;
set emp end=eof;
if eof=1 then do;
emp_cnt=_N_;
call symput('emp_cnt',emp_cnt);
keep emp_cnt;
output;
end;
run;

The above should create dataset emp_new containing one column (emp_cnt) and one row containing the count of rows in emp, while also putting the count into variable &emp_cnt. Above is untested but assumed to work. Message was edited by: mkastin