An Idea Exchange for SAS software and services

Comments
by Super User
on ‎05-30-2014 09:38 AM

I presume that SAS have to have an agreement with M$ to utilize such technology so they have cost there.  However, with the move to and XML based format - which is what xslx is - there is nothing stopping you, with base SAS, unzipping the xlsx file, and reading in the XML.  No need for any additional software.

by Occasional Contributor Bill_in_Toronto
on ‎04-14-2015 11:44 AM

The problem with XML and HTML is that it takes too long to exchange files with Excel once they reach approximately 10,000 observations. When I need to import/export files with 100,000 observations or more these methods are impossibly slow.

by Super User
on ‎04-14-2015 01:50 PM

Hi,

Wow, old post :smileyshocked:  Yes, if you send a lot of XML to Excel its going to take a while.  The reason is that Excel has to read and interpret the information.  Excel wasn't built as a data transfer/database/analysis tool, and hence has very little in the way of optimisation.  I would say XML and such like aren't the problem, using Excel is the problem.  Anyways, Excel format now is XML itself - Open Office.  True the files are zipped, but if you change XLSX to ZIP, then you can see what I mean.  There are some tricks in the Open Office to shrink the information - unique values, and using the new XLSX libname in 9.4 you should be able to read/write to it.  Seriously though, ask yourself is anyone really going to look at 100,000 records in Excel?  I can barely bring myself to scroll a few columns across.  If your doing data transfer and are happy to put documentation in a separate file, then CSV is still quite viable.

Idea Statuses
Top Liked Authors