Hello, I'm fairly new to SAS and it is the only allowed tool in my company to do what I need to do. I need to convert several JSON files into SAS datasets, each one using different criteria. I've managed to use the JSON Engine to open the files and created a map out of one I'm using to do some learning/testing on it. What really confuses me is how SAS treats those maps or files structure to return a DS. In this example, I have a JSON structure with different sections in its root and each section has different elements. All the sections have the same elements. When I use the JSON engine to convert that to datasets, it creates the ALLDATA dataset and one dataset for every section in root. Inside each of those datasets, SAS gives me with just one observations containing all 50 variables or so. My end goal is to get just one SAS dataset with one observation per section (root element). Again, every section has the same variables with different contents. Here´s a short sample of what the AUTOMAP gives me: {
"DATASETS": [
{
"DSNAME": "First_Category",
"TABLEPATH": "/root/First Category",
"VARIABLES": [
{
"NAME": "ordinal_root",
"TYPE": "ORDINAL",
"PATH": "/root"
},
{
"NAME": "ordinal_First_Category",
"TYPE": "ORDINAL",
"PATH": "/root/First Category"
},
{
"NAME": elementA",
"TYPE": "CHARACTER",
"PATH": "/root/First Category/elementA",
"CURRENT_LENGTH": 4
},
{
"NAME": elementB",
"TYPE": "CHARACTER",
"PATH": "/root/First Category/elementB",
"CURRENT_LENGTH": 4
},
{
"NAME": elementC",
"TYPE": "CHARACTER",
"PATH": "/root/First Category/elementC",
"CURRENT_LENGTH": 4
}
]
},
{
"DSNAME": "Second_Category",
"TABLEPATH": "/root/Second Category",
"VARIABLES": [
{
"NAME": "ordinal_root",
"TYPE": "ORDINAL",
"PATH": "/root"
},
{
"NAME": "ordinal_Second_Category",
"TYPE": "ORDINAL",
"PATH": "/root/Second Category"
},
{
"NAME": elementA",
"TYPE": "CHARACTER",
"PATH": "/root/Second Category/elementA",
"CURRENT_LENGTH": 4
},
{
"NAME": elementB",
"TYPE": "CHARACTER",
"PATH": "/root/Second Category/elementB",
"CURRENT_LENGTH": 4
},
{
"NAME": elementC",
"TYPE": "CHARACTER",
"PATH": "/root/Second Category/elementC",
"CURRENT_LENGTH": 4
}
]
}
]
} How could I create a map by hand to end up with a dataset like the following: category elementA elementb elementc First Category a b c Second Category d e f I know this might sound very simple but I am stuck at this. I'm having a lot of difficulties trying to understand how SAS converts something like this. Any help will be much appreciated. Regards, Cesar
... View more