I am using the below code to pull Json data directly into sas dataset from WEB API   %let url1=xyz; %let url2=abc; %let fullurl=&url1.&url2; filename minmap "/xml_data/Biometricmap.map"; filename daily temp; proc http url= "&fullurl." method="Get" out=daily; headers 'Content-Type' = 'application/json'; run; libname posts JSON fileref=daily map=minmap automap=replace; proc print data=posts.alldata(obs=20); run;   I am not able to fetch the output Its giving me error.  Logs are :    libname posts JSON fileref=daily map=minmap automap=replace; NOTE: JSON data is only read once. To read the JSON again, reassign the JSON LIBNAME. ERROR: Invalid JSON in input near line 1 column 1: Encountered an illegal character. ERROR: Error in the LIBNAME statement. proc print data=posts.alldata(obs=20); run; ERROR: Libref POSTS is not assigned.   this might be because the Json output contains array " [ ", can you please provide how to rectify this    Output Json is :  [ { "requestdate": "2017-12-14", "present": "41298", "averageouttime": " 5:09PM", "averageintime": "10:52AM", "registeredusers": "156495" } ]   This is what i want in dataset as  requestdate present averageouttime averageintime registeredusers 2017-12-14 41298 5:09PM 10:52AM 156495   So please help me with the correct code ??  ... View more