topic Re: Exports file in SAS Programming

Exports file

SASdevAnneMarie — Mon, 10 Jun 2024 15:49:22 GMT

Hello Experts,

My data is to big for Excel exports : 261 520 Ko. I'll export the file on csv.

Do you know, please, the max of Ko that I can export on csv and excel via sas?

Thank you !

Re: Exports file

ballardw — Mon, 10 Jun 2024 16:14:33 GMT

CSV file size limit should be whatever your operating system and available space settings allow.

For example, my organization has limited file size to 12GByte on our OneDrive storage. So I can't create anything larger without going to admin and requesting an exception and has nothing to do with SAS.

Excel is limited to the Excel file size unless your OS and available space settings are less.

Caution: Don't let Excel attempt to open a CSV that you know is larger than Excel limits. You can easily make a mistake that will have Excel replace the CSV and truncate data.

Re: Exports file

SASdevAnneMarie — Mon, 10 Jun 2024 16:24:35 GMT

Thank you! If CSV is larger than Excel I need to open the CSV with Notepad ?

Re: Exports file

ballardw — Mon, 10 Jun 2024 17:39:30 GMT

Notepad has a limit of 2GB on 64 bit platforms and may have performance issues and very likely OS dependent.

Wordpad may do better for some things but any file that size why are you opening it at all?

I do a very small amount of work with CSV files in Wordpad because I have some data sources that enter stuff that Excel will "interpret" to other values and I sometimes need to verify what is actually present in the file prior to reading it into SAS data sets. But at more than a couple of hundred lines that gets tedious quickly.

Re: Exports file

SASdevAnneMarie — Mon, 10 Jun 2024 18:47:46 GMT

Could you explain me the limits of Excel please?

Re: Exports file

ballardw — Mon, 10 Jun 2024 20:12:59 GMT

Google or any other search engine will do a much better job than I will paraphrasing the google results.

I quit trying to keep track of such things when it exceeded 64K rows of data. 64K rows corresponds to roughly 1,625 pages of text at 40 lines per page, in other words four moderate sized novels. Anyone "reading" that much Excel or CSV output has some sort of problem. Now the files allow many more lines. So I doubt that anyone that says they are going to read the results is going to do a very good job of it.

Re: Exports file

Sajid01 — Mon, 10 Jun 2024 20:26:14 GMT

Hello @SASdevAnneMarie
If the size of data too big for Excel consider Microsoft Access / PowerBI depending on your needs and end usage.