I have the following code to load JASON output in to my SAS project:
filename out TEMP;
filename cacm TEMP;
proc http
url='https://XYZ.STU.com/api/now/table/...policy.contract_state_code&sysparm'
method="GET"
out=out
headerout=cacm
auth_basic webusername="cacm_rest_user" webpassword="XXXXXXXXXXXXXXXXXXXXX";
run;
libname CACM json "%sysfunc(pathname(out))" ;
proc copy inlib=cacm outlib=WORK;
run;
libname CACM JSON "%sysfunc(pathname(out))" fileref=data;
data out;
set CACM.alldata;
run;
data _null_;
rc = jsonpp("data","log");
run;
This works fine and gives me an "OUT" table, a "RESULT" table and an "ALLDATA" table. However, it stops my process flow there unless I manually run the branch. I want to continue the process flow, which clean up the data and joins with other tables in the SAS project. I think I am missing a step to be able to use the output in these three tables as an input to other part of my SAS project. I do get the following error when I run the above code:
ERROR: Physical file does not exist, /config/sas94/Lev1/SASApp/data.
Any ideas?
Create a permanent library.
Instead of copying to WORK copy to that library.
Clean up that permanent library as needed in the future.
This will require you to reference the data in that permanent library using the library name and not the single level name.
Create a permanent library.
Instead of copying to WORK copy to that library.
Clean up that permanent library as needed in the future.
This will require you to reference the data in that permanent library using the library name and not the single level name.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.