Make temporary JSON file data more permanent for further use in SAS project tree

gregor1 — Wed, 04 Nov 2020 16:59:46 GMT

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?

Re: Make temporary JSON file data more permanent for further use in SAS project tree

ballardw — Wed, 04 Nov 2020 17:06:24 GMT

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.

topic Re: Make temporary JSON file data more permanent for further use in SAS project tree in SAS Enterprise Guide

Make temporary JSON file data more permanent for further use in SAS project tree

Re: Make temporary JSON file data more permanent for further use in SAS project tree