SAS ACCESS Interface to PC files should be Included as part of BASE SAS License and NOT sold as a Separate License.If not , atleast include the Excel Support as part of BASE SAS License.
This will benefit SAS Users wanting to Read Excel files directly using SASt especially on Unix Environments.
Excel being a Common Source of Data nowadays makes it necessary that this Interface be provided with BASE SAS to take advantage of the power of SAS without having to pay extra License fee.
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.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.