Search - WeAreCAS

Code SAS

Voir

Time Series Transformation with PROC TSMODEL and TSL

proc print data=mycaslib.timeseries; run; proc print data=mycaslib.outarray; run; proc print data=mycaslib.outscalar; run;

Code SAS

Voir

Appending two CAS tables

cas; caslib _all_ assign; %put &_sessref_;

Code SAS

Voir

Appending two CAS tables

proc cas; deepLearn.dlJoin / annotatedTable = {name = "CARS2", caslib="CASUSER"} table = {name = "CARS2", caslib="CASUSER"} id = "_id_" joinType = "APPEND" casout = {name = "CARS", caslib="CASUSER", replace=TRUE} ; print "Appending CASUSER.CARS2 to CASUSER.CARS"; run; quit;

Code SAS

Voir

Character to VARCHAR type conversion when loading into CAS

libname CASWORK cas caslib=casuser; options USER = CASWORK; %put &_sessref_;

Code SAS

Voir

Character to VARCHAR type conversion when loading into CAS

proc cas; file log; table.dropCaslib / caslib='sas7bdat' quiet = true; run; table.dropCaslib / caslib='sashdat' quiet = true; run; addcaslib / datasource={srctype="path"} name="sas7bdat" path="&datapath" ; run; quit; /* Binds all CAS librefs and default CASLIBs to you...

Code SAS

Voir

Character to VARCHAR type conversion when loading into CAS

proc casutil; load casdata="table_with_char.sas7bdat" incaslib="sas7bdat" outcaslib="casuser" casout="table_with_varchar" importoptions=(filetype="basesas" varcharconversion=16) replace; run;

Code SAS

Voir

Character to VARCHAR type conversion when loading into CAS

proc cas; sessionProp.setSessOpt / caslib="casuser"; run; table.columninfo / table="table_with_varchar"; quit;

Code SAS

Voir

Rename a CAS table

libname CASWORK cas caslib=casuser; options USER = CASWORK; %put &_sessref_; data CASWORK.baseball; set sashelp.baseball; run; %let mydate=20Apr2020; %put &mydate; options caslib="casuser";

Code SAS

Voir

Rename a CAS table

PROC CAS; table.alterTable / caslib="casuser" name="baseball" rename="baseball&mydate"; quit;

Code SAS

Voir

Baseball Statistics Analysis with CAS

cas; caslib _all_ assign;