Posts Tagged ‘ JSON ’

Create newline-delimited JSON (or JSONL) with SAS

November 14, 2018
By
Create newline-delimited JSON (or JSONL) with SAS

JSON is a popular format for data exchange between APIs and some modern databases. It's also used as a way to archive audit logs in many systems. Because JSON can represent hierarchical relationships of data fields, many people consider it to be superior to the CSV format -- although it's

The post Read more »

Tags: ,
Posted in SAS | Comments Off on Create newline-delimited JSON (or JSONL) with SAS

The Internet of Snacks: SnackBot data and what it reveals about SAS life

July 2, 2018
By
The Internet of Snacks: SnackBot data and what it reveals about SAS life

At SAS, we love data. Data is central to our corporate vision: to transform a world of data into a world of intelligence. We're also famous for enjoying M&Ms, but to us they are more than a sweet snack. They're also another source of data. My colleague Pete Privitera, with

The post Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on The Internet of Snacks: SnackBot data and what it reveals about SAS life

How to test PROC HTTP and the JSON library engine

January 23, 2018
By

Using SAS with REST APIs is fun and rewarding, but it's also complicated. When you're dealing with web services, credentials, data parsing and security, there are a lot of things that can go wrong. It's useful to have a simple program that verifies that the "basic plumbing" is working before

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on How to test PROC HTTP and the JSON library engine

Using SAS to access Google Analytics APIs

April 14, 2017
By

Every day before I even wake up, I have little "SAS robots" that do work for me. These are SAS batch jobs that gather data from external services and build data marts, generate reports, and send e-mail. One of those SAS jobs gathers Google Analytics data about our SAS blogs

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Using SAS to access Google Analytics APIs

Reporting on GitHub accounts with SAS

January 5, 2017
By

At SAS, we've published more repositories on GitHub as a way to share our open source projects and examples. These "repos" (that's Git lingo) are created and maintained by experts in R&D, professional services (consulting), and SAS training. Some recent examples include: sas_kernel, which provides Jupyter notebook support for SAS.

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Reporting on GitHub accounts with SAS

Reading data with the SAS JSON libname engine

December 2, 2016
By

JSON is the new XML. The number of SAS users who need to access JSON data has skyrocketed, thanks mainly to the proliferation of REST-based APIs and web services. Because JSON is structured data in text format, we've been able to offer simple parsing techniques that use DATA step and

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on Reading data with the SAS JSON libname engine

Using SAS DS2 to parse JSON

September 28, 2015
By

Thanks to the proliferation of cloud services and REST-based APIs, SAS users have been making use of PROC HTTP calls (to query these web services) and some creative DATA step or PROC GROOVY code to process the JSON results. Such methods get the job done (JSON is simply text, after

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Using SAS DS2 to parse JSON

SAS Proc Groovy in Action: JSON File Processing

December 12, 2013
By

Last year I took a bite of the newly SAS Proc Groovy to read JSON data since there was no direct “proc import” or “infile” or “libname” way to play with JSON. Here is an nice example from SAS official blog, by Falko Schulz where Proc Groovy is used to parse Twitter JSON file:...
Read more »

Tags: , ,
Posted in SAS | Comments Off on SAS Proc Groovy in Action: JSON File Processing

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.