A00-415 Dumps (V8.02) – Achieve Your SAS Viya Fundamentals of Programming Certification Goals with Proven Study Materials

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

2. Which CAS action is used to convert a character variable to a numeric variable in a CAS table?

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

4. Given the following SAS program?

caslib _all_ assign;

proc sgplot data=casuser.cars;

vbar Make;

run;

What will the program do?

5. Which statement is true for the table.copyTable action?

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

7. Which programming language is primarily used in SAS Viya?

8. Which CAS action is used to compute the frequency count of unique values in a column of a CAS table?

9. Which PROC CASUTIL statement successfully applies the regnm format to the Region column of the sales table in the public caslib?

10. Which CAS action is used to delete rows from a CAS table?

11. Which statement about the CASL language is true?

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

13. Which statement about CASL is true?

14. Which CAS action is used to delete a CAS table from memory?

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

16. How can you define a user-defined format in SAS?

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

18. Which CAS-enabled procedure allows the use of user-defined formats for data summarization?

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

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

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

22. What does CAS stand for in CAS language programming?

23. Which CAS-enabled procedure is used to generate descriptive statistics for CAS tables?

24. What is the main purpose of the DATA step in SAS Viya?

25. Given the following array: x={"May", "August", "September"};

What is the correct reference to the element containing the value May?

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

27. Which procedure can run in CAS?

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

29. Which CAS action is used to calculate the frequency and percentage of values for categorical variables in a CAS table?

30. In the space provided, enter the text for ensuring the table is available to any subsequent CAS session.

table.loadTable / caslib="public", path="sales.xlsx",

casOut={caslib="public", name="sales",______=true};

31. Which DATA step function is supported in CAS?

32. Which code can be used to load a SAS data set, sashelp.cars, into caslib public?

33. What is the purpose of the VALUE statement in PROC FORMAT?

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

35. Which CAS-enabled procedure is used to perform market basket analysis?

36. Which CASL program correctly runs two DATA step programs that are stored in separate source blocks named Program1 and Program2?

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

38. Which CAS action is used to perform a join operation between two CAS tables based on a common key variable?

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

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

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

42. Which statement will display column name, type, label and format information for the clientes table in the casuser caslib?

43. In which situation is it best to leverage the CAS server?

44. Which DATA step function is used to concatenate character variables in CAS programming?

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

46. What is the purpose of the GROUP BY clause in SQL programming?

47. Given the following log output:

- NOTE: The WHERE data set option on the DATA statement is not supported with DATA step in Cloud Analytic Services.

- NOTE: Could not execute DATA step code in Cloud Analytic Services. Running DATA step in the SAS client.

- NOTE: There were 19 observations read from the data set CASUSER.CLASS.

- NOTE: The data set CASUSER.CLASS2 has 1 observations and 5 variables.

Which DATA step program produced the above log output?

48. Which CAS action is used to execute a DATA step program in SAS CAS?

49. Which PROC TRANSPOSE step will execute entirely in CAS?

50. Which of the following statements about the CAS server is true?

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

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

53. What is the primary programming language used in SAS Viya?

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

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

56. Which CAS action is used to calculate summary statistics for variables in a CAS table?

57. What is CAS in SAS Viya?

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

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

60. Which CAS action is used to merge two or more CAS tables based on a common key variable?

61. Which CAS action is used to calculate the standard deviation, variance, and range for numeric variables in a CAS table?

62. Using the altertable action, which is the correct statement to rename the make column to veh_make in a CAS table?

proc cas;

table.altertable /

caslib="casuser", name="cars",

<enter code

segment here>;

quit;

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

64. Assume all caslib names follow libref naming conventions.

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

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

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

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

68. Which program will display ODS output?

69. Which CAS action is used to create a new variable in the DATA step?

70. Which CAS-enabled procedure is used to perform clustering analysis on CAS tables?

71. Which CAS action is used to append rows to an existing CAS table?

72. What is the purpose of the BY statement in CAS language programming?

73. DATA step performance in CAS is most affected:

74. A CAS table has a CHAR column called FirstName with a length of 10.

How many bytes are used to store the value "Inez" in the column FirstName?

75. Given the following program:

data casuser.noInput / sessref=casauto;

   x=1;

run;

Which statement is true?

76. Which programming language is primarily used in CAS?

77. Which CAS action is used to filter rows in a CAS table based on specified conditions?

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

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

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

81. Which statement is used to create a new variable in SAS Viya?

82. Which PROC MDSUMMARY step produces results?

83. Which SAS component enables CAS-enabled procedures?

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

85. Which CAS action is used to rename variables in a CAS table?

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

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

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

89. Which CAS action is used to remove duplicate records from a CAS table?

90. Which SAS procedure is used for generating descriptive statistics?

91. Which CAS statement is used to assign a CAS table to a CAS library?

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

93. In the deduplication.deduplicate action, which parameter eliminates rows with duplicate group-by variable values?

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

95. What data types does FedSQL support in CAS?

96. Which CASL program will fetch all 428 rows from the cars table?

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

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

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

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