star schema in sas viya

[ANVEKSHA]

How do i create a star schema in sas viya which is in cas server. Currently Iam using the 14 days trial version of sas viya.

[alexal]

@ANVEKSHA,

You should be able to create a "star schema" using CAS Views: SAS® 9.4 and SAS® Viya® 3.4 Programming Documentation / SAS Viya System Programming Guide / view Act...

[Bogdan_Teleuca]

Hi Anveksha,

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