SAS 9.4 Base Programming A00-231 Dumps Questions

test2022-10-19T06:39:25+00:00

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?

The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.

Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.

The assignment statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.

City's value will be assigned one time, State's value 5 times.

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?

Qtr1 = sum(of month {*});

Qtr1 = sum(of month {3});

Qtr1 = month{1} + month{2} + month {3};

Qtr1 = sum(of month{_ALL_});

3. The following SAS program is submitted:

What will the data set WORK.TEST contain?

Option A

Option B

Option C

Option D

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?

Obsnewdate mdate ddate104/15/2005 APR 6

Obs newdate mdate ddate104/15/2005 4 6

Obs newdate mdate ddate104/15/2005 APR 7

Obs newdate mdate ddate104/15/2005 4 7

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”?

Ship_date_char = input(Ship_date, date9.,worddate20.);

Ship_date_char = put(Ship_date, date9.,worddate20.);

Ship_date_char = input(Ship_date,worddate20.);

Ship_date_char = put(Ship_date,worddate20.);

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

libname sasdata 'SAS-data-library';data sasdata.mydata;copy mydata;run;

libname sasdata 'SAS-data-library';data sasdata.mydata;keep mydata;run;

libname sasdata 'SAS-data-library';data sasdata.mydata;save mydata;run;

libname sasdata 'SAS-data-library';data sasdata.mydata;set mydata;run;

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?

proc print data=MYXL

NORTH;run;

proc print data=MYXL

NORTH$;run;

proc print data=MYXL

'NORTH'e;run;

proc print data=MYXL

'NORTH$'n;run;

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?

Option A

Option B

Option C

Option D

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?

X would get a value of 1.

X would get a value of 3.

X would retain its original value of missing.

This step does not run because of syntax errors.

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?

proc print data=MYXL

‘NORTH’e;run;

proc print data=MYXL

NORT

XLSX;run;

proc print data=MYXL

NORTH;run;

proc print data=MYXL

‘NORTH$’n;run;

Page 2 of 7

11. The following SAS program is submitted:

What is the value of the variable Diff?

-99

-1

12. Given the raw data file AMOUNT:

----I---- 10---I----20---I----30

$1,234

The following SAS program is submitted:

data test;

infile ‘amount’;

input@1 salary 6.;

if_error_then description = ‘Problems’;

else description = ‘No Problems’;

run;

What is the result?

The value of the DESCRIPTION variable is No Probl.

The value of the DESCRIPTION variable is Problems.

The value of the DESCRIPTION variable is No Problems.

The value of the DESCRIPTION variable can not be determined.

13. The following SAS program is submitted:

data allobs;

set sasdata.origin (firstobs = 75 obs = 499);

run;

The SAS data set SASDATA.ORIGIN contains 1000 observations.

How many observations does the ALLOBS data set contain?

424

425

499

1000

14. Given the SAS data set WORK.ONE:

The following SAS program is submitted:

What value will SAS assign to Total?

4.8

1.6

(missing value)

1.2

15. The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:

WORK.ONE

Num Char

------ ------

1 23

3 23

1 77

The following SAS program is submitted:

proc print data=WORK.ONE;

where Num='1';

run;

What is output?

Num Char--- ---- 1 23

Num Char--- ---- 1 231 77

Num Char--- ---- 1 233 231 77

No output is generated.

16. After a SAS program is submitted, the following is written to the SAS log:

What issue generated the error in the log?

There should have been commas between the variable names.

The list of variables should have been enclosed in parentheses.

A drop statement and a keep= data set option cannot both be used at the same time.

The syntax of the drop statement does not use an equals sign.

17. The following SAS DATA step is submitted:

libname temp 'SAS-data-library';

data temp.report;

set sasuser.houses;

newvar = price * 1.04;

run;

Which one of the following statements is true regarding the program above?

The program is reading from a temporary data set and writing to a temporary data set.

The program is reading from a temporary data set and writing to a permanent data set.

The program is reading from a permanent data set and writing to a temporary data set.

The program is reading from a permanent data set and writing to a permanent data set.

18. The following output is created by the FREQUENCY procedure:

Which TABLES statement was used to completed the following program that produced the output?

proc freq data=sales;

<_insert_code_>

run;

tables region product;

tables region,product

tables region/product;

tables region*product;

19. The following SAS program is submitted:

How many raw data records are read during each iteration of the DATA step?

20. The following SAS program is submitted:

data work.company;

set work.dept1(keep = jobcode)

work.dept2(rename = (jcode = jobcode));

run;

Which one of the following is the result?

The variable JCODE is written to the output data set.

The variable JOBCODE is written to the output data set.

