DATA Step, Macro, Functions and more

SAS data file size comparing to Excel file size

Reply
N/A
Posts: 0

SAS data file size comparing to Excel file size

If the data are the same, when the data is in a SAS data set format, the file size is always bigger than if the data is saved in Excel right? Anyone know why? Thanks.
Super Contributor
Super Contributor
Posts: 3,174

Re: SAS data file size comparing to Excel file size

Posted in reply to deleted_user
And why is this important? If you are concerned about space usage, consider the SAS system option COMPRESS=YES, however the results will be data-dependent. And consider that character versus numeric data stored by each could have an impact on size.

Scott Barry
SBBWorks, Inc.
PROC Star
Posts: 1,760

Re: SAS data file size comparing to Excel file size

Posted in reply to deleted_user
You are comparing apples and oranges here really.

Sas has to fit database usage requirements like:
-maintain dataset header information,
-maintain variable metadata (formats, etc),
-allow instantaneous direct access to any record,
-use fixed length storage (unless you request compression)
-allow hooks for aging, integrity constraints, index usage
-etc.

Excel doesn't do any of that, it just stores in whatever (probably somewhat compressed) format it sees fit that opens the file in a quick fashion. None of the constraints above apply (but others do, like loading the whole file in one go), as the usage is totally different.

As I said, apples and oranges. Smiley Happy
Ask a Question
Discussion stats
  • 2 replies
  • 145 views
  • 0 likes
  • 3 in conversation