Redo Problem B using PROC TRANSPOSE instead of DATA steps to reshape the data set(s)

Problem B

A research organization conducted an experiment at three different labs, each obtaining one numerical measurement per subject per day for 285 consecutive days. Each lab prepared a permanent SAS data set. You need to combine the three data sets into a single SAS data set with these variables: Lab, Subject, Day, and Measurement. However, the separate lab data sets each need to be rearranged before they can be combined. Specifically, they are organized as follows:

Lab 1. 29 observations with variables Subject, d1, d2,, d285,

Lab 2. 32 observations with variables ID, day1, day2,, day285.

Lab 3. 33 observations with variables Label, day_001, day_002,, day_285.

Write a SAS program using DATA steps (not PROCs) to produce the 4-variable combined data set from the three given sets. To convince the instructor that the combined data set AllResults is correct, generate output using the following code:

proc contents data=AllResults varnum; run;

proc means data=AllResults mean;

by Lab; var Subject Day / weight=Measurement;

run;

Hint. See the picture for a small but similar example.

GIVEN DATA SETS FINAL DATA SET