05-20-2014 05:23 AM
I would like to develop a procedure that automatically updates the metadata tables.
The problem is the following: I have some tables where they are inserted data that could update, change or add. What procedure should I develop to make sure that when they get new data automatically part of a procedure that updates the metadata me?
Thank's a lot tion
05-20-2014 06:03 AM
Unfortunately I do not have a table but I can give an example. For example I have a table with two columns "id" and "value" and three raw. id I in A, B, C I value 1,2,3. Here comes a new table where you add "id" and D "value" 4. How do I update it automatically without writing it by hand.
05-20-2014 06:09 AM
There are many ways to append data, the most straightforward one being:
proc append base=have data=new_data;
Note both tables need the same variables else you would get a warning.
05-20-2014 06:16 AM
ok, but I would also for a modify. For example "ID" A, B, C, and "VALUE" 1,2,3 changes to "ID" F, B, and C "VALUE" 1,2,3
omr (library="[INSERT METADATA LIBRARY NAME HERE]" metarepository="Foundation");
select("[INSERT TABLE NAME HERE]");
05-20-2014 06:47 AM
Sorry, but I don't follow you. Perhaps some "real life" examples are better then the id-value theoretical example?
And could you try to describe your requirement, and by doing this, try to separate the concepts of metadata stored in the SAS metadata server, application metadata/lookup data and "actual" data.
It sounds "dangerous" to automatically update SAS metadata. But if your users have the permissions to do such changes, perhaps they could also do the necessary update of metadata (in Management Console)?