Help using Base SAS procedures

Export to CSV

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 444
Accepted Solution

Export to CSV

[ Edited ]

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?


Accepted Solutions
Solution
‎05-17-2016 02:49 PM
Super User
Posts: 19,817

Re: Export to CSV

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. 

View solution in original post


All Replies
Solution
‎05-17-2016 02:49 PM
Super User
Posts: 19,817

Re: Export to CSV

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. 

Super User
Posts: 19,817

Re: Export to CSV

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

Respected Advisor
Posts: 4,925

Re: Export to CSV

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

PG
Super User
Posts: 5,430

Re: Export to CSV

Or keep the data in SAS and use the SAS OLEDB provider/SAS Addin 4 MS Office.
Data never sleeps
Frequent Contributor
Posts: 95

Re: Export to CSV

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/

 

 

Norman.
SAS 9.4 (TS1M4) X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation

Super Contributor
Super Contributor
Posts: 444

Re: Export to CSV

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
Super User
Posts: 19,817

Re: Export to CSV

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 618 views
  • 0 likes
  • 5 in conversation