Description

Scope:
Specific Instructions for this Assignment:

1. Assign a libref that points to the folder that contains the data being used for homework assignments in this class. Set the readonly option on this libref to protect it from accidentally overwriting data. Assign a fileref for the PDF file that will contain the output for this assignment. The name of the actual file must follow the naming conventions established in the previous assignment.
3. Concatenate ncaam03 and ncaam04.
4. Use SQL to print the data portion of the new data set. Title and footnotes must match the output on eCampus including skipped lines between titles. (NOTE: Titles and footnotes are created using the same rules as with other procedures. Define titles and footnotes before or within the SQL procedures.)
6. Use the Print procedure and a data set option to print the first 30 records of interleaved data set.
7. Use the Match Merge process to create a data set of only those who played in both 2003 and 2004 tournaments. Again exclude any variables that are not in both data sets.
9. Match Merge ncaam03, ncaam04, and ncaam06 into a single data set. (NOTE: When I merge data sets, I start with the oldest and go to the newest when I list the data sets on my merge statement.) Use data set options as needed so that the resulting data set has the variables player, team, ppg2003, ppg2004, and ppg2006. As the names imply, the yearly ppg variables are taken from the respective yearly data sets. Use a length statement to set the length of the player variable to match the longest size of the player variables from the three data sets. Use what you know about how SAS creates the PDV to decide where in the data step to place the length statement.
10. Create a SQL procedure with multiple statements. The first statement must write to the log a list of the columns and their attributes from the data set created in the previous step. The second statement will print the data portion of the data set with the columns in the order shown. Use this statement to assign the column labels shown in the sample output.
11. Use a single PROC step to print the descriptor portion of all data sets in your work library.
12. End the program with the appropriate housekeeping steps to ensure titles and footnotes do not carry over to the next program that is executed. As a reminder, this and all future assignments must contain the appropriate header and documentation within the program.
13. Convert your program and log to PDF using the naming convention established in the previous procedure. Submit these files and the ODS output to WebAssign.