How to retain a value over multiple "rows" in JSON using mapping

[SanderB]

Let's say we have the following situation in a JSON file:

"retainthis" : "X" ,
"rows" : [
   { var = 0 } ,
   { var = 1 }
 ]

 And we want the following table when we read this JSON file with a libname statement using a map:

X	0
X	1

If I remember correctly there is a certain attribute you can use in the map to make sure the X value is retained. You have to specify name, type, path, length, etc. What attribute could we add to the map so that it retains the value.

I can't find it in the SAS document anywhere. 

[Amir · Accepted solution]

Hi,

Are you looking for the below found in the LIBNAME Statement: JSON Engine documentation?

Thanks & kind regards,

Amir.

[SanderB]

Yes, that is exactly the option I was looking for. Thank you! In the past Google would always directly send me to the correct onlinedoc pages when searching for things like this. But nowadays I rarely end up on the correct SAS pages. I wonder if that is a problem with Google or a problem with the SAS documentation.