I want to link 2 or more tables.
One way is to join the tables which will increase the size of my fact tables
Is there any other way to link 2 or more table?
Can we built a data model using any SAS product.
You can create views that do the merge on the fly when accessed.
For lookups, consider creating custom formats.
You can create views that do the merge on the fly when accessed.
For lookups, consider creating custom formats.
I want to link my facts and dimension table and I don't want to join them as it will increase the size of my fact table.
As he said I have to create views at the rum time what I was thinking of using the proc sql statement.
load fact (A) and dimension (B) tables and then
proc sql;
select A.age,
B.salary,
from A,B
where A.Id= B.Id;
Quit;
then I will drop the table A and B.
Need Suggestions!
Depending on table sizes, you can create a format from one table and use it in the other.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.