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" } ] } ]
... View more
