Pay attention on Pass-king A00-282 Practice Materials, clear exam 100% for sure

When writing a validation program using independent programming, which two actions conform to good programming practices?
(Choose two.)

• A. Ensure the production program has been run prior to compare.
• B. Copy statistical code directly from the SAP.
• C. Copy statistical code directly from the production program.
• D. Delete subjects from the production side that are causing differences with the validation data set.

How does the code shown below help to validate report output?
data check;
set datlib.medhist;
mh_len = length(trim(mhcom1));
run;
proc freq data=check;
tables mh_len;
run;

• A. It helps the programmer determine which observation has the longest value for mhcom1.
• B. It writes all values of the mhcom1 variable that are longer than 200 in the results.
• C. It shows all the values for mhcom1 in the results.
• D. It shows all the values for the length of mhcom1 in the results.

This question will ask you to provide a line of missing code.
Given the following demography (DM) data set sorted by site with character variables SUBJID, SITE, SEX, RACE and numeric variables ENROLLDAT and DOB:

The following SAS program is submitted:
%macro p_demog(bylist, varlist, statlist=);
proc sort data=derived.dm out=dm;
by &bylist;
proc means data=dm;
by &bylist;
var &varlist;
output out=stats &statlist;
run;
%mend p_demog;
Which call to the p_demog macro provides only the MEAN of AGE by SEX into the output dataset STATS?

• A. %p_demog(sex age statlist=%str(mean=mymeanvar))
• B. %p_demog(statlist=%str(mean=mymeanvar), sex, age)
• C. %p_demog(statlist=%str(mean=mymeanvar), sex, varlist=age)
• D. %p_demog(sex, age, statlist=%str(mean=mymeanvar))

A subject visit data set (Visits) includes variables for subject ID (SubjID) and visit date (VisitDT).
Which DATA step creates a data set with one record per subject and creates a variable (Visits) that computes the total number of visits for that subject?

• A. proc sort data=Visits out=SortVisits;
  by SubjID VisitDT;
  run;
  data VisitCount;
  set SortVisits;
  by SubjID VisitDT;
  if first.SubjID then Visits=0;
  if last.SubjID then output;
  Visits+1;
  keep SubjID Visits;
  run;
• B. proc sort data=Visits out=SortVisits;
  by SubjID VisitDT;
  run;
  data VisitCount;
  set SortVisits;
  by SubjID VisitDT;
  if first.SubjID then Visits=0;
  else if last.SubjID then output;
  Visits+1;
  keep SubjID Visits;
  run;
• C. proc sort data=Visits out=SortVisits;
  by SubjID VisitDT;
  run;
  data VisitCount;
  set SortVisits;
  by SubjID VisitDT;
  if first.SubjID then Visits=0;
  else if last.SubjID then output;
  else Visits+1;
  keep SubjID Visits;
  run;
• D. proc sort data=Visits out=SortVisits;
  by SubjID;
  run;
  data VisitCount;
  set SortVisits;
  by SubjID;
  if first.SubjID then Visits=0;
  Visits+1;
  if last.SubjID then output;
  keep SubjID Visits;
  run;

How does the code shown below help to validate report output?
data check;
set datlib.medhist;
mh_len = length(trim(mhcom1));
run;
proc freq data=check;
tables mh_len;
run;

• A. It helps the programmer determine which observation has the longest value for mhcom1.
• B. It writes all values of the mhcom1 variable that are longer than 200 in the results.
• C. It shows all the values for mhcom1 in the results.
• D. It shows all the values for the length of mhcom1 in the results.