Neither variable JCODE nor JOBCODE is written to the output data set.

The program fails to execute due to errors.

Page 3 of 7

21. On which portion(s) of a SAS data set does the PRINT procedure report?

the data portion only

the descriptor portion only

the descriptor portion and the data portion

neither the data portion nor the descriptor portion

22. Given the raw data file EMPLOYEE:

----I----1 0---I----20---I----30

Ruth 39 11

Jose 32 22

Sue 30 33

John 40 44

The following SAS program is submitted:

data test;

infile ‘employee’;

input employee_name $ 1-4;

if employee_name = ‘Ruth’ then input idnum 10-11;

else input age 7-8;

run;

What value does the variable IDNUM contain when the name of the employee is “Ruth”?

(missing numeric value)

23. Given the SAS data set QTR 1_REVENUE:

destination revenue

YYZ53634

FRA62129

FRA75962

RDU76254

YYZ82174

The following SAS program is submitted:

proc sort data = qtr1_revenue;

by destination descending revenue; run;

What is the first observation in the output data set?

destination revenue FRA 62129

destination revenue FRA 75962

destination revenue YYZ 53634

destination revenue YYZ 82174

24. Given the contents of the raw data file TYPECOLOR.DAT:

The following SAS program is submitted:

What are the values of the variables Type and Color?

Type=daisy, Color=yellow

Type=daisy, Color=w

Type=daisy, Color=daisyyellow

Type=daisy, Color=

25. The SAS data set EMPLOYEE_INFO is listed below:

IDNumber Expenses

2542 100.00

3612 133.15

2198 234.34

2198 111.12

The following SAS program is submitted:

proc sort data = employee_info;

run;

Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

by descending IDNumber Expenses;

by (IDNumber Expenses) descending;

by IDNumber descending Expenses descending;

by descending IDNumber descending Expenses;

26. The following SAS program is submitted:

<insert ODS statement here>

proc means data = sasuser.shoes;

where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);

run;

<insert ODS statement here>

Which ODS statements complete the program and send the report to an HTML file?

ods html = ‘sales.html’; ods html close;

ods file = ‘sales.html’; ods file close;

ods file html = ‘sales.html’; ods file close;

ods html file = ‘sales.html’; ods html close;

27. Which statement is true concerning the SAS automatic variable _ERROR_?

It cannot be used in an if/then condition.

It cannot be used in an assignment statement.

It can be put into a keep statement or keep= option.

It is automatically dropped.

28. Given the raw data record in the file phone.txt:

Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?

FullName=CATX('',EmpFName,EmpLName);

FullName=CAT('',EmpFName,EmpLName);

FullName=EmpFName!!EmpLName;

FullName=EmpFName + EmpLName;

29. Given the following IF/THEN statement:

If Age NE 16 and Age NE 15 then Group-1;

Which assignment statement for variable Group is functionally equivalent to the original statement used in the above data step?

if (Age NE 16) or (Age NE 15) then Group=1;

where Age not between (15 and 16) then Group=1;

where Age not between 15 and 16 then Group=1;

if Age not in(15,16) then Group=1;

30. The following SAS program is submitted:

data WORK.ACCOUNTING;

set WORK.DEPARTMENT;

length EmpId $6;

CharEmpid=EmpId;

run;

If data set WORK.DEPARTMENT has a numeric variable EmpId.

Which statement is true about the output dataset?

The type of the variable CharEmpid is numeric.

The type of the variable CharEmpid is unknown.

The type of the variable CharEmpid is character.

The program fails to execute due to errors.

Page 4 of 7

31. Given the following raw data records:

The following output is desired:

Which SAS program correctly reads in the raw data?

Option A

Option B

Option C

Option D

32. By default, which variables and data values are used to calculate statistics in the MEANS procedure?

all non-missing numeric variable values

all missing and non-missing numeric variable values and numbers stored as character variables.

all non-missing numeric variable values and numbers stored as character variables

all missing and non-missing numeric variable values

33. The following SAS program is submitted:

data temp.x;

set sasuser.y;

run;

What must be submitted prior to this SAS program for the program to execute successfully?

A LIBNAME statement for the libref TEMP only must be submitted.

A LIBNAME statement for the libref SASUSER only must be submitted.

LIBNAME statements for the librefs TEMP and SASUSER must be submitted.

No LIBNAME statement needs to be submitted.

34. Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?

35. The SAS data set WORK STAFF has three variables:

The following SAS program is submitted:

What is the length of the Name variable in the data set WORK STAFF_UPDATE?

36. The following program is submitted:

proc contents data=_all_;

run;

Which statement best describes the output from the submitted program?

