Hi,
You can create a star schema with a proc cas table.view cas action:
https://communities.sas.com/t5/SAS-Communities-Library/Query-Performance-Use-a-CAS-Star-Schema-in-SAS-Viya-3-5/ta-p/622970
or
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.
... View more