SAS Tips & Tricks 1 - Using Data from a Lookup Table

Adding data from a lookup table to the base data of your analysis subjects is a very frequent task in data preparation: external data need to be added to the customer base, a list of customers who responded to a test campaign need to be merged to the table of loyalty card members, or product base data need to be combined with the weekly sales data. There are different methods in SAS to accomplish the task of merging two tables. This webinar introduced 4 methods (SQL, Datastep, SAS Format, SAS Hash) and discusses their performance. Article at SAS Communities: https://communities.sas.com/t5/SAS-Co... Ask-the-expert sessions on Data Preparation for Data Science (in German): https://www.sas.com/de_at/webinars/as... https://www.sas.com/de_at/webinars/as... “Data Preparation for Analytics” Book in SAS Press: https://github.com/gerhard1050/Data-P... Slide Collection: Slides Deck No. 121 and No. 122 at https://github.com/gerhard1050/DataSc... ---------------------------------------------------------- #DataScienceClass​ #DataScience​ #DataPreparation​ SAS SOFTWARE D-A-CH ABONNIEREN https://www.youtube.com/SASsoftwareGe... ÜBER SAS SAS ist weltweit Marktführer im Bereich Analytics. Kunden weltweit setzen innovative Software und Services von SAS ein, um Daten in Wissen zu verwandeln und intelligente Geschäftsentscheidungen zu treffen. Seit 1976 verschafft SAS Kunden rund um den Globus THE POWER TO KNOW. http://www.sas.com/de_de/home.html Facebook►   / sasdach   Instagram►   / sas_dach   Twitter►   / sas_dach   LinkedIn►   / sas   Blog► http://blogs.sas.com