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"
}
]
}
]
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.
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: