BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
jsut
Fluorite | Level 6

Hi all,

 

I'm pretty new with trying to export json file from sas.

Can I please get some help on how to export a nested json with proc json? Thanks in advance.

So, what I'm trying to get is something like:

[

{"person_id": "12345",
"timestamp":"Tue Jun 7 07:21:50 2022",
"message":"sample",
"items":[
         {"category_type":"cat1",
         "category_status":"approved",         

         "details": [

                   {"subcategory_code":"subcat1",

                   "subcategory_total":100}

                   ,{"subcategory_code":"subcat2",

                   "subcategory_total":50 }

                    ]

         },

         {"category_type":"cat2",
         "category_status":"pending",         

         "details": [

                   {"subcategory_code":"subcat1",

                   "subcategory_total":200}

                   ,{"subcategory_code":"subcat2",

                   "subcategory_total":300}

                    ]

          }

       ]

},

{"person_id": "56789",
"timestamp":"Tue Jun 7 07:21:50 2022",
"message":"sample",
"items":[
         {"category_type":"cat3",
         "category_status":"pending",         

         "details": [

                   {"subcategory_code":"subcat1",

                   "subcategory_total":10}

                   ,{"subcategory_code":"subcat2",

                   "subcategory_total":20}

                    ]

         },

         {"category_type":"cat4",
         "category_status":"approved",         

         "details": [

                   {"subcategory_code":"subcat1",

                   "subcategory_total":30}

                   ,{"subcategory_code":"subcat2",

                   "subcategory_total":50}

                    ]

          }

        ]

}

]

 

1 ACCEPTED SOLUTION

Accepted Solutions
BillM_SAS
SAS Employee

I previously posted a proof-of-concept SAS program that produces hierarchical output using PROC JSON. You should be able to use this as a starting point to produce what you want as output.

View solution in original post

5 REPLIES 5
andreas_lds
Jade | Level 19

Why do you want to create a json file using sas?

Can you post the datasets in usable form (dataset with datalines)?

jsut
Fluorite | Level 6

Hi @andreas_lds ,

we're planning to automate some process using data from sas to be then pushed into another system that's expecting a json file.

some sample datasets as below:

data sampledata;
input person_id $5.
person_name $10.
message $10.
category_type $5.
category_status $8.
subcategory_code $10.
subcategory_total 5.;

datalines;
12345 Person_A Sample_1 cat1 approved subcat1 100
12345 Person_A Sample_1 cat1 approved subcat2 50
12345 Person_A Sample_1 cat2 pending subcat1 200
12345 Person_A Sample_1 cat2 pending subcat2 300
56789 Person_Z Sample_2 cat3 pending subcat1 10
56789 Person_Z Sample_2 cat3 pending subcat2 20
56789 Person_Z Sample_2 cat4 approved subcat1 30
56789 Person_Z Sample_2 cat4 approved subcat2 50
;
run;

 

Thanks
 

BillM_SAS
SAS Employee

I previously posted a proof-of-concept SAS program that produces hierarchical output using PROC JSON. You should be able to use this as a starting point to produce what you want as output.

jsut
Fluorite | Level 6

Thanks @BillM_SAS , the code seems to work. I just need to tweak them a bit further to get to how we want the json file format to be.

V_Altomonte
SAS Employee

You can use the PROC JSON, probably with the NOSASTAGS and PRETTY options:
proc JSON documentation

Alternatively, you can compose it manually with a date step,
as shown in this other post:
JSON export post

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 3093 views
  • 2 likes
  • 4 in conversation