![]() SAS ® 9.For documentation about PROC METALIB, refer to the following resources: Now you can delete the Update Metadata node from your process flow and run the code for Update Metadata program.įor more information about the Update Library Metadata task in SAS Enterprise Guide, consult the Help that is accessible from within the wizard. Select ("MY FIRST TABLE" "MY SECOND TABLE") In the program that opens, modify the code by adding a SELECT or EXCLUDE statement following the UPDATE_RULE statement to identify the tables that you want to include or exclude.Right-click the node and select Add as Code Template.Then in Step 2 of 2, select the third option, Update and add table definitions in metadata with the actual tables and columns, and click the Finish button. In Step 1 of 2, select the appropriate SAS application server and the library. ![]() ![]() In Enterprise Guide, select Update Library Metadata from the Tools menu and follow the wizard to create the Update Metadata node in your Process Flow.However, you can use the tool as a starting point for generating a PROC METALIB template which you can then modify to select or exclude specific tables, as follows: The path i'm following is: 1- Browse the library object (duplicate table name can be found in different librarys). Attributes like constraints info can't be activated in the wizard and i'm not fiding them through metadata browsing. However, this tool is limited in that it updates the entire library and does not allow you to selectively add or update tables. The problem is i can't seem to find all attributes needed to build that table structure. The tool works by generating code that calls the METALIB procedure to perform the metadata updates. SAS ® Enterprise Guide ® provides the Update Library Metadata tool (found on the Tools menu) to enable you to add or update metadata for tables in a library from SAS Enterprise Guide.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |