Proc Export to Excel

tmm — Mon, 18 Feb 2013 22:49:12 GMT

I have a proc means statement that is coded like this:

proc means sum data = final missing;

class table;

var claim;

run;

I am trying to export the results to Excel and I changed it to:

proc means sum data = final noprint;

class table;

var claim;

output out=summary;

run;

proc export data = summary replace;

dbms=excel;

outfile=&output;

sheet=summary;

It does process the export but it does not process what is actually the means. It should export the following:

The SAS System 17:44 Monday, February 18, 2013 1

The MEANS Procedure

Analysis Variable : Claims

TABLE N Obs Sum

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

24680 14096.00

CARDIAC-1B 10953 5998.00

CARDIAC-OTHR 521 258.0000000

NEURO 3334 1781.00

ORTHO-OTHR 482 235.0000000

ORTHO/JOINT 16947 11384.00

ORTHO/SPINE 8472 5116.00

ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ

But it is the export looks like this:

Help?

Re: Proc Export to Excel

Doc_Duke — Tue, 19 Feb 2013 01:13:06 GMT

Your output statement should be more specific

output out=summary sum=Sum;