proc json

[partha_125]

HI,

I have an excel file have to convert to json  using proc json

have -excel sheet attached

want-

"sources": [
{
"alias": "countrycodes",
"type": "gcs",
"project": "TBD",
"bucket": "country_codes_mvp",
"directory": "/s/xxxx/",
"filename": "test.txt",
"file_type": "text",
"data_structure_type": "full",
"primary_table": true,
"schema_file": "/xxx/xxxx/text.msc",
"filter_criteria": "trim(status) ='Current' and cast(trim(effectivedate) as date)=?",
"filter_attributes": [
{
"name": "run_ts",
"type": "long"
}
]
}
]

[ChrisNZ]

1- What have you tried?

2- MS files are best avoided as many people will not/cannot download them. Post a sample of the data instead.

How to convert datasets to data steps
How to post code

[partha_125]

Hi Chris,

Thanks for replying.

I have tried the basic proc json using write values and  export statements . but could not do the nested arrays.

Pls find the input file below

 

[ChrisNZ]

Did you see this discussion about creating hierarchical JSON files using the WRITE statement?