what is difference between look up transformation and join transofrmation.???
The manual is generally the first place for information:
http://support.sas.com/documentation/cdl/en/etlug/65016/HTML/default/viewer.htm#n0geesvp950nken1tetx...
In a lookup transformation, the lookup tables are loaded into memory at the start, and the main table is processed sequentially.
In a join transformation, all tables need to be sorted (often done implicitly by a SQL step) and then merged along the by variables.
Joins should be done when the contributing tables are quite large, or there is a m:n relationship.
Lookups are good for smaller lookup tables (small just meaning they should fit into memory) and 1:n relationships (lookup to main); one can do several lookups in one sequential step.
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.