Latest 2014 Pass4sure and Lead2pass SAS A00-201 Practice Tests (A 31-40)

 

31: The contents of the raw data file SIZE are listed below:

—-|—-10—|—-20—|—-30
72 95

The following SAS program is submitted:

data test;
     infile ‘size’;
     input @1 height 2. @4 weight 2;
run;

Which one of the following is the value of the variable WEIGHT in the output data set?

A.2
B.72
C.95
D..  (missing numeric value)
Answers: A

32: The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.
The following SAS program is submitted:

proc sort data = work.test out = work.testsorted;
     by name;
run;

Which one of the following is the result of the SAS program?
A.The data set WORK.TEST is stored in ascending order by values of the NAME variable.
B.The data set WORK.TEST is stored in descending order by values of the NAME variable.
C.The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.
D.The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable.
Answers: C

33: The following SAS program is submitted:

data allobs;
     set sasdata.origin (firstobs = 75 obs = 499);
run;

The SAS data set SASDATA.ORIGIN contains 1000 observations.
How many observations does the ALLOBS data set contain?
A.424
B.425
C.499
D.1000
Answers: B

34: A raw data file is listed below:

—-|—-10—|—-20—|—-30
John McCloskey 35 71
June Rosesette 10 43
Tineke Jones 9 37

The following SAS program is submitted using the raw data file as input:

data work.homework;
      infile ‘file-specification’;
      input name $ age height;
      if age LE 10;
run;

How many observations will the WORK.HOMEWORK data set contain?
A.0
B.2
C.3
D.No data set is created as the program fails to execute due to errors.
Answers: C

35: The following SAS program is submitted:

<insert ODS statement here>
proc means data = sasuser.shoes;
     where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);
run;

Which one of the following ODS statements completes the program and sends the report to an HTML file?
A.ods html = ‘sales.html’;
B.ods file = ‘sales.html’;
C.ods file html = ‘sales.html’;
D.ods html file = ‘sales.html’;
Answers: D

36: The following SAS program is submitted:

data _null_;
     set old (keep = prod sales1 sales2);
     file ‘file-specification’;
     put sales1 sales2;
run;

Which one of the following default delimiters separates the fields in the raw data file created?
A.:  (colon)
B.(space)
C.,  (comma)
D.;  (semicolon)
Answers: B

37: The following SAS program is submitted:
 
data _null_;
     set old;
     put sales1 sales2;
run;

Where is the output written?
A.the SAS log
B.the raw data file that was opened last
C.the SAS output window or an output file
D.the data set mentioned in the DATA statement
Answers: A

38: When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:

libname sasdata ‘SAS-data-library’;
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100);
run; 
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500);
run;

How many observations are processed by each procedure?
A.400 for PROC PRINT
4500 for PROC MEANS
B.401  for PROC PRINT
4501 for PROC MEANS
C.401 for PROC PRINT
4500 for PROC MEANS
D.500 for PROC PRINT
5000 for PROC MEANS
Answers: B

39: Which one of the following ODS statement options terminates output being written to an HTML file?
A.END
B.QUIT
C.STOP
D.CLOSE
Answers: D

40: A raw data file is listed below:

RANCH,1250,2,1,Sheppard Avenue,”$64,000″
SPLIT,1190,1,1,Rand Street,”$65,850″
CONDO,1400,2,1.5,Market Street,”80,050″
TWOSTORY,1810,4,3,Garris Street,”$107,250″
RANCH,1500,3,3,Kemble Avenue,”$86,650″
SPLIT,1615,4,3,West Drive,”94,450″
SPLIT,1305,3,1.5,Graham Avenue,”$73,650″

The following SAS program is submitted using the raw data file as input:

data work.condo_ranch;
     infile ‘file-specification’ dsd;
     input style $ @;
     if style = ‘CONDO’ or style = ‘RANCH’ then
        input sqfeet bedrooms baths street $ price : dollar10.;
run;

How many observations does the WORK.CONDO_RANCH data set contain?
A.0
B.3
C.5
D.7
Answers: D

If you want to pass the SAS A00-201 exam sucessfully, recommend to read latest SAS A00-201 Braindumps full version.