/* Specify the DBMS engine, for example: ODBC */ %let srctype=odbc; %let cas_session = mysess; %let caslib_alias = datalib; /*Specify connection parameters within a string Edit the below variables with the required DBMS-specific conection options Also, specify such variables within the CONNOP...
proc cas; session &cas_session; action addCaslib caslib="&caslib_alias" datasource={ srctype="&srctype", user="&username", pass="&password", database="&database", schema="&schema", catalog="*"}; run; quit;
/* Proc cas loadtable action: loads entire table*/ proc cas; session &cas_session; action loadtable casout={name="SAMDATLOAD" replace=true} caslib="&caslib_alias" path="LOADSAMPLE"; run; quit;
/* Proc cas loadtable action with where parameter: subsets the input data */ proc cas; session &cas_session; action loadtable casout={name="SAMDATLOADWHERE" replace=true} caslib="&caslib_alias" where="FLIGHT = 114" path="LOADSAMPLE"; run; quit;
/* Proc cas loadtable action with vars parameter: specifies variables to load */ proc cas; session &cas_session; action loadtable casout={name="SAMDATLOADVARS" replace=true} caslib="&caslib_alias" vars={"FLIGHT", "ORIG", "DEST"} path="LOADSAMPLE"; run; quit;
/* Verify loadtable using caslib libref with CAS Libname engine to print in-memory tables*/ libname caslib cas sessref=&cas_session tag=""; proc print data=caslib.SAMDATLOAD; run; proc print data=caslib.SAMDATLOADWHERE; run; proc print data=caslib.SAMDATLOADVARS; run;
/* Clean-up: Delete files from data source associated with caslib */ proc cas; session &cas_session; action deleteSource caslib="&caslib_alias" source="LOADSAMPLE" ; run; quit;
/* Définir l'URL du fichier CSV */ %let csv_url = 'http://support.sas.com/documentation/onlinedoc/viya/exampledatasets/air.csv'; /* Créer un fichier temporaire pour le téléchargement */ filename _air_ temp; /* Télécharger le fichier CSV */ proc http method='get' url=&csv_url. out=_air_; run; /...
/* Création d'une table en mémoire via un DATA step */ data casuser.Produits; length Categorie $10 Produit $20; infile datalines dsd; input Categorie $ Produit $ Prix Stock; format Prix dollar8.2; label Categorie='Catégorie de Produit' Produit='Nom du Produit' Prix='Prix Unitaire' ...
/* Créer une table temporaire pour la démonstration */ data _null_; file _webout; put 'ID,Valeur'; put '1,10'; put '2,20'; put '3,30'; run; %let temp_data_file = %sysfunc(pathname(temp)); filename _tmp_data_ temp filevar=_webout; data _null_; file _tmp_data_; ...