SAS Programming -- 2
Budget: $10 – $30 USD
Use admit data from cert library for this homework. All output should be saved in a PDF file (name it hw.pdf) and selected output should be saved in RTF file (name it hw.rtf). Make sure to close HTML destination at the beginning of your program so that no HTML output will be produced. As a good programming practice, reset the ODS destination to HTML output (the default setting) at the end of your program. Output files should be identical to the attached files (hw14.pdf, hw14.rtf and hw14.xlsx). Please note that the PDF file includes a table of contents and (hidden) bookmark list.
1. Produce a table for summary statistics for height and weight by gender and activity level as shown in output. Labels for height and weight are temporary while label for activity level is permanent. This table should be included in PDF file only.
2. Produce a table for summary statistics for fee by gender and age category as shown in output. Label for fee is temporary while label for age category is permanent. Age category is a new variable created based on values of variable age. This table should be included in PDF file only.
3. Produce a table for summary statistics for age by gender as shown in output. Label for age is permanent. This table should be included in both PDF and RTF files. Save the output of summary statistics in a SAS data set as shown below (define labels as below).
1. Produce a table for summary statistics for height and weight by gender and activity level as shown in output. Labels for height and weight are temporary while label for activity level is permanent. This table should be included in PDF file only.
2. Produce a table for summary statistics for fee by gender and age category as shown in output. Label for fee is temporary while label for age category is permanent. Age category is a new variable created based on values of variable age. This table should be included in PDF file only.
3. Produce a table for summary statistics for age by gender as shown in output. Label for age is permanent. This table should be included in both PDF and RTF files. Save the output of summary statistics in a SAS data set as shown below (define labels as below).