Creating a View library in meatdata

[againreddy]

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.

[Clark · Accepted solution]

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.