topic Export - proc tabulate in SAS Procedures

Export - proc tabulate

CMilena — Thu, 20 Oct 2011 12:52:10 GMT

I want send proc tabulate result to excel.

Is it possible?

art297 — Thu, 20 Oct 2011 14:00:15 GMT

for one possibility

Ksharp — Fri, 21 Oct 2011 02:20:59 GMT

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 — Fri, 21 Oct 2011 13:34:17 GMT

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 — Fri, 21 Oct 2011 20:12:51 GMT

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' ;

ods tagsets.excelxp;

Then use EXCEL to open the resulting XML file.