SAS Enterprise Guide: Updating the Metadata with New/Modified Datasets
When working in SAS Enterprise Guide, you can access data from the metadata libraries. When you make changes to the datasets in the meta library, such as adding or modifying columns, or even deleted datasets, the metadata library does not have the data – it must be registered. Argh – so frustrating especially if you are use to working with the normal SAS libraries. However, you can update the metadata library from SAS Enterprise Guide.
SAS Enterprise Guide Tricks for Working with Metadata
So here’s a simple setup of how you might find yourself in this situation. When creating data for SAS BI Dashboard, you might want a smaller or summarized dataset to use. For this example, there was a dataset called SOURCE in the GA_DATA metadata library. So this dataset was changed up to create the dataset BI_DASH_SRCE. For this example, let’s just assume it’s the most AWESOME data every created for a dashboard and not just a renamed dataset I created for this example.
Anyway the issue is when I created this delicious dataset, it was not automagically added to the GA_DATA metadata library – I have to add it. I can use the SAS Management Console but then I have to go open another application and that seems like such a drag.
Updating the Metadata Library
From inside SAS Enterprise Guide, you can view, update, or delete a metadata library (assuming you have permissions!) From the Tools menu, select Update Library Metadata.
In the first step, select the metadata library you want to update. In the second step, there are 5 different options. Select the third one to add the new dataset. (Read the online help for explanations about the other options.) There is an area to log in with an alternate user ID if the current user ID does not have create permissions in the metadata library.
After it runs, a report is generated explaining what happened. In this case, you see that it added the dataset. There are now a total of 4 datasets in the library. The dataset does not show immediately in the metadata library – just refresh it and you can see it.
Click the Code tab to see exactly what happened. The utility ran the METALIB procedure. If you are writing code, you can just highjack this sweet little poetry and delete the task.
Attending SESUG 2015?
If you are planning to attend SESUG 2015 in beautiful Savannah, Georgia on Sept 29 then join me for my talk about data visualization "How to be the MacGyver of Data Visualization"! I'll show you some cool ways to visualize data with SAS Visual Analytics as well as some traps to avoid.
Latest posts by Tricia Aanderud (see all)
- SAS Visual Analytics: Get to the Point with a Geo Coordinate Map - August 30, 2015
- SAS VA: Is Location just a Distracting Character in Your Dataviz? - August 24, 2015
- Do You KISS Your Line Charts? - August 5, 2015
- How Not Knowing Pie Charts Makes You a #DataViz Rookie - May 7, 2015
- 6 Tips for Data Visualization from a Floral Designer - March 26, 2015