Connect Two Data Views. I have basically two views named customerV and productV. SAS data views PROC SQL views in-line views and interface SASACCESS descriptor views.
Depending on your needs and preferences you can use different types of views to view the same data in different ways. Asked 8 years 11 months ago. Th ere are two groups of views presented in this paper.
Th ere are two groups of views presented in this paper.
You can actually create separate views in Yellowfin and then join these views via a composite view. CREATE VIEW dboMyView AS SELECT X AS Database_NameCustnumber FROM Xdbotablecust UNION ALL SELECT Y AS Database_NameCustnumber FROM Ydbotablecust UNION ALL SELECT Z AS Database_NameCustnumber FROM Zdbotablecust. Create a linked server in DB invironment then create a SP to take care of it. Use the tables listing mode instead of advanced and select your views that you have created in step 1.