Help using Base SAS procedures

Proc Export to Excel

Reply
Regular Contributor
Regular Contributor
Posts: 238

Proc Export to Excel

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:

TABLE_TYPE__FREQ_CLMCNT
0407091.263942
CARDIAC-1B1109531.134481
CARDIAC-OTHR15211.007813
NEURO133341.083993
ORTHO-OTHR14821.021739
ORTHO/JOINT1169471.395098
ORTHO/SPINE184721.271688

Help?

Trusted Advisor
Posts: 2,115

Re: Proc Export to Excel

Your output statement should be more specific

output out=summary sum=Sum;

Ask a Question
Discussion stats
  • 1 reply
  • 130 views
  • 0 likes
  • 2 in conversation