topic Re: Creating a View library in meatdata in Administration and Deployment

Creating a View library in meatdata

againreddy — Fri, 03 Nov 2017 19:23:28 GMT

Library A has the following tables.

1. Tab1(empid,empname)

2. Tab2(saleid, salename)

3. Tab3(payid,payname)

I want Library B with following Views. Library A and B are sourcing tables from the same location or database. Source for the Library can be a SAS datasets or other DBMS tables (via ODBC or SAS access to teradata).

1. view of Tab1(empid)

2. view of Tab2(saleid)

How do I create the pre assigned Library B?. Please advice.

Re: Creating a View library in meatdata

ClarkLawson — Fri, 03 Nov 2017 21:05:15 GMT

You will need to follow these steps:

1. Create the physical location for library B.

2. Register the metadata for library B, pretty much like library A but with a different physical path.

3. You will have to create two dataset views either using SQL or DATASTEP code. Depending on what tool you use, SAS DM, SAS DI or SAS EG, there will be a slightly different approach but the code should be relatively the same.

4. Register metadata of the dataset views.