Using the techniques shown in this video, especially controlling the length of your character variables, is one technique to alter the size of your data tables. However, we are not able to post code or look at your code or data in this CZcams feedback area. Your question needs some further context and some concrete examples. For example, if you have a 1 Terabyte file, that Terabyte (TB) of storage is the same as 1024 Gigabytes (GB) of storage. What you want to achieve isn't clear from your question. However, if you have a very large file, and you want to try to reduce it in size, then changing the length of the character variables or explicitly using COMPRESS options to compress the file are what you would do. A best practice is to look at your character variables first to see how much space savings you can gain by controlling the length of your character variables before you move onto more complex approaches. The video author has provided all the code he used so if you want to reduce the size of your table, then download the code from the GitHub repository that you'll find if you click the "...More" link in the description. For more specific help on resizing your data on your system, you might want to either work with SAS Tech Support or post your question on the SAS Community Forum for SAS Programming, here: 2.sas.com/6056zgGiq . To open a track with Tech Support, fill out the form at this link: 2.sas.com/6057zgGiS.
Many thanks so interesting
Thank you for your feedback!
Thanks! helpful.
Glad you found it helpful! 🙂
how to resize table size in GB ?
Using the techniques shown in this video, especially controlling the length of your character variables, is one technique to alter the size of your data tables. However, we are not able to post code or look at your code or data in this CZcams feedback area. Your question needs some further context and some concrete examples. For example, if you have a 1 Terabyte file, that Terabyte (TB) of storage is the same as 1024 Gigabytes (GB) of storage. What you want to achieve isn't clear from your question. However, if you have a very large file, and you want to try to reduce it in size, then changing the length of the character variables or explicitly using COMPRESS options to compress the file are what you would do. A best practice is to look at your character variables first to see how much space savings you can gain by controlling the length of your character variables before you move onto more complex approaches.
The video author has provided all the code he used so if you want to reduce the size of your table, then download the code from the GitHub repository that you'll find if you click the "...More" link in the description. For more specific help on resizing your data on your system, you might want to either work with SAS Tech Support or post your question on the SAS Community Forum for SAS Programming, here: 2.sas.com/6056zgGiq . To open a track with Tech Support, fill out the form at this link: 2.sas.com/6057zgGiS.