The output contains only a list of the SAS data sets that are contained in the WORK library.

The output displays only the contents of the SAS data sets that are contained in the WORK library.

The output displays only the variables in the SAS data sets that are contained in the WORK library.

The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.

37. Consider the data step:

Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?

if Age not in(15,16) then Group=1; else Group=2;

if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;

where Age not between 15 and 16 then Group=1; else Group=2;

both A or C will work.

38. Which one of the following SAS procedures displays the data portion of a SAS data set?

FSLIST

CONTENTS

DATASETS

39. The following SAS program is submitted:

data test;

infile ‘file specification’;

input name $ amount@@;

run;

Which of the following is true?

Two @@ together are the same as one c.

Two @@ hold the data records until the bottom of the DATA step.

Two @@ hold the raw data record across iterations of the DATA step.

Two @@ are invalid syntax and will cause the program to fail to execute.

40. The following SAS program is submitted:

What is the value of the variable Prod in the output data set?

. (missing numeric)

Page 5 of 7

41. The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:

WORK.EMPLOYEE WORK.SALARY

fname age fname salary

Bruce 30 Bruce 25000

Dan 40 Bruce 35000

Dan 25000

The following SAS program is submitted:

data work.empdata;

merge work.employee

work.salary;

by fname;

totsal + salary;

run;

How many variables are output to the WORK.EMPDATA data set?

No variables are output to the data set as the program fails to execute due to errors

42. Given the SAS data set WORK. PRODUCTS:

The following SAS program is submitted:

data WORK. REVENUE (drop=Sales Returns);

set WORK. PRODUCTS (keep=ProdId Price Sales Returns); Revenue-Price* (Sales-Returns); run;

How many variables does the WORK.REVENUE data set contain?

43. The following SAS program is submitted:

What types of variables are DayOfMonth, MonthOfYear, and Year?

DayOfMonth, Year, and MonthOfYear are character.

DayOfMonth, Year, and MonthOfYear are numeric.

DayOfMonth and Year are numeric. MonthOfYear is character.

DayOfMonth, Year, and MonthOfYear are date values.

44. The following SAS program is submitted:

data WORK.PRODUCTS;

Prod=1;

do while (Prod LE 7);

Prod + 1;

end;

run;

What is the value of the variable Prod in the output data set?

.(missing numeric)

45. Which ODS statement option terminates output being written to an HTML rile?

END

QUIT

STOP

46. The following SAS program is submitted:

data revenue;

set year_1;

var1 = mdy(1,15,1960);

run;

Which one of the following values does the variable named VAR1 contain?

1151960

'1/15/1960'

47. The following SAS program is submitted:

data work.new;

mon = 3;

day = 23;

year = 2000;

date = mdy(mon,day,year);

run;

Which one of the following is the value of the DATE variable?

a character string with the value '23mar2000'

a character string with the value '03/23/2000'

a numeric value of 14692, which represents the SAS date value for March 23, 2000

a numeric value of 3232000, which represents the SAS date value for March 23, 2000

48. What describes the SAS automatic _ERROR_ variable?

The _ERROR_ variable contains the values ‘TRUE’ or ‘FALS

’

The _ERROR variable maintains a count of the number of data errors.

The _ERROR_ variable can be used in expressions or calculations in the DATA step.

The ERROR_variable contains the number or the observation that caused the error.

49. Given the SAS data set WORK.ORDERS:

The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".

Which of the following statement will correctly create the value and assign it to ship_note?

