The DATA step is a fundamental component of SAS programming, enabling data manipulation and transformation. In the SAS Viya environment, the DATA step can execute not only in a traditional SAS session but also on the CAS server, leveraging distributed processing for increased performance.
This document explains how to group variables in descending order using the DATA Step BY statement, distinguishing its behavior in a local SAS session and in the CAS environment. It highlights the automatic processing of DATA Steps in a local SAS session when the DESCENDING option is used in CAS,...
This example shows how to use the `fedSql.execDirect` action to create a new CAS table by joining columns from two loaded tables. It also shows how to query the FedSQL output table and how to perform the join and query in a single FedSQL query. This assumes you are already connected to the CAS se...
This documentation describes the support for the SAS macro language within the SAS Viya platform. The macro language is used to generate code that can then be submitted to the CAS server for execution. It is important to note that the macro language itself does not execute directly on the CAS ser...
This document explains how to execute a SAS DATA step program in single-threaded mode within a CAS (Cloud Analytic Services) session, using the SINGLE= option.
This feature allows user-defined formats to be stored in SAS catalogs or in a format library on the CAS server. These formats can be used within a SAS session or promoted globally on CAS to be available for all sessions. Server-side formats are used when performing analysis based on formatted val...
In the SAS Viya platform, you can store user-defined formats in catalogs for use in a SAS session, or you can store them in a format library on the CAS server. Format libraries are associated with a CAS session, or they can be promoted to global scope to be available to all CAS sessions. User-def...
%macro _abend(arg1); ; %if "&sysenv"="BACK" %then %do; data _null_; put 'ERROR: Your SAS program will ABEND.'; abort abend &arg1; run; %end; %else %do; %put ERROR: A request has been made to ABEND your program.; %put However, since this appears to be an interactive session...
proc cas; session casauto; simple.groupBy result=r status=s / inputs={"DIV" "TEAM"}, weight="nhits", aggregator="SUM", table={name="baseball"}, casout={name="casl_baseball_groupby", replace=true}; run;
signon session1 sascmd="!sascmd -nosyntaxcheck -noterminal"; signon session2 sascmd="!sascmd -nosyntaxcheck -noterminal";