Output to SAS dataset
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I output a final result to both a .yxdb and to a SAS .sas7bdat file. The data is exactly the same - the 2 files are fed by the same Union tool. The .yxdb is 147mb and the SAS dataset is 10.7 GB. Is there some formatting or data type tweaking that I should do to keep the SAS dataset from being so large?
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @buddy_jones
Unfortunately, SAS files will eventually be much bigger in size than .yxdb files.
.YXDB files are extremely compact.
Just out of curiosity, how many rows and columns are you writing to this sas7bdat file?
Cheers,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
You need to check with the select tool the type and size of the columns to make sure they are all appropriate. About Alteryx native file compression size and quite large
[]
