Free SAS 9.4 Programming Fundamentals Exam A00-215 Exam Practice Test

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

• Data=
• SORTOUT=
• OUTPUT=
• OUT=

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

• CLASS
• GROUP
• SUMBY
• VAR

Which option renames the variable Name to StudentName when reading the ClassRoster data set?

• set ClassRoster (rename (StudentName=Name ) ) ; B set ClassRoster (rename (NamestudentName) ) ;
• set ClassRoster (renaiae=(Name=studentName) ) ;
• set ClassRoster (^name=(StudentName=Name));

Which LABEL statement has correct syncytax?

• Label1 FName=’ First Name’ ; LName =; Last Name‘ ;
• Label1 FName=’ First Name’ LName =’ Last Name‘ ;
• Label1 FName=’ First Name’ and LName =’ Last Name‘ ;
• Label1 FName=’ First Name’ , LName =; Last Name‘ ;

Which statement is true about the SUM statement?

• The SUM statement includes an equal sign.
• Multiple accumulating variables can be created with one SUM statement.
• The SUM statement ignores missing values.
• By default, the accumulating variable is initialized to 1.

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

• Ods excel=’ c : \report. xlsx’ style=analysis;
• Ods excel workbook=’ report. xles’ analysis;
• Ods excel=’ c : \report. xlsx’ / analysis;
• Ods excel file =’c \report.xlsx’ styleanalysis;

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

• data bball;set sashelp.baseball;whete Division and nHits run;
• data bball;sot sashelp.baseball; where Division — 'East; where nHits >= 75;run;
• data bball;set sashelp.baseball;where Division = * East; or nHits .= 75;
• data bball;
• set sashelp.basaball; whero Division — 'Eas run,-

Which statements read the input data set SASHELP. SHOES and create the output data set WORK. TOTAL?

• data sashalp.shoes; out work.total;
• data sashelp.shoes;
• output work.total;
• data work.total; set sashelp.shoes;
• data out=work.total; input sasholp.shoes

Which statement is true regarding variable names?

• Variable names are case sensitive.
• Variable names are from 1 to 32 characters in length.
• Variable names are optional when you create a data set
• Variable names can start with a number or an underscore

Which statement is true regarding the SET statement?

• The SET statement specifies an input data set in the DATA step.
• The SET statement specifies an output data set in the PROC SORT step.
• The SET statement specifies an input data sot in the PROC SORT step
• The SET statement specifies an output data 5et in the DAI A step.