SASInstitute Programming Fundamentals A00-215 Questions & Answers

• Question 31:

  Given the input data set INVENTORY as shown below:

  

  Two output data sets are desired, CHIPS and OTHERSNACKS.

  *

  The CHIPS data set should only include QtySold, Price, and Product.

  *

  The OTHERSNACKS data set should include QtySold, Price, product, and Type. Which Data step creates the two desired output data sets

  A.

  data chips othersnacks; set: inventory; if Type="chips" then do; keep QtySold Price Product; output chips; end; else output othersnacks; run;

  B.

  data chips ( keep=QtySold Price Product) othersnacks; set inventory; if Type="chipa" then output chips; else output otharsnacks; run;

  C.

  data chips otharsnacks; set inventory; if Type="chips" then output chips else output otharsnacks; keep QtySold Price Product; run;

  D.

  data chips othersnack" set inventory (keep=QtySold Price Product); if Typo~"chips" then output chips; else output othersnacks; run;

  Correct Answer: D

• Question 32:

  Which statement is true regarding the SET statement?

  A. The SET statement specifies an input data set in the DATA step.

  B. The SET statement specifies an output data set in the PROC SORT step.

  C. The SET statement specifies an input data sot in the PROC SORT step

  D. The SET statement specifies an output data 5et in the DAI A step.

  Correct Answer: C

• Question 33:

  Which variable in the Program Data Vector represents the number of times the Data step has iterated?

  A. N

  B. _N_

  C. _Obs_

  D. Obs

  Correct Answer: B

  https://v8doc.sas.com/sashtml/lrcon/z0961108.htm

• Question 34:

  Which statement is true about the DROP statement during the compilation phase of the DATA step?

  A. The DROP statement flags the variables in the Program Data Vector to be dropped at output.

  B. The DROP statement determines the order of the variables in the Program Data Vector

  C. Variables on the DROP statement are removed from the input data set.

  D. Variables on the DROP statement are not created in the Program Data Vector

  Correct Answer: C

• Question 35:

  Which program correctly subnets the SASHELP. BASEBALL data set to include only the players in the East Division with 75 or more hits?

  A. data bball; set sashelp.baseball; whete Division and nHits run;

  B. data bball; sot sashelp.baseball; where Division -- 'East; where nHits >= 75; run;

  C. data bball; set sashelp.baseball; where Division = * East; or nHits .= 75;

  D. data bball; set sashelp.basaball; whero Division -- 'Eas run,

  Correct Answer: A

• Question 36:

  Which line contains a syntax error?

  

  A. Line 3

  B. Line 1

  C. Line 2

  D. Line 5

  Correct Answer: B

• Question 37:

  Given the input data sets EMPLOYEES and DONATIONS, and the output data set NODONATIONS below: EMPLOYERS

  

  DONATIONS

  

  NODONATIONS

  

  A. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=0 and inD-0; run;

  B. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; run;

  C. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=1 and inD-0;

  run;

  D. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=1 and inD-1; run;

  Correct Answer: D

• Question 38:

  What type of error does NOT produce the expected results and does NOT generate errors or warnings in the log?

  A. Syntax error

  B. Logic error

  C. Special error

  D. Data error

  Correct Answer: B

• Question 39:

  Which statement is true regarding the DATA step?

  A. The DATA step can only read raw data files.

  B. The DATA step reads, processes and creates date

  C. The DATA step can output only one data set.

  D. The DATA step must be the first step in a program.

  Correct Answer: B

• Question 40:

  You submit a program and the SAS log is shown below: Which statement is true regarding the submitted program?

  

  A. The error in the PROC SORT step caused the program to stop processing

  B. All three steps ran successfully

  C. The DATA step and PROC PRINT steps ran without errors.

  D. The PROC SORT and PROC PRINT steps failed.

  Correct Answer: A