topic Re: How to retain a value over multiple "rows" in JSON using mapping in SAS Programming

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

SanderB — Tue, 11 Feb 2025 14:45:42 GMT

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.

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

Amir — Tue, 11 Feb 2025 17:09:11 GMT

Hi,

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

Thanks & kind regards,

Amir.

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

SanderB — Wed, 12 Feb 2025 12:57:07 GMT

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.