topic Export to CSV in SAS Procedures

Export to CSV

Tal — Sat, 23 Apr 2016 23:30:33 GMT

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?

Re: Export to CSV

Reeza — Sat, 23 Apr 2016 23:37:05 GMT

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.

Re: Export to CSV

Reeza — Sun, 24 Apr 2016 00:28:37 GMT

If you can get the PowerPivot add in, that does seem to provide a workaround. You'll need to look into that further yourself.

Re: Export to CSV

PGStats — Sun, 24 Apr 2016 03:35:40 GMT

You or your business partners could do the pivot tables directly in MS-Access.

Re: Export to CSV

LinusH — Sun, 24 Apr 2016 06:02:03 GMT

Or keep the data in SAS and use the SAS OLEDB provider/SAS Addin 4 MS Office.

Re: Export to CSV

Norman21 — Sun, 24 Apr 2016 07:26:43 GMT

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:

http://csved.sjfrancke.nl/

Re: Export to CSV

Tal — Mon, 25 Apr 2016 21:57:10 GMT

Thx Reeza thx guys for your inputs but we dont have MS Access at work. Can that be possible? Have everything under MS Office but Access

Re: Export to CSV

Reeza — Mon, 25 Apr 2016 22:37:47 GMT

That's pretty standard, Access is available under a different license and has an additional cost.