Hi Kurt Bremser, find below code and log.It URI to character 600. options validvarname=ANY;
cas casdemo sessopts=(caslib=casuser timeout=1800 locale="en_US");
libname pblic cas caslib=PUBLIC_DNFS ;
libname sys cas caslib=SystemData;
PROC SQL;
create table AUDIT_APPEND as
SELECT
*
FROM
sys.audit SYS
where
input(substr('Time Stamp'n,1,10),anydtdte12.)=today()-1;
RUN;
data WORK.AUDIT_APPEND;
set WORK.AUDIT_APPEND (rename=(URI=_URI));
length URI varchar(150);
URI = _URI;
drop _URI;
run;
PROC CASUTIL;
droptable casdata="AUDIT_APPEND" incaslib="PUBLIC_DNFS" quiet;
RUN;
PROC CASUTIL;
load data=WORK.AUDIT_APPEND outcaslib="PUBLIC_DNFS"
casout="AUDIT_APPEND" Promote;
RUN;
1 %studio_hide_wrapper;
82
83 options validvarname=ANY;
84 cas casdemo sessopts=(caslib=casuser timeout=1800 locale="en_US");
NOTE: 'CASUSER(g1u6dha)' is now the active caslib.
NOTE: The CAS statement request to update one or more session options for session CASDEMO completed.
85 libname pblic cas caslib=PUBLIC_DNFS ;
NOTE: Libref PBLIC was successfully assigned as follows:
Engine: CAS
Physical Name: d63e2c2a-d003-ba49-b742-a5a73e85e5a4
86 libname sys cas caslib=SystemData;
NOTE: Libref SYS was successfully assigned as follows:
Engine: CAS
Physical Name: d63e2c2a-d003-ba49-b742-a5a73e85e5a4
87
88 PROC SQL;
89 create table AUDIT_APPEND as
90 SELECT
91 *
92 FROM
93 sys.audit SYS
94 where
95 input(substr('Time Stamp'n,1,10),anydtdte12.)=today()-1;
NOTE: Table WORK.AUDIT_APPEND created, with 7195 rows and 10 columns.
96 RUN;
NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.77 seconds
cpu time 0.06 seconds
97 data WORK.AUDIT_APPEND;
98 set WORK.AUDIT_APPEND (rename=(URI=_URI));
99 length URI varchar(150);
100 URI = _URI;
101 drop _URI;
102 run;
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with
options MSGLEVEL=I.
NOTE: There were 7195 observations read from the data set WORK.AUDIT_APPEND.
NOTE: The data set WORK.AUDIT_APPEND has 7195 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
103 PROC CASUTIL;
NOTE: The UUID 'd63e2c2a-d003-ba49-b742-a5a73e85e5a4' is connected using session CASDEMO.
104 droptable casdata="AUDIT_APPEND" incaslib="PUBLIC_DNFS" quiet;
NOTE: The Cloud Analytic Services server processed the request in 0.032048 seconds.
105 RUN;
106
NOTE: PROCEDURE CASUTIL used (Total process time):
real time 0.05 seconds
cpu time 0.00 seconds
107 PROC CASUTIL;
NOTE: The UUID 'd63e2c2a-d003-ba49-b742-a5a73e85e5a4' is connected using session CASDEMO.
108 load data=WORK.AUDIT_APPEND outcaslib="PUBLIC_DNFS"
109 casout="AUDIT_APPEND" Promote;
NOTE: WORK.AUDIT_APPEND was successfully added to the "PUBLIC_DNFS" caslib as "AUDIT_APPEND".
110 RUN;
111
112
113 %studio_hide_wrapper;
124
125
... View more
