Hi All, I am using Proc JSON to output a SAS dataset into JSON format. The first block of JSON below is the default output and the second block is what I am trying to do. Basic Proc JSON code: proc json out="path\name.json" pretty nosastags; export dataset; run; Default JSON output:
[
{
"category_id": 123,
"name": "name_example",
"description": "description_example",
"page_title": "page_example",
"meta_description": "meta_example",
"URL": "url_example"
}
]
What I need:
[
{
"category_id": 123,
"name": "name_example",
"description": "description_example",
"page_title": "page_example",
"meta_description": "meta_example",
"URL": {
"path": "url_example"
}
}
] I have tried various statements within Proc JSON (write values, arrays, objects, etc.) but that doesn't seem to get me what I need. What do I need to do to achieve the output I shared above? Thanks in advance for your help!
... View more
