To optimize a Structured Query Language (SQL), the database professional must befriend this order and perhaps even embrace it. Who is your best friend? I’m talking about the order in which SQL processes your statements. Simply put, in what order does SQL do your work? (From my previous post you
Tag: SQL
A database professional’s best friend
SAS author's tip: displaying integrity constraints
Kirk Lafler and his book PROC SQL: Beyond the Basics Using SAS are the source of this week's tip. PROC SQL was the very first book that I promoted when joining SAS. Kirk was the perfect first SAS Press author to work with and he remains a favorite. And his book continues to appeal to users--whether they're online or at conferences.
Wrapping up 2009
Contributed by Michele Burlew, president of Episystems Inc. and SAS Publishing author What a great way to end 2009 by having both Combining and Modifying SAS Data Sets: Examples, Second Edition (CMDS) and Output Delivery System: The Basics and Beyond (ODS) in print! Each is a hefty stocking stuffer for