Get Instant Access to A00-231 Practice Exam Questions [Q104-Q126]

NO.104 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?

NO.105 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?

NO.106 Given the SAS data set WORK.ORDERS:

The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.
A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following: “Order 9341 shipped on 02FEB2009”.
Which of the following statement will correctly create the value and assign it to Note?

NO.107 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?

NO.108 Given the following raw data records in TEXTFILE.TXT:

The following output is desired:

Which SAS program correctly produces the desired output?

NO.109 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?

NO.110 The following SAS program is submitted:

Which statement is true about the output data set?

NO.111 The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?

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

NO.113 The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;
total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?

NO.114 The following SAS program is submitted:

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

NO.115 Given the following data step:

After data step execution, what will data set WORK.GEO contain?

NO.116 Given the SAS data set PRICES:
PRICES
prodid price
K12S5.10producttype
NETWORKsales
15returns
2
B132S 2.34HARDWARE30010
R18KY21.29SOFTWARE255
3KL8BY 6.37HARDWARE12515
DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672
The following SAS program is submitted:
data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = ‘HARDWARE’ then output HWARE; else if producttype = ‘NETWORK’ then output INTER; else if producttype = ‘SOFTWARE’ then output SOFT; run; How many observations does the HWARE data set contain?

NO.117 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?

NO.118 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?

NO.119 The following SAS program is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
jobcode=’FAl’;
run;
The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5.
What is the result?

NO.120 The following SAS program is submitted:
data WORK.ONE;
Text=’Australia, US, Denmark’;
Pos=find (Text,’US’,’i’,5);
run;
What value will SAS assign to Pos?

NO.121 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?

NO.122 Given the contents of the raw data file EMPLOYEE:
—-|—-10—-|—-20—-|—-30
Alan
19/2/2004
ACCT
Rob
22/5/2004
MKTG
MaryJane
14/3/2004
EDUC
The following SAS program is submitted:
data emps;
infile ’employee’;
input@1 name$
@15 date <insert INFORMAT here>
@25 department$;
run;
Which INFORMAT correctly completes the program?

NO.123 Given the following raw data record:
07Jan2005
Which INFORMAT reads this raw data and stores it as a SAS date value?

NO.124 The contents of the SAS data set PERM.JAN_SALES are listed below:
VARIABLE NAME TYPE
idnum character variable
sales_date numeric date value
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?

NO.125 The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?

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