Description

Scope:
In this exercise practice transforming SAS code from traditional code to code with macro variables then on to become a stored macro program. You will need to have seen the first 14 lectures to complete this assignment.
Specific Instructions for this Assignment:
1. Set a system option that writes macro variable values to the SAS log as they are resolved and an option that writes to the SAS log the text that is generated by macro execution. Assign a libref to the folder you have been using as your permanent library for assignment data. You will be writing to this library in this assignment.
Macro variable OUTLIB resolves to work
Macro variable STARTDT resolves to 01Jan2006
Macro variable ENDDT resolves to 31Dec2006
Macro variable GENDER resolves to F
3. Use a PROC PRINT to print the data portion of the data set by using the SYSLAST macro variable. NOTE: The title is designed to NOT resolve the value of &SYSLAST.
in the macro call. Within the macro definition, add another SQL query that will print the data contained in the table. Use the macro parameters to construct the title for the printed output. Create a footnote that prints the value of the SYSLAST macro variable. Include “housekeeping” statements at the bottom of the macro to ensure that the title and footnote do not get included in future output.
5. Call the macro with the following call. (Substitute the libref name of your permanent library in the place of mylib.):
%donations(mylib, male, 01Jan1974, 30Jun1974)
8. 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. Options that control page headers and bookmarks must be set so that part of the output looks like that in the Assignment output posted on eCampus.