Posts Tagged ‘ sas programming ’

Reading data with the SAS JSON libname engine

December 2, 2016
By
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 Read more »

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

Using the DATA step debugger in SAS Enterprise Guide

December 1, 2016
By
Using the DATA step debugger in SAS Enterprise Guide

In my earlier post about WHERE and IF statements, I announced that the DATA step debugger has finally arrived in SAS Enterprise Guide. (I admit that I might have buried the lead in that post.) Let's use this post to talk about the new debugger and how it works. First,

The post Read more »

Tags: , ,
Posted in SAS | Comments Off on Using the DATA step debugger in SAS Enterprise Guide

Append data to add markers to SAS graphs

November 30, 2016
By
Append data to add markers to SAS graphs

Do you want to create customized SAS graphs by using PROC SGPLOT and the other ODS graphics procedures? An essential skill that you need to learn is how to merge, join, append, and concatenate SAS data sets that come from different sources. The SAS statistical graphics procedures (SG procedures) enable

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on Append data to add markers to SAS graphs

Debugging the difference between WHERE and IF in SAS

November 27, 2016
By
Debugging the difference between WHERE and IF in SAS

In the DATA step, the WHERE statement and the IF statement (a.k.a. the "subsetting IF") have similar functions. In many scenarios, they produce identical results. But new SAS programmers are taught early on that these two statements work very differently, and in important ways. To understand the differences, it helps

The post Read more »

Tags: , ,
Posted in SAS | Comments Off on Debugging the difference between WHERE and IF in SAS

One informat to rule them all: Read any date into SAS

November 11, 2016
By
One informat to rule them all: Read any date into SAS

If you obtain data from web sites, social media, or other unstandardized data sources, you might not know the form of dates in the data. For example, the US Independence Day might be represented as "04JUL1776", "07/04/1776", "Jul 4, 1776", or "July 4, 1776." Fortunately, the ANYDTDTE informat makes it

The post Read more »

Tags: , ,
Posted in SAS | Comments Off on One informat to rule them all: Read any date into SAS

The difference between the Subsetting IF and the IF—THEN—ELSE—IF statement

November 3, 2016
By

My river walk last week turned into a spectacular fall show. But if it rains this week in San Antonio, like the weatherman predicts, what will I do? In the coming days, I’ll be presenting at two user groups,  one in eastern Canada in Halifax, and the other all the

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on The difference between the Subsetting IF and the IF—THEN—ELSE—IF statement

List the contents of your ZIP and gz files using SAS

October 16, 2016
By
List the contents of your ZIP and gz files using SAS

SAS programmers often resort to using the X command to list the contents of file directories and to process the contents of ZIP files (or gz files on UNIX). In centralized SAS environments, the X command is unavailable to most programmers. NOXCMD is the default setting for these environments (disallowing

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on List the contents of your ZIP and gz files using SAS

WHERE operators in SAS: Multiple comparisons and fuzzy matching

October 10, 2016
By
WHERE operators in SAS: Multiple comparisons and fuzzy matching

The WHERE clause in SAS is a powerful mechanism for selecting observations as you read or write a data set. The WHERE clause supports many operators, including the IN operator, which enables you to compactly specify multiple conditions for a categorical variable. A common use of the IN operator is

The post Read more »

Tags: ,
Posted in SAS | Comments Off on WHERE operators in SAS: Multiple comparisons and fuzzy matching

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.