exporting data to excel

2

Hello. iam using ods tagsets.excelxp to export my data to excel. I am getting the excel tables but however they are empty. If i try the html format they work out okay. Would anyone know why ? How can i solve this ? Thank you

Simba Takuva, Epidemiologist, Clinical HIV Research Unit

asked 20 Jun '11, 10:56

Simba%20Takuva's gravatar image

Simba Takuva
21●2
accept rate: 0%

One Answer:
oldestnewestmost voted
1

Does this syntax work for you?:

ods tagsets.ExcelXP file="c:\\MyExcelFile.xml" style=minimal;
title;
proc print data=sashelp.class;
run;
ods tagsets.ExcelXP close;
link

answered 26 Jul '11, 17:26

MarkLamias's gravatar image

MarkLamias ♦
838●1●13
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

learn more about Markdown

Tags:

×21

Asked: 20 Jun '11, 10:56

Seen: 1,319 times

Last updated: 26 Jul '11, 17:26

Related questions

Suppressing results output with proc print and ODS

Creating multiple output files from PROC REPORT

Outputting Base SAS to PMML

Using ODS to write to network path

GLMSELECT: Table behind the Coefficient ProgressionCHart PLOT(COEFFICIENTS)

Inserting and scaling images using ODS PDF

How to disable HTML help server in SAS 9.3?

Making some independent comments in ODS output?

ODS Excel Xp Formatting issues

How to stop SAS from trying to (physically) print my graph?

about | faq | privacy | contact

powered by OSQA