DATA Step, Macro, Functions and more

reading in JSON data

Reply
Contributor
Posts: 21

reading in JSON data

How would I convert this to a SAS dataset with rows being records and columns being variables if I do not have a JSON engine

 

{"widget": {
    "debug": "on",
    "window": {
        "title": "Sample Konfabulator Widget",
        "name": "main_window",
        "width": 500,
        "height": 500
    },
    "image": {
        "src": "Images/Sun.png",
        "name": "sun1",
        "hOffset": 250,
        "vOffset": 250,
        "alignment": "center"
    },
    "text": {
        "data": "Click Here",
        "size": 36,
        "style": "bold",
        "name": "text1",
        "hOffset": 250,
        "vOffset": 100,
        "alignment": "center",
        "onMouseUp": "sun1.opacity = (sun1.opacity / 100) * 90;"
    }
}}   

Super User
Super User
Posts: 7,948

Re: reading in JSON data

Please use the search box before asking a question, there are quite a few topics on reading Json files:

https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&...

Super User
Posts: 19,789

Re: reading in JSON data

You've started several threads but never answer any followup questions so we can't really help you further. Good Luck. 

Ask a Question
Discussion stats
  • 2 replies
  • 126 views
  • 0 likes
  • 3 in conversation