A00-202 무료 덤프문제 온라인 액세스

The following SAS program is submitted:
data one;
do i = 1 to 10;
ptobs = ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;
The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?

• A.any real number between 1 and 2,500,000
• B.any integer between 1 and 10
• C.any integer between 1 and 2,500,000
• D.any real number between 0 and 1

Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

• A.&ERR
• B.&SYSERR
• C.&RC
• D.&SYSRC

Given the following SAS data set ONE:
ONE
NUM VAR
1 A
2 B
3 C
Which one of the following SQL programs deletes the SAS data set ONE?

• A.proc sql; alter table one drop num, var; quit;
• B.proc sql; delete from one; quit;
• C.proc sql; delete table one; quit;
• D.proc sql; drop table one; quit;

The following SAS program is submitted:
<insert statement here>; %let development = ontime; proc print data = sasuser.highway;
title "For &dept"; title2 "This project was completed &development"; run;
Which one of the following statements completes the above and resolves title1 to "For research&development"?

• A.%let dept = %nrstr(research&development);
• B.%let dept = %str(research&development);
• C.%let dept = %str(research%&development);
• D.%let dept = %nrstr(research%&development);

Given the following SAS data sets ONE and TWO:
ONE TWO YEAR QTR BUDGET YEAR QTR SALES
2001 3 500 2001 4 300 2001 4 400 2002 1 600 2002 1 700
The following SAS program is submitted:
proc sql; select one.*, sales from one left join two on one.year = two.year;
quit;
Which one of the following reports is generated?

• A.YEAR QTR BUDGET SALES
  2001 3 500 .
  2001 4 400 300 2002 1 700 600
• B.YEAR QTR BUDGET SALES
  2001 3 500 300 2001 4 400 300 2002 1 700 600
• C.YEAR QTR BUDGET SALES
  2001 4 400 300 2002 1 700 600
• D.YEAR QTR BUDGET SALES 2001 3 500 .