JSON - omitted values are incorrectly retained

John2020 — Wed, 12 Aug 2020 23:26:10 GMT

Here is some JSON. I omitted "number" in several entries.

[
      {
       "type": "Full",
       "info" : [ 
          { "name" : "Eric" , "age" : 21, "phone" : [
             { "type" : "cell" },
             { "type" : "home", "number" : "542" }
             ]
          },
          { "name" : "John",  "age" : 22, "phone" : [
             { "type" : "cell", "number" : "456" },
             { "type" : "home"},
             { "type" : "home"}
             ]
          }
        ]
      },
      {
       "type": "Part",
       "info" : [ 
          { "name" : "Bjorn" , "age" : 27, "phone" : [
             { "type" : "cell",   "number" : "721" },
             { "type" : "burner"}
             ]
          }
        ]
    
      }
    ]

Here is a map. I am reading "number" 3 times:

As character
As numeric with an informat
As numeric without an informat

{
      "DATASETS": [
        {
          "DSNAME": "all",    
          "TABLEPATH": "/root/info/phone",
          "VARIABLES": [
	    {
              "NAME": "Type",
              "TYPE": "CHARACTER",
              "PATH": "/root/info/phone/type"
            },
            {
              "NAME": "number1",
              "TYPE": "CHARACTER",
              "PATH": "/root/info/phone/number"
            },
		{
              "NAME": "number2",
              "TYPE": "NUMERIC",
              "PATH": "/root/info/phone/number",
	      "INFORMAT": ["BEST", 3, 0]
            },
            {
              "NAME": "number3",
              "TYPE": "NUMERIC",
              "PATH": "/root/info/phone/number"
            }
          ]
        }
      ]
    }

Here are the results.

filename jsondata "example.json";
filename example "example.map";
libname example JSON fileref=jsondata map=example;
 
data work.test;
    set example.all;
run;

When using an informat, the results seem to be getting retained instead of appearing as missing. How do I fix this?

Re: JSON - omitted values are incorrectly retained

ChrisNZ — Wed, 19 Aug 2020 22:33:18 GMT

You might have a contact Tech Support and see if this is a defect.

topic Re: JSON - omitted values are incorrectly retained in SAS Programming

JSON - omitted values are incorrectly retained

Re: JSON - omitted values are incorrectly retained