ship_note=catx('','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);

ship_note=catx('','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);

ship_note=catx('','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);

ship_note=catx('','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);

50. Given the data sets below:

WORK.EMP with variables:

WORK.NEWHIRE with variables:

The following SAS program is submitted:

The SAS data set WORK.EMP has 50 observations, and the data set WORK.NEWHIRE has 4 observations.

How many variables will the data set WORK.ALLEMP contain?

The program fails execution.

Page 6 of 7

51. Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?

MSOFFICE2K

EXCELXP

CSVALL

WINXP

52. Given the contents of the raw data file TYPECOLOR:

----I----10---I----20---I----30

Daisyyellow

The following SAS program is submitted:

data flowers;

infile ‘typecolor’;

input type$ 1-5+1 color$;

run;

What are the values of the variables TYPE and COLOR?

type colordaisygreen

type colordaisy ellow

type colordaisyyellow” “(missing character value)

No values are stored for the TYPE and COLOR variables.

53. The contents of the raw data file AMOUNT are listed below:

--------10-------20-------30

$1,234

The following SAS program is submitted:

data test;

infile 'amount';

input @1 salary 6.;

if _error_ then description = 'Problems';

else description = 'No Problems';

run;

Which one of the following is the value of the DESCRIPTION variable?

Problems

No Problems

'' (missing character value)

The value can not be determined as the program fails to execute due to errors.

54. Given the AIRPLANES data set

AlRPLANES

TYPE MPG

-------- ------

F-18 105

C-130 25

Harrier 75

A-6 110

The following SAS program is submitted:

data gt100;

set airplanes(keep = type mpg load);

load = mpg * 150;

run;

The program fails to execute due to syntax errors.

What is the cause of the syntax error?

MPG is not a numeric variable.

LOAD is not a variable in the data set GT100.

LOAD is not variable in the data set AIRPLANE

LOAD must be defined prior to the SET statement.

55. The following SAS program is submitted:

data WORK.OUTDS;

do until(Prod GT 6);

Prod + 1;

end;

run;

What is the value of the variable Prod in the output data set?

(missing)

Undetermined, infinite loop.

56. The SAS data set PETS is sorted by the variables TYPE and BREED.

The following SAS program is submitted:

proc print data = pets;

var type breed;

sum number;

run;

What is the result?

The SUM statement produces only a grand total of NUMBE

The SUM statement produces only subtotals of NUMBER for each value of TYP

The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYP

Nothing is produced by the SUM statement; the program fails to execute.

57. CORRECT TEXT

Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?

Enter your numeric answer in the space below.

58. Given the SAS data set PEPM.STUDENTS:

PERM.STUDENTS

NAME AGE

Alfred 14

Alice13

Barbara13

Carol14

The following SAS program is submitted:

libname perm ‘SAS data library’;

data students;

set perm. Students;

file ‘file specification’;

put name $15. @5 age 2.;

run;

What is written to the output raw data file?

----I----10---I----20---I---- 30 Alfred 14 Alice 13 Barbara 13 Carol 14

---- I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4

----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141

----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14

59. A raw data file is listed below:

RANCH,1250,2,1,Sheppard Avenue,"$64,000"

SPLIT,1190,1,1,Rand Street,"$65,850"

CONDO,1400,2,1.5,Market Street,"80,050"

TWOSTORY,1810,4,3,Garris Street,"$107,250"

RANCH,1500,3,3,Kemble Avenue,"$86,650"

SPLIT,1615,4,3,West Drive,"94,450"

SPLIT,1305,3,1.5,Graham Avenue,"$73,650"

The following SAS program is submitted using the raw data file as input:

data work.condo_ranch;

infile 'file-specification' dsd;

input style $ @;

if style = 'CONDO' or style = 'RANCH' then input sqfeet bedrooms baths street $ price : dollar10.; run;

How many observations does the WORK.CONDO_RANCH data set contain?

60. The contents of the raw data file EMPLOYEE are listed below:

--------10-------20-------30

Ruth 39 11

Jose 32 22

Sue 30 33

John 40 44

The following SAS program is submitted:

data test;

infile 'employee';

input employee_name $ 1-4;

if employee_name = 'Sue' then input age 7-8; else input idnum 10-11;

run;

Which one of the following values does the variable AGE contain when the name of the employee is "Sue"?

. (missing numeric value)

Page 7 of 7

61. Given the SAS data set AGES:

AGES

AGE

---------

The variable AGE contains character values. The following SAS program is submitted:

data subset;

set ages;

where age> 12;

run;

How many observations are written out to the data set SUBSET?

62. The following SAS program is submitted:

data work.totalsales;

set work.monthlysales(keep = year product sales);

retain monthsales {12} ;

array monthsales {12} ;

do i = 1 to 12;

monthsales{i} = sales;

end;

cnt + 1;

monthsales{cnt} = sales;

run;

The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

Which one of the following is the result of the above program?

The program fails execution due to data errors.

The program fails execution due to syntax errors.

The program runs with warnings and creates the WOR

TOTALSALES data set with 60 observations.

The program runs without errors or warnings and creates the WOR

TOTALSALES data set with 60 observations

63. Which of the following programs correctly invokes the DATA Step Debugger?

Option A

Option B

Option C

Option D

64. Which one of the following statements is true regarding the name of a SAS array?

It is saved with the data set.

It can be used in procedures.

It exists only for the duration of the DATA step.

It can be the same as the name of a variable in the data set.

65. CORRECT TEXT

The following SAS program is submitted:

How many observations are written to the WORK.VOLUME data set?

Enter your numeric answer in the space below.

66. Which step displays a listing of all the data sets in the WORK library?

proc contents lib=WORKrun;

proc contents lib=WOR

all;run;

proc contents data=WOR

_all_;run;

proc contents data=WORK _ALL_;run;