Tag: JSON

Read RSS feeds with SAS using XML or JSON

This blog post could be subtitled “To Catch a Thief” or maybe “Go ahead. Steal this blog. I dare you.”* That’s because I’ve used this technique several times to catch and report other web sites who lift the blog content from blogs.sas.com and present it as their own. Syndicating blog […]

The post Read RSS feeds with SAS using XML or JSON appeared first on The SAS Dummy.

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 Create newline-delimited JSON (or JSONL) with SAS appeared first on The SAS Dummy.

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 The Internet of Snacks: SnackBot data and what it reveals about SAS life appeared first on The SAS Dummy.

How to test PROC HTTP and the JSON library engine

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 How to test PROC HTTP and the JSON library engine appeared first on The SAS Dummy.

Using SAS to access Google Analytics APIs

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 Using SAS to access Google Analytics APIs appeared first on The SAS Dummy.

Reporting on GitHub accounts with SAS

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 Reporting on GitHub accounts with SAS appeared first on The SAS Dummy.

Reading data with the SAS JSON libname engine

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 Reading data with the SAS JSON libname engine appeared first on The SAS Dummy.