BookmarkSubscribeRSS Feed
JasonNC
Quartz | Level 8

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.

1 REPLY 1
snoopy369
Barite | Level 11

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).

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 846 views
  • 0 likes
  • 2 in conversation