In a SAS Viya environment, a data engineer needs to restrict the size of a string variable to a maximum of 255 characters to ensure compatibility with an external system. Which column definition should be used to enforce this restriction while also optimizing storage for smaller strings?
A data analyst needs to run a data manipulation task that involves sorting a table by multiple columns, then creating a new column based on a conditional statement. Which of the following sets of actions should be used in the given scenario when programming in SAS Viya?
You are tasked to join two datasets named 'sales' and 'returns' in the CAS server to analyze the returned items and their original sales data. The 'sales' dataset contains a variable 'OrderID', and the 'returns' dataset contains a variable 'ReturnID', which maps to the sales order. What code snippet would efficiently join these two tables using SAS Viya's capabilities?
A programmer is using the SAS Viya environment for analysis and needs to write output data to a secured location that multiple users can access. The location is on a server where permissions are managed through access control lists. How should the programmer reference the secured location for the output data to ensure that the correct access controls are applied?
You are tasked with deploying a model that you developed in SAS Viya. The model files are currently stored on your local machine. When deploying the model to the SAS Viya environment, how do you ensure the model accesses the necessary files for execution?