I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?
Answer Posted / Nitin Azad
{"data extraction": "In SAS ETL, data is extracted from various sources like databases, flat files, or web services using procedures such as PROC SQL, PROC COPY, or custom-written macros.","ODS (Operational Data Store) storage": "The extracted data is then stored in an ODS (Operational Data Store), which is a high-performance data warehouse optimized for ETL operations. SAS provides several built-in ODS engines like ODS Table, ODS Log, and ODS Graphics.","data modeling": "Data modeling in SAS involves designing the structure of the data and the relationships between different entities. This is typically done using SAS Data Dictionary, which allows you to define tables, columns, relationships, and constraints. You can also use the Business Intelligence Platform (SAS BI) for more advanced data modeling features."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category