topic Star schema in sas viya 3.3 in New SAS User

Star schema in sas viya 3.3

jmehul — Thu, 06 Dec 2018 06:56:59 GMT

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-table-view.htm&locale=en

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.

Re: Star schema in sas viya 3.3

LinusH — Thu, 06 Dec 2018 11:52:09 GMT

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

Re: Star schema in sas viya 3.3

jmehul — Thu, 06 Dec 2018 12:34:49 GMT

@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.

Re: Star schema in sas viya 3.3

Bogdan_Teleuca — Mon, 10 Feb 2020 00:54:07 GMT

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-SAS-Viya-3-5/ta-p/622970

https://communities.sas.com/t5/SAS-Communities-Library/Automatic-Data-Loading-with-a-CAS-Data-Source-Star-Schema-in/ta-p/623458

The code is based on SAS Viya 3.5.