Pass exam with A00-282 Top Exam Collection for sure one-shot

Given the following two data sets EX and AE:

Which output data set is produced by the submitted SAS program?

• A. Option D
• B. Option B
• C. Option C
• D. Option A

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];
  end;
  output;
  run;
• B. 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;
• 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];
  output;
  end;
  run;
• D. 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;

Which statement correctly adds a label to the data set?

• A. DATA two; set one; Label dataset="Subjects having duplicate observations"; run;
• B. DATA two Label="Subjects having duplicate observations"; set one; run;
• C. DATA two (Label="Subjects having duplicate observations"); set one;
• D. DATA two; Label="Subjects having duplicate observations"; set one; run;

Which SAS program will apply the data set label 'Demographics' to the data set named DEMO?

• A. data demo (label='Demographics');
  set demo;
  run;
• B. data demo; set demo;
  label demo= 'Demographics';
  run;
• C. data demo;
  set demo (label='Demographics');
  run;
• D. data demo (label 'Demographics');
  set demo;
  run;

In a study, inclusion criteria required patients be between 18 and 65. Patients will be analyzed in 2 age groups: group one is subjects who are under 36 years of age and group two is subjects who are 36 years of age or older.
Which statements properly assign age group, and writes an error message to the log for any patient with an out of range age value?

• A. select;
  when (age >= 66) put "ERROR: AGE OUT OF PROTOCOL SPECIFIED RANGE FOR " subject= age=; when (age >= 36) agegrp = 2; when (age >= 18) agegrp = 1; otherwise; end;
• B. select;
  when (age >= 18) agegrp = 1;
  when (age >= 36) agegrp = 2;
  when (age >= 66) put "ERROR: AGE OUT OF PROTOCOL SPECIFIED RANGE FOR " subject= age=; end;
• C. select;
  when (age >= 66) put "ERROR: AGE OUT OF PROTOCOL SPECIFIED RANGE FOR " subject= age=; when (36 <= age < 66) agegrp = 2; when (18 <= age < 66) agegrp = 1; end;
• D. select;
  when (18 <= age < 36) agegrp = 1;
  when (36 <= age < 66) agegrp = 2;
  otherwise put "ERROR: AGE OUT OF PROTOCOL SPECIFIED RANGE FOR " subject= age=; end;