SAS Institute A00-215 Online Practice Questions and Exam Preparation

SAS Institute A00-215 Online Questions & Answers

• Question 41:

  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
  D. Option D

• Question 42:

  Given the PROC PRINT report of the INVEST data set shown below:

  

  How many observations are in the FORCAST data set after this program executes?

  A. 30
  B. 10
  D. 20
  A. 30

• Question 43:

  Which statement is true regarding the DATA step?

  A. The DATA step can only read raw data files.
  B. The DATA step reads, processes and creates date
  C. The DATA step can output only one data set.
  D. The DATA step must be the first step in a program.
  B. The DATA step reads, processes and creates date

• Question 44:

  Given the data sets AMERICIAN NATIONAL and results in the data set BASEBALL shown below: AMERICAN

  

  NATIONAL

  BASEBALL

  

  Which DATA step correctly creates the BASEBALL data set?

  A. data baseball; set american (rename=(Team=TeamName)) national; run;
  B. data baseball; set american national; run;
  C. data baseball; set American (rename=(TeamName=Team)) national; run;
  D. data baseball; set national American; run;
  B. data baseball; set american national; run;

• Question 45:

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

  A. set ClassRoster (rename (StudentName=Name ) ) ;
  B. set ClassRoster (rename (NamestudentName) ) ;
  C. set ClassRoster (renaiae=(Name=studentName) ) ;
  D. set ClassRoster (^name=(StudentName=Name));
  B. set ClassRoster (rename (NamestudentName) ) ;

• Question 46:

  Given the following assignment statement:

  BirthDate = 15DEC2005'd;

  Which statement is true?

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

• Question 47:

  Given the input data set WORK.RUN:

  

  Given the following DATA step:

  

  What is the correct output data set WORK.RUN2?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 48:

  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;
  D. Proc print data= sashelp. Shoes Format sales comma12.; Run;

• Question 49:

  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;
  C. Ods excel=' c : \report. xlsx' / analysis;

• Question 50:

  Given the code shown below:

  

  What will be the format for MSRP in the RPOC PRINT output?

  A. There is a syntax error in the FORMAT statement in the PROC PRINT step.
  B. Comma12. 2
  C. Dollar10.
  D. Dollar12.
  D. Dollar12.