SASInstitute Programming Fundamentals A00-215 Questions & Answers

• Question 51:

  Which PROC PRINT option displays variable labels in the report?

  A. SHOWLABELS

  B. COLS

  C. LABELS=

  D. LABEL

  Correct Answer: C

• Question 52:

  Which LABEL statement has correct syncytax?

  A. Label1 FName=' First Name' ; LName =; Last Name` ;

  B. Label1 FName=' First Name' LName =' Last Name` ;

  C. Label1 FName=' First Name' and LName =' Last Name` ;

  D. Label1 FName=' First Name' , LName =; Last Name` ;

  Correct Answer: D

• Question 53:

  Given the display of the CITIES data set:

  

  Which program creates the PROC PRINT report below?

  

  A. proc print data=cities showlabelse; label Name= ' Employee Name City =Birth City

  B. proc print data-cities label noobs; label Name='Employee Name' City=' Birth City' ; run;

  C. proc print data=cities ; Name=' Employee Name' ; City='Birth City'; run;

  D. options noobs labels; proc print data=cities; display Name=' Employee Name* city='Birth City', run;

  Correct Answer: C

• Question 54:

  Which step temporarily assign a format to the sales variable?

  A. Proc format; Formatsales comma12.; Run;

  B. Data sasuer. Shoes Set sashelp,sheoes; Format sales comma12.;

  C. Proc contents data=sashelp.shoes; Format Sales comma12.; Run;

  D. Proc print data= sashelp. Shoes Format sales comma12.; Run;

  Correct Answer: D

• Question 55:

  Given the partial shown below:

  

  Which step will produce this report?

  A. proc freq data=sashelp. shoes data=sashelp.shoes; region product / list run;

  B. proc freq data=sashelp.shoes; tables region*producc / cross run;

  C. proc freq data= sashelp, shoes order=freq; table region product / crosalist run;

  D. proc freq data=sashelp. shoes order=freq; tables region*product / list; run;

  Correct Answer: C

• Question 56:

  Given the following SAS program:

  

  What footnotes appear for the second PROC PRINY report?

  A. Created by HR

  B. Created by HR

  C. Draft - Do Not Distribute Create by HR

  D. Draft - Do NOT Distribute

  Correct Answer: A

• Question 57:

  Which ODS EXCEL statement correctly creates an Excel using the ANALYSIS style?

  A. Ods excel=' c : \report. xlsx' style=analysis;

  B. Ods excel workbook=' report. xles' analysis;

  C. Ods excel=' c : \report. xlsx' / analysis;

  D. Ods excel file ='c \report.xlsx' styleanalysis;

  Correct Answer: C

• Question 58:

  Which PROC IMPORT step correctly creates the MYDATA,SALES data set from the SALES.SCV file?

  A. proc import data="mydata. sales" dbms=csv out="mydata.sales; nun

  B. proc import datafile="sales.csv" dbms=csv out-mydata. sales;

  C. proc import data=mydata.sales dbms=csv out=mydata.gales; run,

  D. proc import datafile=sales.csv dbms=csv out--"mydata,sales"; run;

  Correct Answer: D

• Question 59:

  Which PROC MEANS program creates the report below?

  

  A. proc means data-sashelp. shoes sum mean; var Sales; Class Product;

  run;

  B. proc means data=sashelp. 'shoes var Sale; group Product; run/

  C. Pror moans data-uashelp . shoes sum mean nobe; by sales; class product

  D. proc means data-esea= ashelp. shoes. sum Salad; mean Sales; by product; run."

  Correct Answer: A

• Question 60:

  Which statement is true regarding the XLSX engine in the LIBNAME statement?

  A. The individual worksheets are automatically concatenated when reading a Microsoft Excel workbook.

  B. The XLSX engine can road and write data in Microsoft Excel workbooks.

  C. The XLSX engine can road Microsoft workbooks with both XLSX and XLS extensions

  D. The XLSX extension in the Microsoft Excel workbook name is optional in the LIBNAME statement

  Correct Answer: A