최신SASInstitute SAS Base Programming for SAS 9 - A00-211무료샘플문제
문제1
The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City_Country = substr(First,1,7)!!', '!!'England';
run;
Which one of the following is the length of the variable CITY_COUNTRY in the output data set?
The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City_Country = substr(First,1,7)!!', '!!'England';
run;
Which one of the following is the length of the variable CITY_COUNTRY in the output data set?
정답: D
문제2
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?
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?
정답: C
문제3
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?
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?
정답: C
문제4
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?
Enter your numeric answer in the space below.
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?
Enter your numeric answer in the space below.
정답:
2
문제5
The following program is submitted:
proc contents data=_all_;
Which statement best describes the output from the submitted program?
The following program is submitted:
proc contents data=_all_;
Which statement best describes the output from the submitted program?
정답: B
문제6
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?
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?
정답: D
문제7
Given the following raw data records:
The following output is desired:
Which SAS program correctly reads in the raw data?
Given the following raw data records:
The following output is desired:
Which SAS program correctly reads in the raw data?
정답: C
문제8
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
정답: D
문제9
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?
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?
정답: A
문제10
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?
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
문제11
This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:
The following program is submitted:
Which statement should be inserted to produce the following output?
This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:
The following program is submitted:
Which statement should be inserted to produce the following output?
정답: C
문제12
Given the following SAS data set WORK.SALES:
The following SAS program is submitted:
Which output is produced?
Given the following SAS data set WORK.SALES:
The following SAS program is submitted:
Which output is produced?
정답:
Pending
문제13
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?
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?
정답: B