You’ve got data. Maybe you created or collected it yourself or got it from a third party. You want to know what’s interesting in it. Just as journalists question people, you must question your data. Think of a query as “interviewing” the data – seeing what information it holds, what’s missing and how it’s categorized, formatted and organized. You can do these things and more with SAS University Edition's Query Builder.
You can create a query based on one table or many tables if you join them together. When you create a query, SAS Studio 3.3 (University Edition’s interface) generates Structured Query Language (SQL) code to retrieve the information you want.
Here’s what SAS Studio’s Query Builder workspace looks like:
To create a query:
To add additional tables:
After you specify all the criteria for your query, you can generate results by clicking on the query window toolbar. The output data opens in the workspace on a separate tab.
For more information