SASInstitute Programming Fundamentals A00-215 Questions & Answers

• Question 41:

  How many statements are In the program shown below?

  

  A. 9

  B. 6

  C. 10

  D. 2

  Correct Answer: D

• Question 42:

  How many statements are in the following PROC PRINT step?

  

  A. 5

  B. 3

  C. 4

  D. 1

  Correct Answer: C

• Question 43:

  Given the data set NAMES:

  

  Which PROC SORT program creates the NAMES data set shown below?

  

  A. proc sort data=Names; orderby Age

  B. proc sort data=Names; by Age

  C. proc sort data=Names; by Age Name

  D. proc sort data=Names; orderby Name; run;

  Correct Answer: A

• Question 44:

  Given the input data set WORK. GR_ANS with two character variables:

  

  The following SAS program is submitted:

  

  Which report is created?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D

• Question 45:

  What is the default sort order of PROC SORT?

  A. Internal

  B. Ascending

  C. Formatted

  D. Descending

  Correct Answer: B

  https://documentation.sas.com/?docsetId=procanddocsetTarget=n12jw1r2n7auqqn1urrh8jwezk00.ht manddocsetVersion=9.4andlocale=en#:~:text=ASCENDING%20is%20the%20default%20sort%20order.andt ext=In%20a%20PROC%20SORT%20KEY,is%20sorted%20in%20ascending%20order.

• Question 46:

  The following program is summited:

  

  The following report is created:

  

  However, the desired report is shown below:

  

  What change is needed to display the desired formatted values for the Answer varia

  A. Change the unformatted values on the VALUE statement to upper case letters

  B. Remove the comma located on the VALUE statement

  C. Add a period to the end of the format name on the VALUE statement.

  D. Remove the dollar sign located at the front of the format name

  Correct Answer: C

• Question 47:

  Given the report shown below:

  

  Which PROC PREQ step creates the frequency report?

  A. proc freq data= cars;

  tables make drivetrain;

  run;

  B. proc freq data= cars; tables make *drivetrain; run;

  C. proc freq data- cars; tables drivetrain make; run;

  D. proc freq data- cars; tables drivetrain* make; run;

  Correct Answer: D

• Question 48:

  Which PROC SORT option allows you to create an output data set of the sorted data?

  A. Data=

  B. SORTOUT=

  C. OUTPUT=

  D. OUT=

  Correct Answer: A

• Question 49:

  Which PROC MEANS statements specifies variables to group the data before calculating statistics?

  A. CLASS

  B. GROUP

  C. SUMBY

  D. VAR

  Correct Answer: A

• Question 50:

  Which program generates the PROC MEANS report below?

  

  A. proc means data=sashelp.class nodec; class Age; run;

  B. proc means data=sashelp. class; group Age; run;

  C. proc means data=sashelp. class; by Age; run;

  D. proc means data=sashelp. class maxdec=0; var Age; run;

  Correct Answer: B