topic Re: Need to Upload XPT files larger than 1 GB to export as a csv in SAS Software for Learning Community

Need to Upload XPT files larger than 1 GB to export as a csv

u63609513 — Mon, 06 Nov 2023 19:39:36 GMT

Hi,

I am using SAS On Demand for Academics. I have some xpt files larger than 1 GB, that I cannot upload. Is it possible to compress the file and upload it? Or how can I break down to upload? Or is there another version of SAS I can download that will handle the file sizes?

Any help is appreciated as I just need to convert the xpt files to csv! Thanks.

Re: Need to Upload XPT files larger than 1 GB to export as a csv

SASKiwi — Tue, 07 Nov 2023 01:35:49 GMT

This post about unzipping a zipped archive should be helpful: https://communities.sas.com/t5/SAS-Software-for-Learning/importing-SAS-dataset-from-a-ZIP-archive-in-SAS-on-Demand/m-p/895443#M1428

If you zip up your XPT files before uploading, then unzip once uploaded that should help you get around the upload file size limit.

Re: Need to Upload XPT files larger than 1 GB to export as a csv

u63609513 — Wed, 08 Nov 2023 20:35:00 GMT

Thanks! I tried using this format, unfortunately some of the code is different for XTP files to import. Would you be able to elaborate xpt specific on how to decompress inside of SAS?

Re: Need to Upload XPT files larger than 1 GB to export as a csv

Reeza — Wed, 08 Nov 2023 21:01:05 GMT

https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in-sas/

It was buried in the post.