A00-211 Practice Exam Questions with Answers SAS Base Programming for SAS (r) 9 Certification

The following SAS program is submitted once:

Which procedure output will appear in test.html?

The following SAS DATA step is submitted:

data work.accounting;

set work.department;

length jobcode $ 12;

run;

The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of 5. Which one of the following is the length of the variable JOBCODE in the output data set?

Given the data set WORK.DEPARTMENTS:

The following SAS program is submitted:

Which output will be generated?

The contents of the raw data file NAMENUM are listed below:

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

Joe xx

The following SAS program is submitted:

data test;

infile 'namenum';

input name $ number;

run;

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

There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted:

What will be the value of NewVar when SAS writes the last observation?

Which one of the following SAS statements renames two variables?

The following SAS program is submitted:

libname temp 'SAS-data-library';

data work.new;

set temp.jobs;

format newdate mmddyy10.;

qdate = qtr(newdate);

ddate = weekday(newdate);

run;

proc print data = work.new;

run;

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

What output is produced if April 15, 2000 falls on a Saturday?

The following SAS program is submitted:

Data WORK.COMPRESS;

ID = ‘1968 05-10 567’;

NewID = compress (ID, “-“);

run;

What will the value of NewID be in the WORK.COMPRESS data set?

The following SAS program is submitted:

If the value for the Alumcode is: ALUM2, what is the value of the variable Description?

Consider the following data step:

data WORK.NEW;

set WORK.OLD;

Count+1;

run;

The varaible Count is created using a sum statement. Which statement regarding this variable is true?

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 following SAS program is submitted:

data _null_;

set old (keep = prod sales1 sales2);

file 'file-specification';

put sales1 sales2;

run;

Which one of the following default delimiters separates the fields in the raw data file created?

The following SAS program is submitted:

data work.test;

Title = 'A Tale of Two Cities, Charles J. Dickens';

Word = scan(title,3,' ,');

run;

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

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

What issue generated the error in the log?

The following SAS program is submitted:

data work.staff;

JobCategory = 'FA';

JobLevel = '1';

JobCategory = JobCategory || JobLevel;

run;

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

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?

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?

The following SAS program is submitted:

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

The following SAS program is submitted:

data work.test;

array items{3} _temporary_;

run;

What are the names of the variable(s) in the WORKTEST data set?

The following SAS program is submitted:

proc means data = sasuser.shoes;

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

run;

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

Given the SAS data set ONE:

Given the SAS data set WORK.ONE:

The following SAS program is submitted:

Which report is produced?

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?

Given the SAS data set WORK.TEMPS:

The following program is submitted:

Which output is correct?

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

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?

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?

Given the SAS data set EMPLOYEE INFO:

EMPLOYEE_INFO

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 BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

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?

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?

Given the data set WORK.EMPDATA:

Which one of the following where statements would display observations with job titles containing the word 'Manager'?

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?

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 following SAS program is submitted:

data one;

addressl = ‘214 London Way’;

run;

data one;

set one;

address = tranwrd(address1, ‘Way’, ‘Drive’); run;

What are the length and value of the variable ADDRESS?

The following SAS program is submitted:

footnote1 ‘Sales Report for Last Month’;

footnote2 ‘Selected Products Only’;

footnote3 ‘All Regions’;

footnote4 ‘All Figures in Thousands of Dollars’;

proc print data = sasuser.shoes;

footnote2 ‘All Products’;

run;

Which footnote(s) is/are displayed in the report?

The following SAS program is submitted:

<_insert_ods_code_>

proc means data=SASUSER.SHOES;

where Product in ('Sandal' , 'Slipper' , 'Boot');

run;

<_insert_ods_code_>

Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?