The SAS Output Delivery System and reporting techniques

Excel Reports

Reply
Regular Contributor
Posts: 155

Excel Reports

Hi All,

In our company we create PDF reports.The client requires to Create Excel reports as well.We have only Base sas installed in our prod.Scheduler runs our jobs and our FTP job will ftp them from unix box to another server.

Just want to make sure there is no other way other than generating excel report through making code changes to current code to use ods tagsets.EXCELXP?

Is there any tool they can use which can take PDF's and automatically create Excel?

As far as i know it's not possible.Correct me if am wrong.

Regular Contributor
Posts: 244

Re: Excel Reports

It's sort-of-theoretically possible via 3rd party tools, but probably not a good idea for a large production job. For example, Adobe offers Convert PDF to Excel, PDF to XLSX converter | Adobe Acrobat XI   , and others offer free and paid versions of the same thing. 

ODS TAGSETS.EXCELXP is probably your best bet (though be aware those don't produce files that are truly '.xlsx' (or '.xls') files - if that's an issue for your client you will need to load them in excel and 'save as' xls/x).

In 9.4m2 they will be releasing ODS EXCEL which is largely superior (in particular, it generates an actual xlsx-formatted file).

Ask a Question
Discussion stats
  • 1 reply
  • 333 views
  • 0 likes
  • 2 in conversation