最新的SASInstitute SAS Advanced Programming Exam for SAS 9 - A00-212免費考試真題
The following SAS program is submitted:
data temp;
array points{2,3}_temporary_;
run;
Which one of the following is the maximum number of elements that are stored?
data temp;
array points{2,3}_temporary_;
run;
Which one of the following is the maximum number of elements that are stored?
正確答案: D
Which one of the following is the purpose of the IDXNAME= data set option?
正確答案: A
This question will ask you to provide a segment of missing code.
Given data sets ONE and TWO with the same variables, the following SAS program is submitted:
In the text below, complete the following program so that it will produce the same results as the above program:
Case is ignored and standard SAS syntax rules apply.
Given data sets ONE and TWO with the same variables, the following SAS program is submitted:
In the text below, complete the following program so that it will produce the same results as the above program:
Case is ignored and standard SAS syntax rules apply.
正確答案:
CORR
Explanation:
Reference:
http://www.koerup.dk/Cert/0104/010405/010405.html
Explanation:
Reference:
http://www.koerup.dk/Cert/0104/010405/010405.html
Given the following SAS program:
proc sql;
select product, type, sum(sales) as revenue
from one
group by product, type;
quit;
Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing
REVENUE?
proc sql;
select product, type, sum(sales) as revenue
from one
group by product, type;
quit;
Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing
REVENUE?
正確答案: B
Which MACRO option is responsible for this partial SAS log?
正確答案: B
說明：（僅 Fast2test 成員可見）
Which one of the following should be avoided when creating and using an SQL procedure view?
正確答案: A
The SAS data set WORK.TEMP is indexed on variable Id:
The following SAS program is submitted:
The following SAS program is submitted:
正確答案: A
Given the SAS data set ONE:
ONE
NUM VAR
1 A
2 B
3 C
Which SQL procedure program deletes the data set ONE?
ONE
NUM VAR
1 A
2 B
3 C
Which SQL procedure program deletes the data set ONE?
正確答案: A
The following SAS program is submitted:
% macro loop;
data one;
% do I=1 %to 3;
var&I=&I;%
end
run;
% mend;
% loop
After this program executes; the following is written to the SAS log:
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
Which SAS system option displays the notes in the SAS log?
% macro loop;
data one;
% do I=1 %to 3;
var&I=&I;%
end
run;
% mend;
% loop
After this program executes; the following is written to the SAS log:
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
Which SAS system option displays the notes in the SAS log?
正確答案: A
Following SAS program is submitted:
data temp(<insert option here>);
infile 'rawdata';
input x $ y z;
run;
RAWDATA is a file reference to an external file that is ordered by the variable X.
Which option specifies how the data in the SAS data set TEMP will be sorted?
data temp(<insert option here>);
infile 'rawdata';
input x $ y z;
run;
RAWDATA is a file reference to an external file that is ordered by the variable X.
Which option specifies how the data in the SAS data set TEMP will be sorted?
正確答案: B