Publication Type
Conference Proceeding Article
Version
publishedVersion
Publication Date
5-2013
Abstract
JSON, otherwise known as JavaScript Object Notation, is a popular data interchange format which provides a humanreadable format. It is language independent and can be read easily in a variety of computer languages. With the riseof Twitter and other unstructured data, there has been a move to incorporate such data as a way of disseminatinginformation. Twitter currently provides a simple API for users to extract tweets using JSON format. While SAS doesnot currently have a direct way of reading JSON, the SCANOVER function in SAS data step provides user with asimple and effective approach to getting JSON information into SAS datasets. In this paper, we will illustrate twoexamples using this technique.
Discipline
Computer Engineering | Data Storage Systems
Research Areas
Data Science and Engineering
Publication
Proceedings of 2013 SAS Global Forum, San Francisco, April 28 - May 1
First Page
1
Last Page
6
City or Country
San Francisco, CA, USA
Citation
CHOY, Murphy and SHIM, Kyong Jin.
Efficient extraction of JSON information in SAS using the SCANOVER function. (2013). Proceedings of 2013 SAS Global Forum, San Francisco, April 28 - May 1. 1-6.
Available at: https://ink.library.smu.edu.sg/sis_research/4343
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.