Hi
I have a 3 million records dataset that i want to export to excel csv. I was told csv can have way more than a 1M records but after exporting it i only see 1,048k
You guys know a way of doing this?
I need the 3M records in one tab so business partners would be able to do pivot tables out of that file. Any suggestions pls?
CSV is a comma separated values file, and Excel can read a file in that format.
CSV can handle unlimited records but Excel can only read 1 million records. You need a different workaround. Consider exporting to an Access DB and then connecting your Excel workbook to the Access DB. If you need to email the file that's not going to be workable.
Otherwise Excel will not be a good solution, especially if you can't split your file into multiple sheets.
CSV is a comma separated values file, and Excel can read a file in that format.
CSV can handle unlimited records but Excel can only read 1 million records. You need a different workaround. Consider exporting to an Access DB and then connecting your Excel workbook to the Access DB. If you need to email the file that's not going to be workable.
Otherwise Excel will not be a good solution, especially if you can't split your file into multiple sheets.
If you can get the PowerPivot add in, that does seem to provide a workaround. You'll need to look into that further yourself.
You or your business partners could do the pivot tables directly in MS-Access.
As already stated, the contraint is built into Excel, not the CSV file.
If you want to view the large CSV file, try something other than Excel. Here is a link to a freeware program that might be useful:
That's pretty standard, Access is available under a different license and has an additional cost.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.