topic Re: proc json in SAS Programming

proc json

partha_125 — Fri, 28 Sep 2018 19:03:21 GMT

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"
}
]
}
]

Re: proc json

ChrisNZ — Sun, 30 Sep 2018 21:26:43 GMT

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

Re: proc json

partha_125 — Mon, 01 Oct 2018 14:08:50 GMT

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

Re: proc json

ChrisNZ — Mon, 01 Oct 2018 21:26:14 GMT

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