How to join table in star schema with outer join in Sas viya ??
Star Schema is a generic concept, so can you please elaborate around your requirement, setting the context?
In SAS Compute you can use PROC SQL, in CAS you could use PROC FedSQL to do the join.
I think the general idea of a star schema is to use it only with inner joins. One aspect that it will perform joins quicker.
As I see it, your work-around is to build "better" dimensions so you don't have to rely on outer joins. This could include "Unknown", or "Other" entries in your dimension tables.
Another option is to create CAS views. I wouldn't expect them to be as fast, especially with outer joins.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.