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.
%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.; ...
proc copy in=work out=access index=yes ; select test ; run ;
/* É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...
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;
libname myfiles ''; libname target ''; proc copy in=myfiles out=target; run;
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;
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;
libname myfiles 'library-path-1'; libname target 'library-path-2'; proc copy in=myfiles out=target; run;
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;