| Data Warehousing | |
 |
|
| With
The SAS System and a relational model, I can design and create your database, similar to
any database software. SAS Datasets (tables with rows and columns) reside in a SAS Library
(like a database) in a format compatible with the host operating system, yet
portable to other computing environments. Data can be
retrieved, manipulated and updated using not only industry standard SQL, but also the more
powerful SAS Language and SCL (SAS Component Language). Access to SAS datasets is efficient
because there is no intermediate layer between SAS Language and data structure. SAS/ACCESS allows seamlessly exchange data with any existing database software such as SQL Server, DB2, Oracle, Sybase, IDMS, IMS and universal formats such as ODBC & OLE.
|
|
|
|
|
ETL processing (Extract, Transformation, Load)
