Help using Base SAS procedures

Writing Output To Excel With Formulas

Reply
Contributor
Posts: 24

Writing Output To Excel With Formulas

We have a bunch of EG SAS jobs that write out *.csv files, no problem there.

We are now looking to write the output into an existing blank (template) *.xls sheets.

The xls sheet has a lot of formula's within it, we can not seem to write the data into a cell and retain the formula.

Any ideas?

SAS Enterprise Guide 4.1 (4.1.0.1019)

AIX UNIX

TIA

Jay

Trusted Advisor
Posts: 1,300

Writing Output To Excel With Formulas

Are you using 32-bit or 64-bit version of AIX?

Contributor
Posts: 24

Writing Output To Excel With Formulas

64

Trusted Advisor
Posts: 1,300

Re: Writing Output To Excel With Formulas

I would look into proc template and ods tagsets to create an html document for excel to read.

http://support.sas.com/rnd/base/ods/excel/index.html

Ask a Question
Discussion stats
  • 3 replies
  • 125 views
  • 0 likes
  • 2 in conversation