Search - WeAreCAS

Code SAS

Voir

Smart Partitioning: How to Filter and Append Large-Scale CAS Tables in One Step

/* Charger la table SASHELP.CLASS en CAS */ proc casutil; load data=sashelp.class outcaslib="casuser" casout="class_source" replace; run; /* Créer une table cible vide avec la même structure en CAS */ data casuser.class_target; set casuser.class_source(obs=0); run; proc cas; /* Ajou...

Code SAS

Voir

Smart Partitioning: How to Filter and Append Large-Scale CAS Tables in One Step

/* Charger la table SASHELP.CLASS en CAS */ proc casutil; load data=sashelp.class outcaslib="casuser" casout="class_full" replace; run; /* Créer une table cible avec quelques données initiales */ data casuser.class_filtered; input Name $ Sex $ Age Height Weight; datalines; Alfred...

Code SAS

Voir

SAS Viya Memory Optimization: Saving Space with CAS Table Compression

/* Établit une connexion CAS (à adapter à votre environnement) */ options casport=5570 cashost="cloud.example.com"; /* Crée une table SASHELP simple à charger */ data _null_; set sashelp.class; file "/tmp/class.csv" dlm=','; if _n_ = 1 then put 'Name,Sex,Age,Height,Weight'; put n...

Code SAS

Voir

How to Filter SAS Data Faster: Mastering WHERE, KEEP, and Observation Options

data class; set sashelp.class; where age>12 and height>=67; run; proc print data=class; run;

Code SAS

Voir

Modern SAS Data Architecture: Leveraging Cloud (CAS) and Distributed Engines

libname myfiles v9 'library-path'; data myfiles.myclass; set sashelp.class; run;

Code SAS

Voir

WHERE vs. IF: 5 Pro-Tips for Faster Data Filtering in SAS Viya

data class; set sashelp.class; where sex="M" and age >= 15; run; proc print data=class; run;

Code SAS

Voir

WHERE vs. IF: 5 Pro-Tips for Faster Data Filtering in SAS Viya

data class; set sashelp.class; where sex="M" or age>=15; run; proc print data=class; title 'OR finds all Males and Anyone 15 Years or Older'; run;

Code SAS

Voir

WHERE vs. IF: 5 Pro-Tips for Faster Data Filtering in SAS Viya

data class; set sashelp.class; where age < 15 and sex NE "M"; run; proc print data=class; title 'Finds Females Older less than 15 Years'; run;

Code SAS

Voir

WHERE vs. IF: 5 Pro-Tips for Faster Data Filtering in SAS Viya

data class; set sashelp.class; where age>15 or height

Code SAS

Voir

WHERE vs. IF: 5 Pro-Tips for Faster Data Filtering in SAS Viya

data class; set sashelp.class; where (age>15 or height