Proc Sql Lesson

What is SAS Data File?

Data values and Data descriptions together in a native SAS format

What is a SAS Data View?

A type of SAS dataset that retrieves data values from other files. Instead of storing the actual values, it stores code that retrieves the data from other files. It can be a Data Step or a Proc SQL query

What's the first thing you must do to access data

Use a lib name statement. Check the log to make sure it is working properly.

SQL language does and doesn't do.....

It describes what you want to know not how to do it. When you submit a Proc SQL statement, the system will access the code and run in the order that makes most sense. A data step gives you control over HOW you want to process the data.

What are these SAS terms in SQL: Data set, observation, variable?

table, row, column

What is the 6 step programming process?

1. Define the business need - what questions will you answer

2. Plan the output - what do you need it to look like

3. Identify the data - where will you get the data you need for the above

4. Write the program

5. Run the program

6. Review the results

Expect to debug or modify and go back to step 2.

What Proc SQL statement will put the full column names in the log?

Proc Sql feedback;

This will stay in effect until a step boundary. This will pull the full column names into the log.