Which of the following DATA steps produces a data set that is equivalent to the LBTR data set created by the PROC TRANSPOSE step above?

The first six (6) records from the LABS data set are shown below:

The following SAS program is written to reshape this data set and place it in a new data set named LBTR.

proc transpose data=labs out=lbtr(rename = (col1 = value));

by subjid sampldat;

var Calcium Glucose Hemoglobin;

run;

Which of the following DATA steps produces a data set that is equivalent to the LBTR data set created by the PROC TRANSPOSE step above?
A . data lbtr2(drop = i calcium glucose hemoglobin);
set labs;
array orig[3] calcium glucose hemoglobin;
array testcds[3] $ 10 _temporary_ ("CALCIUM" "GLUCOSE" "HEMOGLOBIN");
do i = 1 to 3;
value = orig[i];
_name_ = testcds[i];
output;
end;
run;
B . data lbtr2(drop = i calcium glucose hemoglobin);
set labs;
array orig[3] calcium glucose hemoglobin;
array testcds[3] $ 10 _temporary_ ("CALCIUM" "GLUCOSE" "HEMOGLOBIN");
do i = 1 to 3;
value = orig[i];
_name_ = testcds[i];
end;
output;
run;
C . data lbtr2(drop = i calcium glucose hemoglobin);
set labs;
array orig[3] calcium glucose hemoglobin;
array testcds[3] $ 10 ("CALCIUM" "GLUCOSE" "HEMOGLOBIN");
do i = 1 to 3;
value = orig[i];
_name_ = testcds[i];
end;
output;
run;
D . data lbtr2(drop = i calcium glucose hemoglobin);
set labs;
array orig[3] calcium glucose hemoglobin;
array testcds[3] $ 10 ("CALCIUM" "GLUCOSE" "HEMOGLOBIN");
do i = 1 to 3;
value = orig[i];
_name_ = testcds[i];
output;
end;
run;

View Answer

Answer: A