Are you considering whether to use a DATA step or PROC SQL step in your next project? This presentation explores the similarities and differences between DATA step and PROC SQL programming techniques. Topics include IFTHEN- ELSE, SELECT-WHEN, and PROC SQL CASE expressions conditional logic concepts and constructs; and the techniques for constructing effective merges and joins. Attendees explore examples that contrast DATA step versus PROC SQL programming techniques to conduct conditional logic scenarios, one-to-one match-merges and match-joins, and an assortment of inner and outer join programming constructs.
conference:
Paper Type:
Paper
