Implement data modeling in Sas Viya

[jejobo2340]

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.

[JosvanderVelden]

Have you seen this post: https://communities.sas.com/t5/SAS-Communities-Library/Query-Performance-Use-a-CAS-Star-Schema-in-SA...?

[jejobo2340]

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? 

[SASKiwi]

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. 

[JosvanderVelden]

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.