cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
JayeL
‎06-15-2018
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Size differences of exported file form SAS

by Calcite | Level 5 in SAS Programming
‎06-14-2018 02:36 AM
‎06-14-2018 02:36 AM
Thank your for your reply. I understand that the file size is related to many complicate rules as you mentioned. Since I handled very limited columns and data types (only few text and numbers) in this case, I had a question with a simple idea. Thank you for your advice! ... View more

Re: Size differences of exported file form SAS

by Calcite | Level 5 in SAS Programming
‎06-14-2018 02:24 AM
‎06-14-2018 02:24 AM
Thank you for your tip. I followed that your posting and I figured out the anatomy of excel files. ... View more

Re: Size differences of exported file form SAS

by Calcite | Level 5 in SAS Programming
‎06-14-2018 02:23 AM
‎06-14-2018 02:23 AM
From your posting, I figured out the difference of xlsx file with my dataset(changed to .zip and checked the generated files in xml) There were several common data in the dataset, and those were written in sharedStrings.xml of the archive. now I understood that what happend on files. It answered my questions and I learned a lot.   I appreciate with your tips. ... View more

Size differences of exported file form SAS

by Calcite | Level 5 in SAS Programming
‎06-13-2018 08:55 PM
‎06-13-2018 08:55 PM
Hi, All   I made two different file types (xlsx and txt : csv) by using the option, export from a SAS project. I believe that the size of a text file is smaller than excel file only except large dataset over a million rows (becuase excel file can store only 2x2^20 - around a million rows). However, when I export data from SAS with these two types of file by using a same data, I found that some dataset saved as excel(.xlsx) is much smaller than text type. Is there any automatically applied compression process when the dataset is exported as xlsx from SAS? I tried that matching up data types (numerical and char fields) of columns and other possible options, but I still do not get a clear explaination on that. If you have any suspicous part and possible ideas on this, please drop a hint. 🙂 I really appreciate any help from you all.    ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-15-2018 04:33 AM
Quick links