Search - WeAreCAS

Code SAS

Voir

No Data Step Required: Creating Computed Columns on the Fly with table.fetch

/* Création d'une table de démonstration en mémoire CAS */ data casuser.ventes; input ID Produit $ Quantite Prix; datalines; 1 A 10 100 2 B 5 150 3 A 20 100 4 C 8 200 5 B 12 150 6 A 15 100 ; run; proc cas; session casauto; /* Afficher les lignes pour le produit 'A', en sélectionn...

Code SAS

Voir

No Data Step Required: Creating Computed Columns on the Fly with table.fetch

/* Création d'une table de démonstration en mémoire CAS */ data casuser.etudiants; input Nom $ Matiere $ Note; datalines; Alice Math 90 Bob Info 85 Alice Info 92 Charlie Math 78 Bob Math 88 ; run; /* Création d'un format personnalisé pour les notes */ proc format; value note_fmt ...

Code SAS

Voir

No Data Step Required: Creating Computed Columns on the Fly with table.fetch

proc cas; session casauto; /* Charger la table IRIS de SASHELP dans la caslib 'casuser' */ table.loadtable / caslib='casuser', path='iris.sashdat', casout={name='IRIS_CAS', replace=true}; /* Afficher les informations de la table chargée */ table.table...

Code SAS

Voir

SAS Viya to Excel: Automating Professional Reports with ODS EXCEL and CAS

/* 1. Création d'une table CAS d'exemple pour la démonstration */ /* Ceci rend l'exemple autonome, comme exigé. */ data casuser.qualifyapps; input Credit_Qualification $ Count; datalines; Bonne 100 Mauvaise 50 Inconnue 20 ; run; /* 2. Charger la table en mémoire CAS (si ce n...

Code SAS

Voir

Feature Engineering in CAS: How to Create Custom Categories from Continuous Data

data mycaslib.creditscores / sessref=mysession; infile datalines; input Age Credit_Score; datalines; 20 500 30 600 40 700 50 780 60 810 70 400 19 550 33 690 48 710 62 820 ; run; data mycaslib.creditqualify / sessref=mysession; set mycaslib.creditscores; length Age_Range $8; ...

Code SAS

Voir

High-Speed Aggregation: How to Filter and Group Data Instantly with SAS Viya

data creditqualify; length State $2. State_FIPS $2. Credit_Score 8; infile datalines; input State State_FIPS Credit_Score; datalines; NC NC 750 NC NC 700 CA CA 800 CA CA 650 TX TX 600 TX TX 720 NY NY 780 NY NY 690 ; run; proc cas; session mysession; simple.groupBy result=r stat...

Code SAS

Voir

Fixed vs. Variable: Why You Should Start Using VARCHAR in SAS Viya

/* Création d'une session CAS */ options casport=5570 cashost="localhost"; cas mysess; /* Utilisation d'une bibliothèque CAS */ libname mycas cas caslib=casuser; /* Création d'une table CAS avec divers types de données */ data mycas.datatypes_example; length char_var $10 varchar_var varchar...

Article

Voir

Monitoring CAS_CACHE_DISK: Under the Hood of SAS Viya Memory

SAS Cloud Analytic Services (CAS) is the in-memory execution engine of the SAS Viya platform. Its power lies in its ability to process massive volumes of data directly in RAM. However, a critical question often arises for administrators and architects: what happens when RAM is saturated or tables...

Article

Voir

Delayed Compilation and Execution in SAS: Is It Possible?

If you come from a traditional programming environment (like C, C++, or COBOL), you are used to a binary workflow: you write the code, compile it into an executable file (binary), and then execute that file later.A question often asked by experienced SAS developers is: Is it possible to compile S...

Article

Voir

Never Rewrite Your LIBNAMEs Again: How to Centralize Your SAS Libraries

If you work regularly with SAS, you know this frustrating scenario: you start a new program or a new module, and the first thing you have to do is copy-paste (or worse, retype) your LIBNAME statements to access your data.Not only is this repetitive, but it also poses a real maintenance problem. I...