How complex is the JSON (remember I can't see it since you hid it in a XLSX file so that when I viewed it in the browser it looks like four black horizontal lines)? If it is a simple format you can probably just parse it instead by looking for the keywords and taking the next token as the value. In which case you would need to write each line as its own file and then read each one back in.

If each value is an independent fully formed JSON object then that might not work. So if you have the latter you will need to add either square or curly brackets around the output and commas between the lines to convert the JSONL lines into an actual JSON file.

To help illustrate how to use the Parse command, the following sample data starts with JSON and XML data entered as text fields. So does each value of the variable constitute a complete JSON file? Or are these instead individual lines from a JSONL file? The JSON engine in SAS cannot read JSONL files. Excel for Microsoft 365 Excel for the web You can parse (or deconstruct) the contents of a column with text strings that contain JSON or XML.

WHy not just dump the text into the SAS log and copy and paste the text into your posting so that everyone can actually read it. Think the excel as the export of a sas dataset.īut why did you go to the trouble of copying the dataset into an XLSX file and uploaded the XLSX as an attachment to your post?

JSON is the format in which a value is stored in a dataset column, as you can see in the xlsx file i attached.

Import json data to excel