Hello everyone, I would like to ask a question. options cashost="xxxx" casport=5570;
/*caslib _all_ assign;*/
/* option validvarname=any; */
libname satpp cas caslib="satpp";
FILENAME request HTTP
'api link'
user='user' password='password' debug;
DATA NULL;
INFILE request;
INPUT;
PUT INFILE;
RUN;
libname sadarPP JSON fileref=request;
data work.satpp_sadarPP;
set sadarPP.root;
run;
proc sql;
create table work.satpp_sadarL as
select ID_responses,
Sent_date,
Name,
Age,
Gender
from work.satpp_sadarPP;
quit;
/*change data format*/
data work.satpp_sadarL;
set work.satpp_sadarL;
time=input(Sent_date,ANYDTDTM.);
format time datetime19.;
run;
/* sorting data by date */
proc sort data=work.satpp_sadarL;
by time;
run;
%macro checktable(dsn);
%if %sysfunc(exist(&dsn)) %then %do;
proc delete data=&dsn; run;
%end;
%mend;
%checktable(work.satpp_sadarL)
data satpol.final (promote=yes);
set work.satpp_sadarL;
run; I have code like above, that get JSON data from API link to be inputted in library. I want that library to be promoted to Data Source that can be used in SAS Visual Analytics, and scheduled a job so that it always updated everytime there's a new data inputted in that API. It used to be working just fine, but now there's error like this. Error This is what my libraries look like My Library Is there any change to SAS or my code that's wrong? Thank you
... View more
