Export - proc tabulate

[CMilena]

I want send proc tabulate result to excel.

Is it possible?

[art297]

Why not?  Take a look at http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html

for one possibility

[Ksharp]

Sure. ODS is helpful.

You should post it into ODS Forum, there is a SAS employee Cynthia@sas is a specialist about it.

Ksharp

[SAS_Niels]

Hey Milena,

I tried my best but I failed. :smileyconfused:

I would export the dataset by PROC EXPORT and build the table in EXCEL..

The simple export is:

DATA TEST;

    SET SASHELP:CLASS;

RUN;

PROC EXPORT DATA= TEST;

     OUTFILE ="YOUR PATH:::\TEST.XLS"

     DBMS = EXCEL REPLACE;

     SHEET = "EXPORT SAS TO EXCEL";

RUN;

Greetz Niels

[ballardw]

If you are wanting the tabular appearance one approach is to use the EXCELXP tagset.

ods tagsets.excelxp file='output path\your file name.xml' ;

<your proc tabulate code here>

ods tagsets.excelxp;

Then use EXCEL to open the resulting XML file.