They SQL Here They SQL There

  title={They SQL Here They SQL There},
  author={Ian Amaranayake and David J. Shannon},
The SQL procedure has come to play a significant role in many of the SAS9 solutions. Not only is it still a language within a language for the Base SAS programmer, but it is a key procedure in tools such as SAS Data Integration Studio, Enterprise Guide and behind the scenes of Information Maps. A brief history of the SQL origins will be presented to understand why it is used and understood across several software packages and languages. Common uses of SQL and how it is set apart from the data… CONTINUE READING