Solved: How to read JSON formatted data from csv file - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Obsidian | Level 7

Obsidian | Level 7

How to read JSON formatted data from csv file

Posted 01-04-2019 02:11 AM (2381 views)

I have a CSV file with JSON data rows. How do I read the JSON in a data step infile statement without using proc JSON or proc http. Please help.

1 ACCEPTED SOLUTION

Accepted Solutions

SAS Employee

SAS Employee

Re: How to read JSON formatted data from csv file

Posted 01-04-2019 10:17 AM (2338 views) | In reply to AshleyBright

Without a sample of the data you are trying to read, I am not sure if this will work for you. But I found this message thread that may help you.

View solution in original post

1 REPLY 1

SAS Employee

SAS Employee

Re: How to read JSON formatted data from csv file

Posted 01-04-2019 10:17 AM (2339 views) | In reply to AshleyBright

Without a sample of the data you are trying to read, I am not sure if this will work for you. But I found this message thread that may help you.

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!