/* Proc cas columninfo action */ proc cas; table.columnInfo / table={name = "COLUMNSAMPLE", caslib = "&caslib_alias"}; run; quit;
/*Proc cas columninfo action with specified vars variable */ proc cas; table.columnInfo / table={name="COLUMNSAMPLE", caslib = "&caslib_alias" vars={"FLIGHT", "DATES", "BOARDED", "CAPACITY"}}; run; quit;
/*Proc cas columninfo action alternative method of specifying variables to display*/ proc cas; table.columnInfo / inputs = {{name="FLIGHT"},{name="BOARDED"}} table={name = "COLUMNSAMPLE", caslib = "&caslib_alias"}; run; quit;
/* 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...
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;