- All Exams Instant Download
Complete the code below to create an in-memory table named cars_cas in the casuser caslib.
Complete the code below to create an in-memory table named cars_cas in the casuser caslib. proc casutil; load data=sashelp.cars outcaslib="casuser" casout=__________; run;View AnswerAnswer: "cars_cas"
Which SAS program will correctly accumulate a total of the salary variable and store it in the variable totalSalary?
The table casuser.employees is partitioned onto 3 CAS worker nodes. Which SAS program will correctly accumulate a total of the salary variable and store it in the variable totalSalary? A) B) C) D) A . Option AB . Option BC . Option CD . Option DView AnswerAnswer: B
Which CAS action is used to create a new variable in a CAS table based on a conditional expression?
Which CAS action is used to create a new variable in a CAS table based on a conditional expression?A . cas.deriveB . cas.calculateC . cas.transformD . cas.generateView AnswerAnswer: A
Which CAS action is used to execute SQL queries in SAS CAS?
Which CAS action is used to execute SQL queries in SAS CAS?A . SQLB . RUNC . SUBMITD . EXECUTEView AnswerAnswer: A
Which CAS action produces the same result as the code above without ERROR if you run it twice?
Given the following SAS program: proc mdsummary data=casuser.orders; var RetailPrice; output out=casuser.orders_sum; run; Which CAS action produces the same result as the code above without ERROR if you run it twice?A . proc cas; simple.summary / table={name="orders", caslib="casuser"}, input={"RetailPrice"}, casOut={name='orders_sum'}; quit;B . proc cas; simple.mdsummary / table={name="orders", caslib="casuser"}, input={"RetailPrice"}, casOut={name='orders_sum', replace=true}; quit;C . proc cas; simple.summary / table={name="orders", caslib="casuser"}, input={"RetailPrice"}, casOut={name='orders_sum', replace=true}; quit;D ....
Which CASL program will fetch all 428 rows from the cars table?
Which CASL program will fetch all 428 rows from the cars table?A . proc cas; table.fetch / table={name="cars", caslib="casuser"}, from=1, to=1000; quit;B . proc cas; table.fetch / table={name="cars", caslib="casuser"}, from=1, to=_all_; quit;C . . proc cas; table.fetch / table={name="cars", caslib="casuser"}, from=1, to=_maxrows_; quit;D . proc cas; table.fetch / table={name="cars", caslib="casuser"},...
Which CAS action is used to generate descriptive statistics for numeric variables in a CAS table?
Which CAS action is used to generate descriptive statistics for numeric variables in a CAS table?A . cas.summarizeB . cas.statisticsC . cas.describeD . cas.profileView AnswerAnswer: C
Which statement correctly creates a global caslib called mycas that is connected to the /workshop/data location?
Which statement correctly creates a global caslib called mycas that is connected to the /workshop/data location?A . caslib mycas path="/workshop/data" global;B . caslib path="/workshop/data" mycas global;C . caslib path="/workshop/data" mycas promote;D . caslib mycas path="/workshop/data" promote;View AnswerAnswer: A
What is the purpose of the GROUP BY clause in SQL programming?
What is the purpose of the GROUP BY clause in SQL programming?A . To sort the result setB . To filter rows based on conditionsC . To define the output columnsD . To group rows based on common valuesView AnswerAnswer: D
Which CAS action is used to filter rows in a CAS table based on specified conditions?
Which CAS action is used to filter rows in a CAS table based on specified conditions?A . cas.selectB . cas.filterC . cas.whereD . cas.subsetView AnswerAnswer: C
