SAS Base Programming Specialist A00-231 Dumps Questions

1. The following SAS program is submitted:

data work.totalsales (keep = monthsales{12} );

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

array monthsales {12} ;

do i=1 to 12;

monthsales{i} = sales;

end;

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?

2. The following SAS program is submitted:









What is the value of the price variable?

3. Given the raw data file EMPLOYEE.TXT:





The following SAS program is submitted:





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

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

5. 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?

6. Given the raw data record DEPT:

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

Printing 750

The following SAS program is submitted:

data bonus;

infile ‘dept’;

inputdept$ 1-11 number 13- 15;

<insert statement here>

run;

Which SAS statement completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?

7. This question will ask you to provide a missing format:

Given the contents of the raw data file 'EMPLOYEE.TXT'





Which SAS information correctly completes the program?

8. Given the SAS data set ONE:

ONE

ObsDte

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

109JAN2005

212JAN2005

The following SAS program is submitted:

data two;

set one;

day = <insert expression here>;

format dte date9.;

run;

The data set TWO is created:

TWO

ObsDteDay

109JAN20051

12JAN20054

Which expression successfully completed the program and created the variable DAY?

9. The following SAS program is submitted:

data WORK.ACCOUNTING;

set WORK.DEPARTMENT;

label Jobcode='Job Description';

run;

Which statement is true about the output dataset?

10. The contents of the raw data file SIZE are listed below:

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

72 95

The following SAS program is submitted:

data test;

infile 'size';

input @1 height 2. @4 weight 2;

run;

Which one of the following is the value of the variable WEIGHT in the output data set?

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

12. 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?

13. The following SAS DATA step is submitted:

data sasdata.atlanta

sasdata.boston

work.portland

work.phoenix;

set company.prdsales;

if region = 'NE' then output boston;

if region = 'SE' then output atlanta;

if region = 'SW' then output phoenix;

if region = 'NW' then output portland;

run;

Which one of the following is true regarding the output data sets?

14. The Excel workbook QTR1.XLS contains the following three worksheets:

JAN

FEB

MAR

Which statement correctly assigns a library reference to the Excel workbook?

15. 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"?

16. The following SAS program is submitted:

data work.retail;

cost = '20000';

total = .10 * cost;

run;

Which one of the following is the value of the variable TOTAL in the output data set?

17. The following SAS program is submitted:

data work.one;

x = 3;

y = 2;

z = x ** y;

run;

Which one of the following is the value of the variable Z in the output data set?

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

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

105 data january;

106 set allmonths(keep = product month num_sold cost);

107 if month = ‘Jan’ then output january;

108 sales = cost * num_sold;

109 keep = product sales;

------

22

ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, <,< =, <>, =, >, ><, >=,

AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,

110 run;

What changes should be made to the KEEP statement to correct the errors in the LOG?

20. The following SAS program is submitted:

data work.test;

set work.staff (keep = jansales febsales marsales);

array diff_sales{3} difsales1 - difsales3;

array monthly{3} jansales febsales marsales;

run;

What new variables are created?

21. 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?

22. Given the following raw data record:

07Jan2005

Which INFORMAT reads this raw data and stores it as a SAS date value?

23. Given the SAS data set EMPLOYEES:

EMPLOYEES

NAME SALARY

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

Innis60000

Jolli50000

Ellis55000

Liu45000

The following SAS program is submitted:

proc print data = employees; where name like ‘_i%’;

run;

What is contained in the output?

24. The following SAS program is submitted:

data one;

date = ‘04juI2005’d;

format date weekdate.; run;

proc print data = one; run;

What output is generated?

25. The following SAS program is submitted:





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

26. 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?

27. The following SAS program is submitted:

data work.products;

Product_Number = 5461;

Item = '1001';

Item_Reference = Item'/'Product_Number;

run;

Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?

28. 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?

29. You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:





What does it mean?

30. 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?

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

The following SAS program is submitted:

proc freq data = WORK.SALES;

<insert code here>

run;

The following output is created by the FREQUENCY procedure:





Which statement was used to complete the above program that produced the output?

32. The SAS data set WORK.AWARDS is listed below:

fname points

Amy 2

Amy 1

Gerard 3

Wang 3

Wang 1

Wang 2

The following SAS program is submitted:

proc sort data = work.awards;

by descending fname points;

run;

Which one of the following represents how the observations are sorted?

33. The following SAS program is submitted:





What is the result?

34. A user-defined format has been created using the FORMAT procedure. Where is it stored?

35. Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

36. The SASDATA.BANKS data set has five observations when the following SAS program is submitted:

libname sasdata 'SAS-data-library';

data allobs;

set sasdata.banks;

capital=0;

