Help using Base SAS procedures

Export - proc tabulate

Reply
Occasional Contributor
Posts: 7

Export - proc tabulate

I want send proc tabulate result to excel.

Is it possible?

PROC Star
Posts: 7,363

Export - proc tabulate

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

for one possibility

Super User
Posts: 9,681

Export - proc tabulate

Sure. ODS is helpful.

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

Ksharp

Occasional Contributor
Posts: 6

Export - proc tabulate

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

Super User
Posts: 10,500

Export - proc tabulate

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.

Ask a Question
Discussion stats
  • 4 replies
  • 6158 views
  • 0 likes
  • 5 in conversation