I am trying to import an json-file to sas with the new libname statement. I got errors both when I test the submited code in this sas blog: http://blogs.sas.com/content/sasdummy/#fn
/* Assign a JSON library to the HTTP response */
libname space JSON 'resp';
run;
/* Print result, dropping automatic ordinal metadata */
title "Who is in space right now? (as of &sysdate)";
proc print data=space.people (drop=ordinal:);
run;
And got this error: "ERROR: Libref SPACE is not assigned.".
I also test this code:
ibname qlib json "D:\Data\SAS\SCB API\AKU_ALOS_FRAGA.JSON";
run;
proc contents data=qlib._all_;
run;
and got this error:
(ERROR: Invalid JSON in input near line 1 column 1: Encountered an illegal character. ERROR: Error in the LIBNAME statement.)
My system version is;
NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M4)
Licensed to , Site .
NOTE: This session is executing on the X64_10PRO platform.
NOTE: Updated analytical products:
SAS/STAT 14.2
SAS/ETS 14.2
NOTE: Additional host information: X64_10PRO WIN 10.0.14393 Workstation
I think I have the latest version of SAS. I downloaded it from SAS yesterday and the text indicated it.
What I do no know is if libname json requiere an additional license. I have try to figured it out, but do not find it.
My questions is.
1. Can I got libname json to work on this computer?
2. What have got wrong with my programs?
My final goal is to import data from Statistic Sweden, SCB, with there api. (They have the same api at as least Statistic Finland)
/Anders
... View more