Writes JSON in SASjs format to a fileref. More...
PROC JSON is faster but will produce errs like the ones below if special chars are encountered.
>An object or array close is not valid at this point in the JSON text. >Date value out of range
If this happens, try running with ENGINE=DATASTEP.
filename tmp temp; data class; set sashelp.class;run; %mp_jsonout(OBJ,class,jref=tmp) data _null_; infile tmp; input;list; run;
|action||Valid values: OPEN - opens the JSON OBJ - sends a table with each row as an object ARR - sends a table with each row in an array CLOSE - closes the JSON|
|ds||the dataset to send. Must be a work table.|
|jref=||the fileref to which to send the JSON|
|dslabel=||the name to give the table in the exported JSON|
|fmt=||Whether to keep or strip formats from the table|
|engine=||Which engine to use to send the JSON, options are: PROCJSON (default) DATASTEP|
|dbg=||DEPRECATED - was used to conditionally add PRETTY to proc json but this can cause line truncation in large files.|
Definition in file mp_jsonout.sas.