Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.101
Which one of the following SAS statements renames two variables?
-
set work.dept1
work.dept2(rename = (jcode = jobcode) (sal = salary));
-
set work.dept1
work.dept2(rename = (jcode = jobcode sal = salary));
-
set work.dept1
work.dept2(rename = jcode = jobcode sal = salary);
-
set work.dept1
work.dept2(rename = (jcode jobcode) (sal salary));
Correct Answer: B
Question No.102
Which one of the following SAS procedures displays the data portion of a SAS data set?
-
PRINT
-
FSLIST
-
CONTENTS
-
DATASETS
Correct Answer: A
Question No.103
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;
-
Correct Answer: D
Question No.104
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?
A. |
14 |
B. |
15 |
C. |
1151960 |
D. |
#39;1/15/1960#39; |
Correct Answer: A
Question No.105
The following SAS program is submitted:
What is the value of the variable Prod in the output data set?
A. |
6 |
B. |
7 |
C. |
8 |
D. |
. (missing numeric) |
Correct Answer: B
Question No.106
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
Correct Answer: C
Question No.107
The following SAS program is submitted: libname company #39;SAS-data-library#39;; 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?
-
COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
-
COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
-
COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.
-
COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber
Correct Answer: A
Question No.108
The following SAS program is submitted: libname sasdata #39;SAS-data-library#39;;
data test;
set sasdata.chemists; if jobcode = #39;chem3#39;
then description = #39;Senior Chemist#39;; else description = #39;Unknown#39;;
run;
A value for the variable JOBCODE is listed below: JOBCODE
CHEM3
Which one of the following values does the variable DESCRIPTION contain?
-
chem3
-
Unknown
-
Senior Chemist
-
#39; #39; (missing character value)
Correct Answer: B
Question No.109
The following SAS program is submitted: data work.test;
First = #39;Ipswich, England#39;; City = substr(First,1,7);
City_Country = City!!#39;, #39;!!#39;England#39;;
run;
Which one of the following is the value of the variable CITY_COUNTRY in the output data set?
-
Ipswich!!
-
Ipswich, England
-
Ipswich, #39;England#39;
-
Ipswic h, England
-
Correct Answer: B
Question No.110
The following SAS program is submitted: data allobs;
set sasdata.origin (firstobs = 75 obs = 499); run;
A. |
424 |
B. |
425 |
C. |
499 |
D. |
1000 |
The SAS data set SASDATA.ORIGIN contains 1000 observations. How many observations does the ALLOBS data set contain?
Correct Answer: B
Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF