Search Results

SAS Viya Tutorial: Pre-process Data in the Database Before CAS Loading

cas mysession; /* Définition de la connexion à Postgres */ caslib caspgr datasource=(srctype="postgres", database="DCON", server="...", ...) libref=caspgr; proc fedsql sessref=mysession; /* Création de la table résultante directement dans la RAM de CAS */ create table caspgr.revenues...

SAS Viya Tutorial: Pre-process Data in the Database Before CAS Loading

proc fedsql sessref=mysession; create table caspgr.StateSalesSummary as select customerstate, minquantity, maxquantity, sumquantity from connection to caspgr ( /* DEBUT DU SQL NATIF POSTGRES */ SELECT customerstate, min(quantity) as minquanti...

Advanced Tutorial: Manipulating Native JSON in SAS Viya with FedSQL

proc fedsql sessref=ma_session; create table cas.ma_table_cible as select * from CONNECTION TO nom_de_la_caslib ( /* Code SQL Natif (Postgres, Oracle, etc.) */ /* Invisible pour SAS */ ); quit;

Advanced Tutorial: Manipulating Native JSON in SAS Viya with FedSQL

proc fedsql sessref=mysession; create table cas.synthese_ventes as select region, total_ventes from connection to ma_lib_postgres ( /* Début du code natif PostgreSQL */ SELECT /* Extraction de la clé 'region' dans l'objet JSON */ d...

SAS and Hadoop: How to Maintain the Power of Parallel Processing

/* Exemple FedSQL exécuté DANS Hadoop */ proc fedsql sessref=myHadoopSession; select region, sum(sales) from HadoopLib.LargeSales group by region; quit;

SAS Tutorial: Applying SAS Date Formats with PROC FEDSQL

proc fedsql sessref=mysession; create table casuser.ma_table as select datepart(mon_timestamp) as ma_date_raw from source_table; quit;

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 standard (Session scope) */ caslib hivelib desc="HIVE Caslib" datasource=(SRCTYPE="HIVE",SERVER="myServerHadoop.com", HADOOPCONFIGDIR="/opt/sas/hadoop/client_...

Understanding and Managing Caslibs in SAS Viya

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...

CAS vs SAS: Understanding Data Step Performance and Behavior Differences