You are designing a table to store customer information for a loyalty program. One of the fields is 'BirthDate,' which stores the date of birth of each customer. What data type should you assign to 'BirthDate' to ensure proper date operations can be performed?
Consider a scenario where you want to calculate the sum of sales for each product category stored in a CAS table called 'sales_data'. The table contains a large number of product categories and sales values. Which procedure would you use to calculate these sums and save the results to a new CAS table efficiently?
During a CAS session, you want to analyze a large dataset that captures customer interactions. Your objective is to understand the distribution of the duration of these interactions. Considering that you're interested in the frequency distribution and descriptive statistics of a single variable, which procedure would you select?
When a user submits a PROC MEANS in a SAS Viya environment, the procedure is automatically directed to run in a specific execution context based on the data's location. Assuming the PROC MEANS is using a dataset that resides within the CAS server, where will the code execute?