SAS 9.4 Base Programming A00-231 Dumps Questions

SAS 9.4 Base Programming A00-231 Dumps Questions

Preparing for the A00-231 SAS 9.4 Base Programming — Performance-based Exam?  FreeTestShare offers these SAS 9.4 Base Programming A00-231 Dumps Questions carefully which are based on the latest syllabus and very relevant to the real exam. Once you have spent some time learning these SAS 9.4 Base Programming A00-231 Dumps Questions, then you can face the real exam with more confidence and ensure passing it in your first attempt itself.

Try these A00-231 free questions now and check your preparation level.

Page 1 of 7

1. Consider the following data step:





The computed variables City and State have their values assigned using two different methods, a

RETAIN statement and an Assignment statement.

Which statement regarding this program is true?

2. This question will ask you to provide a line of missing code.

Given the following data set WORK.SALES:





The following program is submitted:





Which statement should be inserted to produce the following output?



3. The following SAS program is submitted:





What will the data set WORK.TEST contain?



4. The following SAS program is submitted:

libname temp ‘SAS data library’;

data work.new;

set temp.jobs;

format newdate mmddw10.;

mdate = month(newdate);

ddate = weekday(newdate);

run;

proc print data = work.new; run;

The variable NEWDATE contains the SAS date value for April 15. 2005.

What output is produced if April 15, 2005 falls on a Friday?

5. Given the SAS data set WORK.ORDERS:





Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that represents the ship date as a character string, such as “February 2,2009’

Which statement will create the new variable Ship_date_char as a character value with a format such as “February 2, 2009”?

6. Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

7. The Excel workbook REGIONS.XLS contains the following four worksheets:

EAST

WEST

NORTH

SOUTH

The following program is submitted:

libname MYXLS 'regions.xls';

Which PROC PRINT step correctly displays the NORTH worksheet?

8. Given the SAS data set WORK.P2000:





And the SAS data set WORK.P2008:





The following output is desired:





Which SAS program correctly combines the data?



9. Consider the following data step:





In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing value?

10. The Excel workbook REGIONS.XLSX contains the following four worksheets:

EAST

WEST

NORTH

SOUTH

The following program is submitted:

libname MYXLS XLSX ‘c: data regions.xlsx’;

Which PROC PRINT step correctly displays the NORTH worksheet?


 

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *