proc cas; sessionProp.setSessOpt / caslib="casuser"; run; table.columninfo / table="table_with_varchar"; quit;
%macro _abend(arg1); ; %if "&sysenv"="BACK" %then %do; data _null_; put 'ERROR: Your SAS program will ABEND.'; abort abend &arg1; run; %end; %else %do; %put ERROR: A request has been made to ABEND your program.; %put However, since this appears to be an interactive session...
proc cas; session casauto; simple.groupBy result=r status=s / inputs={"DIV" "TEAM"}, weight="nhits", aggregator="SUM", table={name="baseball"}, casout={name="casl_baseball_groupby", replace=true}; run;
signon session1 sascmd="!sascmd -nosyntaxcheck -noterminal"; signon session2 sascmd="!sascmd -nosyntaxcheck -noterminal";
rsubmit session1 wait=no; options casdatalimit=10G; options compress=yes; cas host="19w47mpp-2.gtp-americas.sashq-d.openstack.sas.com" port=5570 sessopts=(TIMEOUT=99,DQLOCALE=ENUSA); caslib _all_ assign; data casuser.cars; set sashelp.cars; run;
proc cas; session casauto; simple.regression result=reg status=rc / alpha=0.05, order=3, target="mpg_highway", inputs={"weight"}, table={caslib="casuser", name="cars"}; run; if (rc.severity == 0) then do; saveresult reg casout="reg1"; table.fetch / ...
rsubmit session2 wait=no; options casdatalimit=10G; options compress=yes; cas host="19w47mpp-2.gtp-americas.sashq-d.openstack.sas.com" port=5570 sessopts=(TIMEOUT=99,DQLOCALE=ENUSA); caslib _all_ assign; data casuser.cars; set sashelp.cars; run;
proc cas; session casauto; simple.regression result=reg2 status=rc / alpha=0.15, order=2, target="mpg_highway", inputs={"weight"}, table={caslib="casuser", name="cars"}; run; if (rc.severity == 0) then do; saveresult reg2 casout="reg2"; table.fetch /...
waitfor _all_ session1 session2; rget session1; rget session2; signoff session1; signoff session2;
proc sql; create table c1 as select time_stamp as ts, esm_type, esm_user, a.hostname, esm_group from pgesm.esm_process_stats_agg_hour as a join pgesm.esm_node as b on a.hostname = b.hostname where esm_type in ('WS', 'CMP', 'SPRE', 'Found...