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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.