No idea how your code relates to your question, here's how I'd do it.
ods excel file="/folders/myfolders/demo.xlsx" style=meadow;
proc tabulate data=sashelp.stocks;
class stock date;
format date yyq6.;
var open;
table date*stock, open*MIN open*MAX;
run;
ods excel close;
@SM8 wrote:
So, I'm looking to do a summary of a dataset using proc tabulate to get totals for the visitcount and payment variables for each quarter. I also want it so that my output is sent directly to excel. How can I do this?
proc sql;
create table statesums as
select count(pkey) as visitcount, state,
date, code, sum(dis) as payment
from medcla
where state in ('NY','PA','NJ')
group by state, date, code;
quit;
proc sort data = statesums;
by state code; run;
proc transpose data = statesums out=visits prefix=visitcount;
var visitcount; id date; by =state hcpcs;
run;
proc transpose data = statesums out=payments prefix=dollars;
var payment; id date; by state code;
run;
proc sql;
create table totals as
select * from vists as x left join payments as y
on x.state = y.state
and x.code = y.code;
quit;
... View more