SAS System was founded in 1970s and since then its leading product in data warehousing, business analysis and analytical intelligence.
SAS (Statistical Analysis System) is actually all-in-one database which makes it’s the best among all other vendors. In simple words SAS can be described as ETL Tool + Reporting Tool + Forecasting Tool. All other tools are specifically made for either ETL (like Informatica, OWB, ODI) or reporting purpose (like OBIEE, BO).This makes SAS a better option for Data warehousing.
The core component of the SAS System is Base SAS software which is the software product designed for data access, transformation and reporting. It manages data and calls procedures.
Base SAS software contains the following features
- Data management facility
- Programming language
- Data analysis and reporting utilities
Another components is SAS ETL Studio which is an application that enables you to manage ETL process flows—sequences of steps for the extraction, transformation, and loading of data.
Other components of SAS includes
- BI Dashboard
- Data Integration Studio
- SAS Enterprise Business Intelligence Server
- Enterprise Guide etc…
Latest Release by SAS is SAS 9.3