Using PROC SORT, arrange (or sort) the SASHELP.HEART dataset in ascending order by STATUS and SEX to a new temporary SAS data set. Then, transpose the character variable, SMOKING STATUS, from the temporary sorted HEART dataset and create a new temporary transposed data set by SMOKING_STATUS. Then, construct a DATA step with 3, 221 elements that selects and changes the STATUS = "Alive" and _NAME_ = "Smoking Status observations for SMOKING STATUS -smoker "Smoke-free" for each patient. Finally , produce an EXCEL spreadsheet file using PROC REPORT by specifying the ODS EXCEL destination containing the revised results.

Answer rating: 100% (QA)

PROC SORT DATASASHELPHEART OUTWORKHEARTBY STATUS SEXRUNPROC TRANSPOSE DATAWORKHEART ... View the full answer