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
PROC Star

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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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