Search Results

Understanding and Managing Caslibs in SAS Viya

CAS mySession host="myServer.com" SESSOPTS=(CASLIB=casuser TIMEOUT=999 LOCALE="en_US"); /* Assignation d'une Caslib Hive Globale */ caslib hivelib desc="HIVE Caslib" datasource=(SRCTYPE="HIVE",SERVER="myServerHadoop.com", HADOOPCONFIGDIR="/opt/sas/hadoop/client_conf/", HADO...

Understanding and Managing Caslibs in SAS Viya

Understanding and Managing Caslibs in SAS Viya

PROC CAS; table.dropCaslib caslib="NomDeLaCaslib" quiet=TRUE; run; quit;

Transferring In-Memory Data Between CAS Servers

CAS transfersess; PROC CAS; /* Création de la caslib 'transfer' qui pointe vers la source */ table.addcaslib / name="transfer", dataSource={ srctype="CAS", /* Le type magique */ user="mon_user", password="mon_password", /* À encoder...

Transferring In-Memory Data Between CAS Servers

PROC CAS; /* Copie de la table de 'transfer' vers 'VAModels' locale */ table.loadtable / caslib="transfer" path="MA_TABLE_SOURCE" casout={caslib="VAModels", name="MA_TABLE_CIBLE", promote=TRUE}; QUIT;

Transferring In-Memory Data Between CAS Servers

PROC CAS; /* Écriture physique sur le disque de la cible */ table.save / caslib="VAModels" name="MA_TABLE_CIBLE" table={caslib="VAModels", name="MA_TABLE_CIBLE"} replace=True; QUIT;

How to retrieve the memory size of all tables in a CASLIB?

/* Ce code ne fonctionnera pas */ proc cas; table.tabledetails / name="%" caslib="MaLib"; quit;

How to retrieve the memory size of all tables in a CASLIB?

cas mycas; libname casuser cas caslib=casuser; proc casutil; load data=sashelp.cars outcaslib="casuser" casOut="cars" replace; load data=sashelp.class outcaslib="casuser" casOut="class" replace; load data=sashelp.baseball outcaslib="casuser" casOut="baseball" replace; run;

How to retrieve the memory size of all tables in a CASLIB?

proc cas; /* 1. Récupérer la liste de toutes les tables de la librairie */ table.tableinfo result=rc / caslib="casuser"; /* Variable pour gérer la syntaxe d'ajout (append) après la première itération */ fragment=';'; /* 2. Boucler sur chaque table trouvée */ ...

Deduplication of CAS tables: Why your Hash Tables fail and how to correct it

proc cas; deduplication.deduplicate / table={caslib="casuser", name="ma_table_source", groupBy={"var_cle1", "var_cle2"}} noDuplicateKeys=true casOut={name="ma_table_dedoublonnee", caslib="casuser", replace=true}; quit;