A00-420 Dumps (V8.02) – Pass Your SAS Viya Intermediate Programming Exam Effectively

1. Given the following SAS program:

data casuser.national;

   set casuser.baseball(where=(league='National'));

   r=ranuni(625);

   drop league;

run;

Why is the above program processed by the Compute Server rather than the CAS server?

2. Which CAS action is used to execute SQL queries in SAS CAS?

3. Which CAS statement is used to join two or more CAS tables based on a common key variable?

4. Which CAS action is used to perform data profiling to analyze the distribution of values in a CAS table?

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? 

6. Which SAS Viya component allows users to create and manage machine learning models?

7. Which SAS Viya procedure is used for data summarization and descriptive statistics?

8. Which function is used to calculate the mean of a variable in SAS Viya?

9. Which DATA step statement is used to read data from an external file in CAS programming?

10. Which CAS action is used to calculate the correlation matrix for numeric variables in a CAS table?

11. 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?

12. Which CAS-enabled procedure is used to combine multiple CAS tables based on a common key variable?

13. Which variables must be included in the CAS table that stores DATA step code to be executed by the dataStep.runCodeTable action?

14. Which CAS action is used to create a new CAS table based on specified conditions?

15. Which DATA step will NOT run in CAS?

16. What is the purpose of the LIBNAME statement in SAS Viya?

17. Which PROC CASUTIL step suppresses error messages if the table is not found in-memory?

18. Which data format should be used when saving a CAS table so that it will later load into CAS memory the fastest?

19. In the following code, complete the PRINT statement to print only rows where column begins with MPG:

proc cas;

simple.summary result=res /

table={name="cars"};

resultTable = res.summary;

print <insert code segment

here>;

run;

20. Which CAS-enabled procedure is used to import data into a CAS table?

21. Which CAS-enabled procedure is used for regression analysis and modeling?

22. Which PROC CASUTIL step correctly saves a CSV file in the casuser caslib and overwrites any files with the same name?

23. 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;

24. In SAS Viya, what is the purpose of the LIBNAME statement?

25. Which statement correctly creates a global caslib called mycas that is connected to the /workshop/data location?

26. The dataPreprocess.impute action preforms data matrix (variable) imputation.

Which imputation methods can be used?

27. Which statement is true about SAS Viya?

28. Which CAS action is used to create a new CAS table by concatenating two or more existing CAS tables?

29. Which Compute Server system option prevents inadvertently moving large in-memory tables to the Compute Server?

30. Which SQL clause is used to filter rows in a CAS table based on specified conditions?

31. Which CAS-enabled procedure is used to apply user-defined formats to variables?

32. Which SAS Viya procedure is used for statistical modeling and regression analysis?

33. Which statement about the CASL language is true?

34. Which PROC MDSUMMARY step produces results?

35. Which CAS action is used to calculate the total count, distinct count, and missing count for variables in a CAS table?

36. Which CAS action is used to validate the integrity of relationships between variables in a CAS table?

37. How can you view the contents of a CAS table?

38. Complete the SAS program below to generate a table named cost_cont in the casuser caslib that contains the statistics for each value of continent.

proc mdsummary data=casuser.orders;

var cost;

groupby continent /_______;

run;

39. What is the purpose of the SAS Explorer in SAS Studio?

40. Which statement is true about the Compute Server?

41. Which CAS action is used to compute descriptive statistics for numeric variables in a CAS table?

42. Which SAS Viya component provides self-service data preparation capabilities?

43. Which CAS action is used to calculate the sum, minimum, maximum, and mean for numeric variables in a CAS table?

44. Which operator is used for assignment in SAS Viya?

45. Which CAS action is used to calculate the frequency distribution of a categorical variable in a CAS table?

46. Which statement is FALSE regarding loading data into CAS?

47. Which CAS action is used to calculate the mode(s) of a categorical variable in a CAS table?

48. What is the purpose of the BY statement in the DATA step?

49. Which CAS action is used to generate a summary report of missing values in a CAS table?

50. Which CAS statement is used to select specific columns from a CAS table?

51. Which CAS-enabled procedure is used for descriptive statistics and data summarization?

52. Which statement will show all available caslibs in the log?

53. Which CAS action is used to perform aggregations and summary statistics?

54. The set parameter of the table.update CAS action requires a specific type of value.

Which type is correct?

55. Which CASL program correctly adds the Sales caslib to access data in the /data/sales folder?

56. What is the purpose of the SET statement in the DATA step?

57. Which statement can execute successfully using PROC FEDSQL?

58. In PROC CASUTIL, what does the LOAD FILE= statement do?

59. 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)

60. What is the purpose of the WHERE clause in CAS language programming?

61. Which SAS function is used to concatenate character variables?

62. In SAS Viya, what is the purpose of the SAS Studio application?

63. Which SAS Viya component is responsible for executing CAS-enabled procedures?

64. Which CASL program segment correctly defines a source block to be run from a subsequent action?

65. What is the file extension used for SAS Viya programs?

66. Which CAS action is used to perform outlier detection on numeric variables in a CAS table?

67. Which SAS Viya component is responsible for storing and managing user-defined formats?

68. What is the primary advantage of using CAS language programming in SAS?

69. Which CAS-enabled procedure is used to perform data partitioning?

70. Which SAS program will list tables contained in caslib public?

71. Which CAS-enabled procedure is used to perform text analytics?

72. What CASL data type is created from the following assignment statement?

half = 1/2;

73. Which programming language is used for SQL programming in SAS CAS?

74. Which programming language is used in the DATA step of SAS CAS?

75. Which statement is used to sort a SAS dataset in ascending order?

76. Which CAS action is used to retrieve a subset of rows and columns from a CAS table?

77. Which CAS action is used to compute the frequency distribution of a categorical variable in a CAS table?

78. Which CAS-enabled procedure is used for data exploration and visualization?

79. Which CASL program will create the sample2 table in the casuser caslib?

80. Which DATA step feature is NOT supported in CAS?

81. Which CAS action is used to import data into CAS?

82. Which CAS action is used to delete a CASLIB?

83. In the space below, add 1 character to complete the syntax.

proc cas;

table.tableDetails Answer

aslib="casuser", name=employees";

quit;

84. Which SQL clause is used to join multiple CAS tables based on a common key variable?

85. Which SQL clause is used to calculate summary statistics for variables in a CAS table?

86. Which CAS-enabled procedure is used for frequency analysis and cross-tabulations?

87. In the DATA step, which statement is used to conditionally execute code?

88. Which CAS-enabled procedure is used to perform data exploration and summarization?

89. Which CAS action is used to calculate the mean, median, and quartiles for numeric variables in a CAS table?

90. Which table.update parameter specifies the column to update?

91. Which CAS statement is used to load data from an external file into a CAS table?

92. If a dictionary named res contains a table named fetch, which statement will print the table?

93. Which action loads the cars.csv file from the casuser caslib into memory?

94. Assume all caslib names follow libref naming conventions.

Which code assigns librefs of the same name to each caslib?

95. What is the purpose of the CASLIB statement in SAS Viya?

96. You want to generate totals and averages by year for a very large Teradata table using SAS Viya programming methods.

What is the most efficient way to achieve this?

97. Which CAS action is used to create a new variable in a CAS table based on a conditional expression?

98. When specified on the PROC SUMMARY statement, which statistic causes processing to occur on the Compute Server?

99. Which DATA step function is supported in CAS?