Help using Base SAS procedures

How to minimise the file size of exporting worksheets to excel workbook?

Reply
tmc
N/A
Posts: 1

How to minimise the file size of exporting worksheets to excel workbook?

Can anyone tell me is there other option to minimise the size of exported workbook beside using "style=minimal"?
Cause the size of excel file(consist of 9 worksheets) that I exported is more than 20Mbs, where "style=minimal" did not help out much.
Trusted Advisor
Posts: 2,113

Re: How to minimise the file size of exporting worksheets to excel workbook?

You could export to .csv and then let Excel deal with the lengths.
Super Contributor
Super Contributor
Posts: 3,174

Re: How to minimise the file size of exporting worksheets to excel workbook?

Consider zipping the SAS-generated export file as part of your processing.

Scott Barry
SBBWorks, Inc.

Subset Raw Data and Zip Them Up
Desheng(Ben) Xu, CGS, Northern Illinois University, De Kalb, IL
http://www2.sas.com/proceedings/sugi29/077-29.pdf
Ask a Question
Discussion stats
  • 2 replies
  • 94 views
  • 0 likes
  • 3 in conversation