Star schema in sas viya 3.3

[jmehul]

Hi All,

How can I create a star schema in SAS VIYA? 

I have seen some post which is suggesting this link 

https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=caspg&docsetTarget=cas...

It is a SAS coding. Doesn't SAS VIYA has a drag and drops option as in SAS VA lasr star schema?

Also, some posts suggest using data views option in data pane.
But I can't figure it out how to make a star schema using data views option in data pane.

I appreciate it if anyone guides me with the process.

[LinusH]

I think it's called Data Preparation in Viya, and you will probably use applications such as Data Studio and Data Explorer.

See these tutorials for an introduction:

https://video.sas.com/category/videos/sas-data-preparation

[jmehul]

@LinusH

I can't find any option in Data preparation, which can make star schema model (View).

P.s. I am not talking about joining the table. 

[Bogdan_Teleuca]

Hi,

You can create a star schema with a proc cas table.view cas action, just as described in 

https://communities.sas.com/t5/SAS-Communities-Library/Query-Performance-Use-a-CAS-Star-Schema-in-SA...

or 

https://communities.sas.com/t5/SAS-Communities-Library/Automatic-Data-Loading-with-a-CAS-Data-Source...

The code is based on SAS Viya 3.5.