Search Results

SAS Viya Tutorial: Everything About the table.tableInfo Action

cas; /* Création de plusieurs tables pour l'exemple */ DATA casuser.donnees_2023_Q1; ID=1; RUN; DATA casuser.donnees_2023_Q2; ID=2; RUN; DATA casuser.donnees_2024_Q1; ID=3; RUN; PROC CAS; /* Rechercher toutes les tables commençant par "donnees_2023_" */ TABLE.tableInfo RESULT=r...

SAS Viya Tutorial: Everything About the table.tableInfo Action

cas; /* Création d'une table avec un nom complexe */ DATA casuser."resultat_final_%_test"; ID=10; Score=95.5; RUN; PROC CAS; TABLE.tableInfo RESULT=r_escape / name="resultat_final_\%_test" /* Le \ protège le % */ caslib="casuser" wildIgnore=FALSE ...

SAS Viya Optimization: Mastering Implicit Pass-Through with FedSQL

caslib pg_db1 datasource=(srctype="postgres", ...); proc fedsql sessref=mySession _method; create table casuser.myresults{options replace=true} as select film.title, film_category.category_id from pg_db1."film" as film, pg_db1."film_category" as film_category where...

SAS Viya Optimization: Mastering Implicit Pass-Through with FedSQL

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

SELECT ... FROM CONNECTION TO nom_caslib ( votre_requête_native_ici )

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;

SAS Tutorial: Applying SAS Date Formats with PROC FEDSQL

proc casutil; altertable casdata="ma_table" incaslib="casuser" columns={ {name="ma_date_raw", format="date9.", label="Date de l'événement"} }; 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