Search - WeAreCAS

Code SAS

Voir

Go Cloud-Native: How to Convert and Upload SAS Data to Parquet on Google Cloud

This example shows how to create a Parquet table in a Google Cloud Storage bucket using the LIBNAME statement and PROC COPY, then display a portion of the data with PROC PRINT.

Code SAS

Voir

Utility macro library for table management and interface

%macro copy_dataset(in_lib,out_lib,in_dataset,out_dataset); %if &in_dataset. = &out_dataset. %then %do; proc copy in= &in_lib. out= &out_lib.; select &in_dataset.; run %end; %else %do; proc copy in= &in_lib. out= &out_lib.; select &in_dataset.; ...

Code SAS

Voir

Exporting SAS Data to XML (MS Access)

proc copy in=work out=access index=yes ; select test ; run ;

Code SAS

Voir

Troubleshooting CAS LIBNAME Engine Errors

/* Établit une connexion CAS */ libname mycas cas s_port=10000 s_host='localhost' caslib='casuser' s_caslib='casuser'; /* Crée des données temporaires dans work */ data work.temp_one; set sashelp.cars; where make = 'Audi'; run; data work.temp_two; set sashelp.cars; where make = 'BMW...

Code SAS

Voir

Beyond Local Files: Streamlining Big Data with the SAS Parquet Engine on GCS

libname mylib parquet "" storage_platform = "GCS" storage_bucket_name = "my-bucket" storage_gcs_key_file = "/user/myfiles/my-project-5123b3a258a1.json" ; proc copy in=sashelp out=mylib; select baseball; run; proc print data=mylib.baseball (obs=3); var name team; run;

Code SAS

Voir

Copy, Port, or Import? 3 Essential Methods to Transfer SAS Libraries Fast

libname myfiles ''; libname target ''; proc copy in=myfiles out=target; run;

Code SAS

Voir

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

libname srclib cvp 'library-path-1' cvpengine=v9 cvpmult=2.5; libname target v9 'library-path-2'; proc copy in=srclib out=target; select myclass; run; proc contents data=target.myclass; run;

Code SAS

Voir

Go Cloud-Native: How to Convert and Upload SAS Data to Parquet on Google Cloud

libname mylib parquet "" storage_platform = "GCS" storage_bucket_name = "my-bucket" storage_gcs_key_file = "/user/myfiles/my-project-5123b3a258a1.json" ; proc copy in=sashelp out=mylib; select baseball; run; proc print data=mylib.baseball (obs=3); var name team; run;

Code SAS

Voir

Don't Lose Your Data: How to Prevent Truncation When Migrating SAS Libraries to UTF-8

libname myfiles 'library-path-1'; libname target 'library-path-2'; proc copy in=myfiles out=target; run;

Code SAS

Voir

Stop Data Truncation! How to Master the CVP Engine for Safe SAS Encoding Migrations

libname srclib cvp 'library-path-1' cvpengine=v9 cvpmult=2.5; libname target v9 'library-path-2'; proc copy in=srclib out=target; select myclass; run; proc contents data=target.myclass; run;