Description

Scope:
The objective of this assignment is to practice using outer joins and creating SQL views. It will also reinforce the concepts of subqueries and inline views to create a complex query. All of the information necessary to complete this assignment was covered by the end of Lecture 11.
Specific Instructions for this Assignment:
3. Run a second CONTENTS procedure to show the “descriptor portion” of the view created above.
4. Run a SQL statement that writes the definition of the view to the SAS Log.
5. Use a SQL statement to access the view and print all the data returned by the view. Create a footnote indicating the source as SQL.
6. Use Proc Print to print the data returned by the view. Use a footnote to indicate source as Proc Print.
7. Three PDF files must be uploaded to WebAssign. Convert your program and the SAS log to PDF files. The third file will contain all the requested output from ODS PDF. The program must contain a completed header block and comment blocks for each step. To the extent you have
been taught to control it, your output must be consistent with that in the Assignment output posted on eCampus.