![]() ![]() It’s can be also used in report mode to report changes in Metadata between SAS and Oracle tables or views for further analysis and processing.įor detailed information about Proc METALIB, see SAS Language Interface to Metadata and SAS Intelligence Platform: Data Administration Guide. Updating Table Metadata (columns, indexes, unique keys, foreign keys, and key associations) when the physical table structures change.Registering Table Metadata regarding new tables.By default, the procedure performs the following tasks: The SAS METALIB Procedure, available in SAS 9.3, 9.2 and 9.1, is a very powerful procedure that can be used to Synchronize Metadata within SAS library. Suppose you have an Oracle library that is already defined in the SAS Metadata Server as follow: Here we discuss how to capture potential metadata changes between SAS and Oracle tables, and how to synchronize Metadata within the SAS Oracle Library.Ĭapturing potential metadata changes between SAS and Oracle tables without making the changesĬreating an Oracle library to access data stored in Oracle tables or views using SAS/ACCESS as a data source involves three steps: Thus, when people change Oracle physical table structures (adding, updating and deleting tables, or columns) those changes are not reflected in your SAS Oracle libname, and this can generate warnings causing some SAS Data Integration Studio jobs to crash. As a precursor to analyzing data with SAS, you first extract data from Oracle and transform this data into SAS data sets. In several sectors, it is very common to store data in Oracle database system and analyze and present the data using the SAS system. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |