Get Full Version of the Exam
http://www.EnsurePass.com/A00-201.html
Question No.81
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;
lt;insert BY statement heregt; run;
Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?
-
by Expenses IDNumber;
-
by IDNumber Expenses;
-
by ascending Expenses IDNumber;
-
by ascending IDNumber ascending Expenses;
Correct Answer: B
Question No.82
The value 110700 is stored in a numeric variable named SALARY. Which FORMAT statement displays the value as $110,700.00 in a report?
-
format salary comma11.2;
-
format salary dollar8.2;
-
format salary dollar11.2;
-
format salary comma8.2 dollar8.2;
Correct Answer: C
Question No.83
Which is a valid LIBNAME statement?
-
libname quot;_SAS_data_library_location_quot;;
-
sasdata libname quot;_SAS_data_library_location_quot;;
-
libname sasdata quot;_SAS_data_library_location_quot;;
-
libname sasdata sas quot;_SAS_data_library_location_quot;;
Correct Answer: C
Question No.84
The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable COUNTRYFEE with a format or 7.;
The following SAS program is submitted: data history;
format local fee country fee percent6.; set realestate;
local fee = local fee / 100; country fee = country fee / 100; run;
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?
-
LOCALFEE has format of 9. and COUNTRYFEE has a format of 7.
-
LOCALFEE has format of 9. and COUNTRYFEE has a format of percent6.
-
LOCALFEE has format of percent6. and COUNTRYFEE has a format of percent6.
-
The data step fails execution; there is no format for LOCALFEE
Correct Answer: C
Question No.85
Given the following raw data record:
-I10-I20-I 30
son Travis,
The following output is desired: Obs relation firstname
1 son Travis
Which SAS program correctly reads in the raw data?
-
data family ( dIm = `,#39;); infile `tile specification#39;; input relation $ firstname $; run;
-
options dIm = `,#39;; data family; infile `file specification#39;; input relation $ firstname $; run;
-
data family; infile `file specification#39; dIm = `,#39;; input relation $ firstname $; run;
-
data family; infile `file specification#39;; input relation $ firstname $ / dim = `,#39;; run;
Correct Answer: C
Question No.86
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=
Correct Answer: D
Question No.87
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.
Correct Answer: B
Question No.88
A user-defined format has been created using the FORMAT procedure. Where is it stored?
-
in a SAS catalog
-
in an external binary file
-
in a SAS dataset in the WORK library
-
in a SAS dataset in a permanent SAS data library
Correct Answer: A
Question No.89
The following SAS program is submitted: libname temp `SAS data library#39;;
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?
-
The program executes successfully and a temporary SAS data set is created.
-
The program executes successfully and a permanent SAS data set is created.
-
The program fails execution because the same SAS data set is referenced for both read and write operations.
-
The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
Correct Answer: B
Question No.90
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?
-
data set SASUSER.ONE has 5 observations data set SASUSER.TWO has 5 observations data set WORK.OTHER has 3 observations
-
data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 1 observations
-
data set SASUSER.ONE has 2 observations data set SASUSER.TWO has 2 observations data set WORK.OTHER has 5 observations
-
No data sets are output.
The DATA step fails execution due to syntax errors.
Correct Answer: A
Get Full Version of the Exam
A00-201 Dumps
A00-201 VCE and PDF