do year = 2000 to 2020 by 5;

capital + ((capital+2000) * rate);

output;

end;

run;

How many observations will the ALLOBS data set contain?

37. 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?

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

39. The following SAS program is submitted:

data work.month;

date = input('13mar2000',date9.);

run;

Which one of the following represents the type and length of the variable DATE in the output data set?

40. The following SAS program is submitted:

data work.empsalary;

set work.people (in = inemp)

work.money (in = insal);

if insal and inemp;

run;

The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.

How many observations will the data set WORK.EMPSALARY contain?

41. The contents of the raw data file TEAM are listed below:

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

Janice 10

Henri 11

Michael 11

Susan 12

The following SAS program is submitted:

data group;

infile 'team';

input name $15. age 2.;

file 'file-specification';

put name $15. +5 age 2.;

run;

Which one of the following describes the output created?

42. 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?

43. The following SAS program is submitted:

data work.pieces;

do while (n lt 6);

n + 1;

end;

run;

Which one of the following is the value of the variable N in the output data set?

44. The following SAS program is submitted:

data combine;

prefix=’505’;

middle=’6465 ‘;

end=’09090’;

<insert statement here>;

run;

Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?

45. 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?

46. Given the contents of the raw data file 'EMPLOYEE.TXT'





Which SAS informat correctly completes the program?

47. The following SAS program is submitted:

libname temp ‘SAS data library’;

data temp.sales;

merge temp.sales

work.receipt;

by names;

run;

The input data files are sorted by the NAMES variable:

What is the result?

48. The following SAS program is submitted:





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

49. Given the following raw data record:

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

son Travis,

The following output is desired:

Obs relation firstname

1 son Travis

Which SAS program correctly reads in the raw data?

50. Given the SAS data set WORKAWARDS:

WORK.AWARDS

FNAMEPOINTSMONTH

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

Amy24

Amy17

Gerard33

Wang33

Wang112

Wang18

The following SAS program is submitted:

proc sort data = work.awards;

by descending fname points;

run;

How are the observations sorted?

51. The following SAS program is submitted:





How will the Exam variable value be displayed in the FREQ procedure output?

52. The following SAS program is submitted and reads 100 records from a raw data file:

data work.total;

infile 'file-specification' end = eof;

input name $ salary;

totsal + salary;

run;

Which one of the following IF statements writes the last observation to the output data set?

53. The following SAS program is submitted:

data numrecords;

infile ‘file specification’;

input@1 patient $15. relative$ 16-26@;

if relative = ‘children’ then

input @54 diagnosis $15. @;

else if relative = ‘parents’ then

input @28 doctor $15. clinic $ 44-53

@54 diagnosis $15. @;

input age;

run;

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

54. Given the following code:

proc print data=SASHELP.CLASS(firstobs=5 obs=15);

where Sex='M';

run;

How many observations will be displayed?

55. The following SAS program is submitted:

libname company 'SAS-data-library';

proc sort data = company.payroll;

by EmployeeIDNumber;

run;

Write access has been granted to the COMPANY library.

Which one of the following represents how the observations are sorted?

56. A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx. Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel workbook. However, the Excel workbook already contains a worksheet named outdata.

What will happen?

57. The following SAS program is submitted:

data work. new;

length word $7;

amount = 4;

it amount = 4 then word = ‘FOUR’;

else if amount = 7

then word = ‘SEVEN’;

else word = ‘NONE!!!’;

amount = 7;

run;

What are the values of the AMOUNT and WORD variables in SAS dataset work.new?

58. The following SAS program is submitted, creating the SAS data set ONE:

data one;

infile ‘file specification’;

input num chars$;

run;

ONE

NUMCHAR

123

323

177

The following SAS program is submitted:

proc print data = one;

where char = 23;

run;

What is output?

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

60. Given the SAS data set WORK.THREE:





The following SAS program is submitted:





What is the result?

61. The following SAS program is submitted:

proc means data = sasuser.houses std mean max;

var sqfeet;

run;

Which one of the following is needed to display the standard deviation with only two decimal places?

62. The following SAS program is submitted:

data work.test;

Author = 'Agatha Christie';

First = substr(scan(author,1,' ,'),1,1);

run;

Which one of the following is the length of the variable FIRST in the output data set?

63. 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?

64. Given the SAS data set SASDATA TWO:

SASDATA TWO

XY

52

31

56

The following SAS program is submitted:

data sasuser.one two sasdata.three;

set sasdata two;

if x = 5 then output sasuser.one;

else output sasdata two;

run;

What is the result?

65. This question will ask you to provide a missing option. Given the following SAS program:





Which option needs to be added to wrap the labels to the next line whenever it encounters an asterisk?