Question: 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

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.

Step by Step Solution

3.45 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!