SASInstitute A00-420 問題集

質問 1：
Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?
A. PROC GLM
B. PROC FREQ
C. PROC MEANS
D. PROC SQL
正解：B

質問 2：
Given the following CASL program:
proc cas;
table.tableInfo result=res / caslib="casuser";
do row over res.tableInfo;
print row;
end;
run;
quit;
Which statement best describes the variable row in the above program?
A. Row is string type variable that contains the name of a table in caslib casuser.
B. Row is an array containing the values with information on each table in caslib casuser.
C. Row is comma separated string containing name and additional information of tables in caslib casuser.
D. Row is a dictionary containing key=value pairs with information on each table in caslib casuser.
正解：D

質問 3：
Which PROC CAS step will transpose the CLASS table so that the values of the NAME column are used to create the column names in the output table?
A. proc cas;
transpose.transpose /
table={caslib="casuser", name="class", groupby={name="name"}},
casout={caslib="casuser", name="outclass", replace=true};
quit;
B. proc cas;
transpose.transpose /
table={caslib="casuser", name="class"} ,
id={"name"},
casout={caslib="casuser", name="outclass", replace=true};
quit;
C. proc cas;
transpose.transpose /
table={caslib="casuser", name="class", orderby={name="name"}},
id={"age"},
casout={caslib="casuser", name="outclass", replace=true};
quit;
D. proc cas;
transpose.transpose /
table={caslib="casuser",name="class"},
transpose={"name"},
casout={caslib="casuser", name="outclass", replace=true};
quit;
正解：B

質問 4：
Which CAS-enabled procedure is used to perform factor analysis on CAS tables?
A. CASFACTOR
B. CASPROC
C. CASANALYZE
D. CASSCORE
正解：A

質問 5：
The following code is executed multiple times:
data casuser.eurorders;
set casuser.orders end=eof;
if Continent="Europe" then EurOrders+1;
if eof=1 then output;
keep EurOrders;
run;
proc print data=casuser.eurorders;
run;
Will the rows in the output table be sorted the same way for each execution and why?
A. No, because the CAS Controller randomly reads the casuser.eurorders table when processing the proc print.
B. Yes, because by default CAS sorts the output table.
C. Yes, because only one row will be printed.
D. No, because each thread inserts a row into the casuser.eurorders table when it ends.
正解：D

質問 6：
Which program will successfully load cars.csv from the casuser caslib data source to an in-memory table named cars?
A. proc cas;
table.loadTable /
caslib="casuser"
path="/home/&sysuserid/casuser/cars.csv"
casout={caslib="casuser", name="cars"};
quit;
B. proc cas;
table.loadTable /
incaslib="casuser"
casdata="/home/&sysuserid/casuser/cars.csv"
outcaslib="casuser"
casout="cars";
quit;
C. proc cas;
table.loadTable /
incaslib="casuser"
casdata="cars.csv"
outcaslib="casuser"
casout="cars";
quit;
D. proc cas;
table.loadTable /
caslib="casuser"
path="cars.csv"
casout={caslib="casuser", name="cars"};
quit;
正解：D

質問 7：
Which CAS action is used to delete a CASLIB?
A. EXPORT
B. DROP TABLE
C. CASLIB
D. ALTER TABLE
正解：C

質問 8：
The regnm format has been created and stored in an CAS format library.
Which program associates the format regnm with the region column in the orders table?
A. proc casutil;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
format region regnm.;
quit;
B. proc casutil;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public";
quit;
C. proc casutil;
load data=work.orders casout="orders" outcaslib="public";
format region regnm.;
quit;
D. proc casutil;
format region regnm.;
load data=work.orders casout="orders" outcaslib="public"
format=yes;
quit;
正解：B