Architecting, installing and maintaining your SAS environment

Creating a View library in meatdata

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 18
Accepted Solution

Creating a View library in meatdata

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.

Accepted Solutions
Solution
a month ago
Occasional Contributor
Posts: 8

Re: Creating a View library in meatdata

Posted in reply to againreddy

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.

View solution in original post


All Replies
Solution
a month ago
Occasional Contributor
Posts: 8

Re: Creating a View library in meatdata

Posted in reply to againreddy

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 104 views
  • 0 likes
  • 2 in conversation