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

Which LIBNAME statement has the correct syntax for accessing SAS data sets?

• libname 'c:\sas\data' mydata;
• libname mydata 'c:\sas\data';
• libname mydata='c:\sas\data';
• libname 'c:\sas\data'=mydata;

Given the following assignment statement: BirthDate = 15DEC2005’d;Which statement is true?

• 15DEC2005 'd is a character constant
• BirthDate is a numeric variable.
• The byte size of BirthDate is 9.
• The assignment statement contains a syntax error.

What is the default sort order of PROC SORT?

• Internal
• Ascending
• Formatted
• Descending

CORRECT TEXTWhat is the default byte size of a numeric variable? Enter your numeric answer in the space above.

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

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

• Syntax error
• Logic error
• Special error
• Data error

Which PROC PRINT step correctly displays only the first 10 observations in the data set?

• proc print data=sashelp.class(obs=l10); run;
• proc print data=sashelp.class; obs=10;
• run;
• proc print data=sashelp.class obs=10; run;
• proc print data=sashelp.class (oba«'10' )
• ; run;

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

• The individual worksheets are automatically concatenated when reading a Microsoft Excel workbook.
• The XLSX engine can road and write data in Microsoft Excel workbooks.
• The XLSX engine can road Microsoft workbooks with both XLSX and XLS extensions
• The XLSX extension in the Microsoft Excel workbook name is optional in the LIBNAME statement

Which PROC PRINT option displays variable labels in the report?

• SHOWLABELS
• COLS
• LABELS=
• LABEL

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

• CLASS
• GROUP
• SUMBY
• VAR