Practice Free A00-420 Exam Online Questions
Which statement is used to sort a SAS dataset in ascending order?
- A . SORT DESCENDING
- B . PROC SORT
- C . ORDER BY
- D . SORT DSN
Which SAS Viya procedure is used for data exploration and analysis?
- A . PROC SQL
- B . PROC MEANS
- C . PROC FREQ
- D . PROC GLM
DATA step performance in CAS is most affected:
- A . when the NOTSORTED option is used in the BY statement.
- B . when the DESCENDING option is used in the BY statement.
- C . by the cardinality of the first variable listed in the BY statement.
- D . when data is not sorted prior to using a BY statement.
The set parameter of the table.update CAS action requires a specific type of value.
Which type is correct?
- A . an array of arrays
- B . a dictionary of arrays
- C . a dictionary of dictionaries
- D . an array of dictionaries
Given that this program:
simple.numRows /
table={caslib="casuser",name="cars"};
produces this output in the Log:
{numrows=428}
Which program produces the following output in the Log?
Table casuser.cars has 428 rows.
- A . simple.numRows results=x/
table={caslib="casuser", name="cars"};
print "Table casuser.cars has " x[numrows] "rows."; - B . simple.numRows results=x/
table={caslib="casuser", name="cars"};
print "Table casuser.cars has " numrows[x] "rows."; - C . simple.numRows result=x/
table={caslib="casuser", name="cars"};
print "Table casuser.cars has " numrows.x "rows."; - D . simple.numRows result=x/
table={caslib="casuser", name="cars"};
print "Table casuser.cars has " x.numrows "rows.";
Which statements are true about CASL? (Select two)
- A . CASL programs can include statements, actions, and functions.
- B . CASL running in CAS is always faster than processing on the Compute Server.
- C . CASL code is only written and submitted from SAS Studio.
- D . CASL programs are best suited for processing very large data.
What is the purpose of the WHERE clause in CAS language programming?
- A . To filter rows based on specified conditions
- B . To define the input data source
- C . To specify the output variables
- D . To join multiple tables together
Which DATA step statement is used to merge two or more CAS tables based on a common key variable?
- A . SET statement
- B . MERGE statement
- C . UPDATE statement
- D . MODIFY statement
Which CAS statement is used to select specific columns from a CAS table?
- A . CASTABLE
- B . CASSELECT
- C . CASCOLUMN
- D . CASWHERE
What is the purpose of the GROUP BY clause in SQL programming?
- A . To sort the result set
- B . To filter rows based on conditions
- C . To define the output columns
- D . To group rows based on common values