/* Create in-memory tables in CAS using CAS Libname engine */ libname caslib cas sessref=&cas_session tag=""; data caslib.COLUMNSAMPLE; input FLIGHT $3. +5 DATES $7. +3 DEPART $5. +2 ORIG $3. +3 DEST $3. +7 MILES +6 BOARDED +6 CAPACITY; datalines; 114 01MAR98 7:10 LGA LA...
/* Remove CAS session */ cas &cas_session. terminate;
/* Specify the DBMS engine, for example: ODBC */ %let srctype=odbc; %let cas_session = mysess; %let caslib_alias = datalib; /*Specify connection parameters within a string Edit the below variables with the required DBMS-specific conection options Also, specify such variables within the CONNOP...
/* Connect to CAS using cashost and casport, optional in SAS Studio */ /* options cashost="???????" casport=????; */ /* Create a CAS Session */ cas &cas_session;
proc cas; session &cas_session; action addCaslib caslib="&caslib_alias" datasource={ srctype="&srctype", user="&username", pass="&password", database="&database", schema="&schema", catalog="*"}; run; quit;
/* Proc cas loadtable action: loads entire table*/ proc cas; session &cas_session; action loadtable casout={name="SAMDATLOAD" replace=true} caslib="&caslib_alias" path="LOADSAMPLE"; run; quit;
/* Proc cas loadtable action with where parameter: subsets the input data */ proc cas; session &cas_session; action loadtable casout={name="SAMDATLOADWHERE" replace=true} caslib="&caslib_alias" where="FLIGHT = 114" path="LOADSAMPLE"; run; quit;
/* Proc cas loadtable action with vars parameter: specifies variables to load */ proc cas; session &cas_session; action loadtable casout={name="SAMDATLOADVARS" replace=true} caslib="&caslib_alias" vars={"FLIGHT", "ORIG", "DEST"} path="LOADSAMPLE"; run; quit;
/* Verify loadtable using caslib libref with CAS Libname engine to print in-memory tables*/ libname caslib cas sessref=&cas_session tag=""; proc print data=caslib.SAMDATLOAD; run; proc print data=caslib.SAMDATLOADWHERE; run; proc print data=caslib.SAMDATLOADVARS; run;
/* Clean-up: Delete files from data source associated with caslib */ proc cas; session &cas_session; action deleteSource caslib="&caslib_alias" source="LOADSAMPLE" ; run; quit;