I am trying to read JSON data in a data step. I am running SAS 9.3, so I don't have PROC JSON. Below is my code, results, and text file I am trying to read. The problem is that I am using scanover and @ to point to "year":, for instance, and read the next variable. However, when I get to periodName, it has variable length, so I am running past the field. I have experimented with different options, dlm=, etc, but I can't get this to work. Any help would be greatly appreciated! data testdata; infile OUT lrecl = 32000 truncover scanover; input @'"year":' year $6. @'"period":' period $5. @'"periodName":' periodName $15. @'"value":' value $15. @'"footnotes":' footnotes $255.; run; "2014" "M10" "October","valu "24.19","footno [{}]},{"year":"2014","period":"M07","periodName":"July","value":"23.96","footnotes":[{}]},{"year":"2014","period":"M06","periodName":"June","value":"24.11","footnotes":[{}]},{"year":"2014","period":"M05","periodName":"May","value":"23.98","footnotes":[{}] {"status":"REQUEST_SUCCEEDED","responseTime":42,"message":[],"Results":{ "series": [{"seriesID":"CEU0800000003","data":[{"year":"2014","period":"M10","periodName":"October","value":"24.19","footnotes":[{"code":"P","text":"preliminary"}]},{"year":"2014","period":"M09","periodName":"September","value":"24.19","footnotes":[{"code":"P","text":"preliminary"}]},{"year":"2014","period":"M08","periodName":"August","value":"23.98","footnotes":[{}]},{"year":"2014","period":"M07","periodName":"July","value":"23.96","footnotes":[{}]},{"year":"2014","period":"M06","periodName":"June","value":"24.11","footnotes":[{}]},{"year":"2014","period":"M05","periodName":"May","value":"23.98","footnotes":[{}]},{"year":"2014","period":"M04","periodName":"April","value":"24.08","footnotes":[{}]},{"year":"2014","period":"M03","periodName":"March","value":"24.21","footnotes":[{}]},{"year":"2014","period":"M02","periodName":"February","value":"24.32","footnotes":[{}]},{"year":"2014","period":"M01","periodName":"January","value":"24.06","footnotes":[{}]},{"year":"2013","period":"M12","periodName":"December","value":"23.99","footnotes":[{}]},{"year":"2013","period":"M11","periodName":"November","value":"23.81","footnotes":[{}]},{"year":"2013","period":"M10","periodName":"October","value":"23.74","footnotes":[{}]},{"year":"2013","period":"M09","periodName":"September","value":"23.89","footnotes":[{}]},{"year":"2013","period":"M08","periodName":"August","value":"23.48","footnotes":[{}]},{"year":"2013","period":"M07","periodName":"July","value":"23.49","footnotes":[{}]},{"year":"2013","period":"M06","periodName":"June","value":"23.66","footnotes":[{}]},{"year":"2013","period":"M05","periodName":"May","value":"23.51","footnotes":[{}]},{"year":"2013","period":"M04","periodName":"April","value":"23.66","footnotes":[{}]},{"year":"2013","period":"M03","periodName":"March","value":"23.58","footnotes":[{}]},{"year":"2013","period":"M02","periodName":"February","value":"23.66","footnotes":[{}]},{"year":"2013","period":"M01","periodName":"January","value":"23.62","footnotes":[{}]},{"year":"2012","period":"M12","periodName":"December","value":"23.58","footnotes":[{}]},{"year":"2012","period":"M11","periodName":"November","value":"23.31","footnotes":[{}]},{"year":"2012","period":"M10","periodName":"October","value":"23.24","footnotes":[{}]},{"year":"2012","period":"M09","periodName":"September","value":"23.42","footnotes":[{}]},{"year":"2012","period":"M08","periodName":"August","value":"22.96","footnotes":[{}]},{"year":"2012","period":"M07","periodName":"July","value":"23.20","footnotes":[{}]},{"year":"2012","period":"M06","periodName":"June","value":"22.97","footnotes":[{}]},{"year":"2012","period":"M05","periodName":"May","value":"23.04","footnotes":[{}]},{"year":"2012","period":"M04","periodName":"April","value":"23.36","footnotes":[{}]},{"year":"2012","period":"M03","periodName":"March","value":"23.10","footnotes":[{}]},{"year":"2012","period":"M02","periodName":"February","value":"23.12","footnotes":[{}]},{"year":"2012","period":"M01","periodName":"January","value":"23.30","footnotes":[{}]}]}] }}
... View more