Practice Free A00-420 Exam Online Questions
Which statement is used to create a new variable in SAS Viya?
- A . IF-THEN statement
- B . DROP statement
- C . RENAME statement
- D . LENGTH statement
Complete the following FedSQL code to convert the character variable markup to a numeric variable.
proc cas;
session mysess;
fedSql.execDirect /
query="create table casuser.cars_fedsql {options replace=true} as
select make, model, mpg_city, mpg_highway, <insert code segment here> as
markup_N
from casuser.cars";
run;
- A . put(markup,’best12.’)
- B . inputn(markup,’best12.’)
- C . cast(markup,’best12.’)
- D . input(markup,’best12.’)
Which CAS action is used to identify potential duplicate records in a CAS table?
- A . cas.duplicate
- B . cas.identify
- C . cas.verify
- D . cas.check
Which CAS action is used to split a string variable into multiple variables based on a delimiter in a CAS table?
- A . cas.extract
- B . cas.split
- C . cas.parse
- D . cas.separate
Which CASL statement correctly saves a SAS data set keeping only the empid and hrdate variables?
- A . table.save / caslib="hr", exportoptions={filetype="basesas"}, name="hiredate",
table={caslib="casuser", name="emp",
keep={{name="empid"}, {name="hrdate"}}}; - B . table.save / caslib="hr", exportoptions={filetype="sas7bdat"}, name="hiredate",
table={caslib="casuser", name="emp",
vars={{name="empid"}, {name="hrdate"}}}; - C . table.save / caslib="hr", exportoptions={filetype="basesas"}, name="hiredate",
table={caslib="casuser", name="emp",
vars={"empid", "hrdate"}}; - D . table.save / caslib="hr", exportoptions={filetype="sas7bdat"}, name="hiredate",
table={caslib="casuser", name="emp",
keep={"empid", "hrdate"}};
In the DATA step, which statement is used to conditionally execute code?
- A . IF-THEN statement
- B . MERGE statement
- C . SELECT statement
- D . PROC statement
What is the primary advantage of using CAS-enabled procedures in SAS?
- A . Faster processing of large datasets
- B . Better visualization capabilities
- C . Easier data preparation
- D . Enhanced modeling techniques
Which statement is true about the Compute Server?
- A . It processes programs written in SAS, Python, Java, and other open source client languages.
- B . It generally outperforms the CAS server for data sources that are larger than 50 Gigabytes.
- C . It processes distributed data in multiple threads.
- D . It supports the creation and execution of Macro programs.
When specified on the PROC SUMMARY statement, which statistic causes processing to occur on the Compute Server?
- A . MIN
- B . MEAN
- C . SKEW
- D . STD
Which CAS-enabled procedure is used for data exploration and visualization?
- A . PROC MEANS
- B . PROC SQL
- C . PROC FREQ
- D . PROC SGPLOT