Online Access Free A00-280 Practice Test

Given the following data set:

Which program was used to prepare the data for this PROC PRINT output?

• A.proc sort data=one out=two;
  by subjid;
  run;
• B.proc sort data=one out=two nodupkey;
  by subjid;
  run;
• C.proc sort data=one out=two nodupkey;
  by subjid trt;
  run;
• D.proc sort data=one out=two nodup;
  by subjid;
  run;

Given the following data at WORK DEMO:

Which SAS program prints only the first 5 males in this order from the data set?

• A.proc sort data=WORK.DEMO out=out;
  by sex;
  run;
  proc print data= out (obs=5);
  run;
• B.proc sort data=WORK.DEMO out=out;
  by sex descending;
  run;
  proc print data= out (obs=5);
  run;
• C.proc print data=WORK.DEMO(where=(sex='M'));
  where obs<=5;
  run;
• D.proc print data=WORK.DEMO(obs=5);
  where Sex='M';
  run;

You have acquired an existing program from a coworker which uses a macro. It is not immediately clear to you what this macro is doing. Which OPTION can be used to put the SAS statements generated by the macro execution into the LOG?

• A.MLOGIC
• B.MPRINT
• C.SYMBOLGEN
• D.MRECALL

Given the data set HE:

What will the values be of variable HOSPDURD for the two subjects?

• A.50, 9
• B.65, 9
• C.missing, missing
• D.5, missing

The following SAS program is submitted:
%let Av=age; %macro LABD(Av=weight); %let Av=gend; %mend; %LABD(Av=height) %put Av is &Av;
What will be written to the SAS log?

• A.Av is weight
• B.Av is age
• C.Av is gend
• D.Av is height