05-11-2017 10:48 AM
Thats dependant on the other surrounding circumstances, its not just a a case of "Why SAS", its specific to your scenario. What you need is a system analysis to see if SAS can intergrate to your workflows, add thinigs to process etc. For example what are yours and your teams skillsets, what software fo you currently use, what IT support do you currently have etc.
05-11-2017 05:07 PM
05-15-2017 07:31 PM
I agree with what the other responders have said. And, it's really the job of SAS marketing to explain the competitive advantages of SAS. Most of the experts on this community don't work for SAS, they are users of the software.
That being said, here are a few of the reasons I find SAS an excellent tool for ETL and data managament:
The SAS software tools have been oriented towards data management from the start. There are many computing problems I wouldn't use SAS to solve, but if my problem is in the area of data management and ETL, I feel confident that SAS will be one of the best, if not the best (my definition is the cost to solve a particular problem.)
SAS is quite mature, which means they've been improving the product since the 1970s. That has led to a very functionally rich product.
Because SAS was developed before SQL was universal, SAS added support (very good support) for SQL after the fact. Because of this, SAS has many tools for manipulating data, not just limited to SQL. There are many ETL / data management problems that SQL isn't optimal for.
SAS interfaces very well with other data management (database, proprietary data format, .csv) products, and it is also well-designed to produce output in a large number of popular formats (HTML, PDF, RTF, XLSX).
I have found that SAS as a company tends to make many good decisions, to move the software product in the needed directions. I feel confident that the software won't fall behind in the marketplace.
My 2 cents worth,
05-16-2017 02:44 PM
I wanted to give the community a chance to respond (thanks to those that did!) before providing a SAS perspective to the “why SAS?” question.
I’m afraid without additional details about your requirements, it's difficult to be more specific. I think you will find that SAS data management technologies stack up well against other data integration software vendors.