×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Export summary tables to excel

Export summary tables to excel

Export summary tables to excel

(OP)
Hi,

I've created several summary tables in SAS Enterprise Guide 4.2 and want to export all of the tables to Excel 2003. Is there a way to do this? I can export to HTML and open it with Excel, but I was hoping to simply run the process flow and automatically export into Excel. The only export file types I can export to are HTML, XML and PDF. Is this possible?

RE: Export summary tables to excel

Try XML, that might work, Excel can read XML.
What is SAS actually running on?  Are you remote submitting code to a Unix system via EG?   You should just be able to right click on the data, select "Send To" and then "Microsoft Excel".   If you can't do that, then it's likely your SAS Server doesn't have that module installed (likely it's a Unix server).
In that case, I recommend using a tagset and proc print.

CODE

ods tagsets.excelxp file="P:\blah.xls"
    options(absolute_column_width='10,10,10,10,8,8,8,8,8,8,8,8,8,8'
            row_repeat='header'
            embedded_titles='yes'
            frozen_headers='yes'
            scale='100'
            orientation='landscape'
            sheet_name='Report'
           )
   style=styles.psexcel;

proc print data=dset noobs;
run;


ods tagsets.excelxp close;
This should work regardless of what your server platform is, so long as you're running SAS 9.1 or above.
Lower than that, you'll have to just output to a CSV file or something.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close