Exit demo A00-215 SAS 9.4 Programming Fundamentals PDF format · free preview

SAS Institute A00-215 - Questions & Answers

Free preview · every answer includes a full explanation

Product page: https://prepkeys.com/a00-215.html

Question 1
Single choice

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

Question 2
Single choice

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;

Question 3
Single choice

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

A.

proc import data="mydata. sales" dbms=csvout="mydata.sales;nun

B.

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

C.

proc import data=mydata.sales dbms=csvout=mydata.gales; run,-

D.

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

Question 4
Single choice

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

C.

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

Question 5
Single choice

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

Question 6
Single choice

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;

Question 7
Single choice

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;

Question 8
Single choice

Which PROC PRINT option displays variable labels in the report?

A.

SHOWLABELS

B.

COLS

C.

LABELS=

D.

LABEL

Question 9
Single choice

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` ;

Question 10
Single choice

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;

Showing 10 of 60 questions · Unlock the full set