topic Re: Implement data modeling in Sas Viya in SAS Viya

Implement data modeling in Sas Viya

jejobo2340 — Thu, 09 Dec 2021 11:40:03 GMT

Hi everybody, I am very new to Sas and I have a question about Sas Viya reports in SAS Visual Analytics:

From all the examples I saw, the data used in the report is in a single table and to use more than one table, I need to join them. My question is, is there a way to create a data model underneath the report to keep multiple tables in relation to each other without joining them? as a result one can implement infamous star schema like the one below without joining 5 tables:

For those who know Qlik Sense, it is easier to understand what I mean https://hub.packtpub.com/implementing-data-modeling-techniques-in-qlik-sense-tutorial/

please refer me to an example or video showing how to do data modeling in Sas Viya visual analytics.

Re: Implement data modeling in Sas Viya

JosvanderVelden — Thu, 09 Dec 2021 14:05:02 GMT

Have you seen this post: https://communities.sas.com/t5/SAS-Communities-Library/Query-Performance-Use-a-CAS-Star-Schema-in-SAS-Viya-3-5/ta-p/622970?

Re: Implement data modeling in Sas Viya

jejobo2340 — Thu, 09 Dec 2021 14:33:46 GMT

Thanks for the answer, it was exactly what I was looking for.

So as far as I understood, a view simulates the data model. Is there any way to visualize the view as a data model?

More importantly: is there a visual tool that uses GUI to convert a graphical data model to a view?

Re: Implement data modeling in Sas Viya

SASKiwi — Fri, 10 Dec 2021 00:59:39 GMT

AFAIK there is no functionality in SAS for consuming or publishing data models to or from third-party data modelling tools. In any case SAS data libraries aren't DBMSs. Star schemas are one of the few instances of DBMS-type table relationships being used in SAS.

Re: Implement data modeling in Sas Viya

JosvanderVelden — Tue, 14 Dec 2021 12:43:14 GMT

You can use SAS Metadata Bridges to import and export metadata through SAS Management Console or SAS Data Integration Studio. If you are interested you can read https://support.sas.com/software/bridges/ . And if that seems interesting you can read more: https://documentation.sas.com/doc/en/bicdc/9.4/bisag/p0pid3anvsyxkpn1wtj6xrmiiujp.htm & https://support.sas.com/resources/papers/proceedings12/362-2012.pdf.