{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

lab10 - Statistics 440 Lab Exercises 10 Before you begin...

This preview shows pages 1–3. Sign up to view the full content.

Statistics 440: Lab Exercises 10 1 Before you begin: Download the SAS data sets donate , ffmethod , and elements from the Data\Lab 10 folder and save it in D: \ netid (or folder of your choice). For these exercises, use SAS data sets stored in a permanent SAS data library. Submit the LIBNAME statement to assign the libref st to D: \ netid ’ (or folder of your choice). libname st 'D:\ netid '; 1. Outputting Multiple Observations Rotating, or transposing, a SAS data set can be accomplished by using explicit OUTPUT statements in a DATA step. When a data set is rotated, the values of an observation in the input data set become values of a variable in the output data set. Use explicit OUTPUT statements to rotate st.donate into a data set called rotate . Create four output observations in rotate from each input observation in st.donate . The rotate data set should have three variables: ID , Qtr , and Amount . Print the data set to verify your results. Partial Listing of st.donate ID Qtr1 Qtr2 Qtr3 Qtr4 E00224 12 33 22 . E00367 35 48 40 30 E00441 . 63 89 90 E00587 16 19 30 29 E00598 4 8 6 1 Partial Listing of rotate Obs ID Qtr Amount 1 E00224 1 12 2 E00224 2 33 3 E00224 3 22 4 E00224 4 . 5 E00367 1 35 6 E00367 2 48 7 E00367 3 40 8 E00367 4 30 9 E00441 1 . 10 E00441 2 63 11 E00441 3 89 12 E00441 4 90

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Statistics 440: Lab Exercises 10 2 2. Using Conditional Logic to Output Multiple Observations The st.ffmethod
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}