Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Uttam KumarOctober 28, 2015 0

Using SAS PROC SQOOP

SAS 9.4 M3, introduces a new procedure named PROC SQOOP. This procedure enables users to access an Apache Sqoop utility from a SAS session to transfer data between a database and HDFS. Using SAS PROC SQOOP lets you submit Sqoop commands from within your SAS application to your Hadoop cluster. PROC

Read More

Programming Tips

Edoardo RivaOctober 26, 2015 0

SAS Grid Manager for Hadoop architecture

SAS Grid Manager for Hadoop is a brand new product released with SAS 9.4M3 this summer. It gives you the ability to co-locate your SAS Grid jobs on your Hadoop data nodes to let you further leverage your investment in your Hadoop infrastructure. This is possible because SAS Grid Manager

Read More

Programming Tips | SAS Events

Larry LaRussoOctober 22, 2015 0

Using the SAS Output Delivery System to enhance, customize, and render reports

To kick off his presentation at MWSUG2015, SAS’ Chevell Parker flashed a picture of an old-school phone booth and asked the audience where he could find the nearest one. Met with several seconds of silence, he smiled. “Don’t all answer at once!” The point of his question was obvious: as

Read More

Programming Tips | SAS Administrators

Bobbie WagonerOctober 21, 2015 0

The SAS Visual Analytics Home Page: It’s not just for Visual Analytics anymore!

As of Visual Analytics 7.2, the home page is designed to serve as the entry point for not only Visual Analytics, but also additional SAS applications and solutions. To this end, the SAS Visual Analytics home page is documented in both the SAS Visual Analytics Administration Guide and the SAS Intelligence

Read More

Programming Tips | SAS Events

Larry LaRussoOctober 20, 2015 0

Hot skills for SAS professionals

Good news SAS users; you are a hot commodity. That’s the primary message Kirk Paul Lafler from Software Intelligence Corporation and Charlie Shipp of Consider Consulting Corporation delivered to a room full of users at MWSUG 2015. Citing figures from the Bureau of Labor Statistics and a recent CNN Money

Read More

Programming Tips

Marcia SurrattOctober 16, 2015 0

PROC SGPLOT: It isn’t just for plots anymore

A coworker was recently in need of some simple graphics to include in a slide show to accompany her SAS Global Forum paper. After listening to what she wanted, I decided that I could use PROC SGPLOT to create those images for her. The first image was a set of stacked

Read More

Programming Tips

Louanne WrightOctober 15, 2015 0

Creating an automated grocery list using SAS Enterprise Guide and prompts

Creating a grocery shopping list can be overwhelming for a variety of reasons. Lack of experience, picky eaters, and new recipes can turn an ambitious cook into an overwhelmed procrastinator. In this blog post I’ll show you an easy SAS Enterprise Guide project that uses prompts to create a simple

Read More

Programming Tips

Rob CollumOctober 8, 2015 0

Five Major Enhancements of SAS Embedded Process for Hadoop for SAS 9.4 M3

The SAS In-Database Embedded Process is the key technology which enables the SAS® Scoring Accelerator, SAS® Code Accelerator, and SAS® Data Quality Accelerator products to function. The EP is the computation engine we place near the data, which reduces unnecessary data movement and speeds up processing and efficiency. The EP

Read More

Programming Tips | SAS Administrators

Gerry NelsonOctober 7, 2015 0

Part 2: Auditing data access, who did what and when?

In my last blog, I demonstrated how to configure a SAS server to write a record to a log file showing who is opening, editing or renaming a SAS table. In this blog we will see how we can process that information. The documentation shows one way to do this via

Read More

Learn SAS | Programming Tips

Rick WicklinOctober 5, 2015 0

How to generate random integers in SAS

You can use SAS to generate random integers between 1–10 or in the range 1–100. This article shows how to generate random integers as easily as Excel does. I was recently talking with some SAS customers and I was asked "Why can't SAS create an easy way to generate random

Read More

Programming Tips | SAS Administrators

Gerry NelsonSeptember 30, 2015 0

Auditing data access: who did what and when?

SAS Administrators are frequently asked to log and report on which users are accessing SAS tables. This functionality is often requested by companies who, for regulatory compliance, need to track who is accessing data. In my next couple of blogs I will show how you can audit data access. In this first blog

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerSeptember 28, 2015 0

Using SAS DS2 to parse JSON

Update 02Dec2016: Beginning with SAS 9.4 Maintenance 4, there is now a JSON libname engine. Read this new article to learn more -- you might prefer it to using DS2 for this task! Thanks to the proliferation of cloud services and REST-based APIs, SAS users have been making use of

Read More

Programming Tips

Lelia McConnellSeptember 18, 2015 0

Specifying Unicode values and colors easier with PROC SGPLOT and GTL

Many users of ODS Graphics will be excited to learn that, beginning with SAS® 9.4 TS1M3, SG procedures are able to recognize formatted values that contain Unicode values. One benefit of this is that it allows you to include, without using annotation, special symbols such as greater-than-or-equal-to signs or Greek

Read More

Programming Tips | SAS Administrators

Dave NadenSeptember 17, 2015 0

Monitoring Database Usage with SAS Environment Manager

Many administrators are familiar with the well-known “WIP Data Server” component of a SAS installation–so this blog takes a closer look at it, and shows how easy it is to monitor how large the database is growing. This data server contains a SAS-critical database known as the SharedServices Database, which is

Read More

Programming Tips

Teri PatsilarasSeptember 16, 2015 0

Accessing VA Reports with Parameterized URLs

The SAS Visual Analytics 7.2 release introduced context sensitive URLs for VA reports which means we can now directly pass parameter values in the URLs! This opens the door and allows for greater flexibility when needing to use a URL to access a VA report. One use would be if

Read More

Programming Tips | SAS Events

Nancy MoserSeptember 8, 2015 0

Rebooting the Little SAS Book: Catching up with the authors before WUSS 2015

Ask any user how they first learned SAS and there’s a good chance they’ll cite The Little SAS Book as a resource they used to get started. Authors Lora Delwiche, Susan Slaughter, and Rebecca Ottesen have written a new book that promises to be just as helpful to new SAS

Read More

Learn SAS | Programming Tips

Lora D. DelwicheSeptember 3, 2015 0

What’s wrong with this SAS program?

I think everyone can agree that being able to debug programs is an important skill for SAS programmers. That’s why Susan Slaughter and I devoted a whole chapter to it in The Little SAS® Book. I don’t know about you, but I think figuring out what’s wrong with my program

Read More

Programming Tips | SAS Administrators

Scott McCauleySeptember 3, 2015 0

Deleting old backups with SAS Backup Manager

As Gerry Nelson pointed out in an earlier post on 9.4M3, a new interface to the SAS Backup and Recovery Tool is available from the Administration application in SAS Environment Manager. This new SAS Backup Manager interface makes scheduling regular backups and executing ad hoc backups extremely easy to do

Read More

Programming Tips | SAS Administrators

Bobbie WagonerSeptember 2, 2015 0

SAS Visual Analytics 7.3: Check out the sample reports!

New in the 7.3 release, SAS Visual Analytics now provides sample objects. During installation, the SAS Deployment Wizard prompts you to include sample reports by default. In addition to eight reports, an exploration and ten sample datasets are also included in the samples. These sample reports and datasets are available by industry

Read More

Learn SAS | Programming Tips

Ruth Dobson-TorresSeptember 2, 2015 0

Serving up SAS training in cities near you

The 2015 United States Tennis Open tournament is now underway, and like most tennis fans, I’ve got my eyes on women’s tennis great Serena Williams, as she attempts to make history by winning the tournament and achieving a calendar Grand Slam. What are her chances of reaching the milestone? Most

Read More

Programming Tips | SAS Administrators

Edoardo RivaAugust 27, 2015 0

What’s new in SAS Grid Manager 9.4M3 architecture

If you have, or are considering, SAS Grid Manager, you’ll be excited to hear about two new changes to the product that make it even better for managing and processing in your analytics environment. The two changes were made in conjunction with the release of SAS 9.4M3 in July, and

Read More

Programming Tips | SAS Administrators

Rob CollumAugust 26, 2015 0

Keeping SAS current with Java 7

As of April 15, 2015, Oracle is no longer providing public updates of the Java 7 runtime environment (JRE) or software development kit (JDK). SAS 9.3 and SAS 9.4, however, continue to rely on Java 7 for support of business production. SAS has therefore contracted with Oracle to continue receiving

Read More

Programming Tips

Jerry LeonardAugust 21, 2015 0

Creating Quantile Groups

SAS users often ask me about the best way to group or bin their data in preparation for additional analysis. Depending on the need, there are several ways to achieve this using SAS procedures or other SAS processing. Creating user-defined formats with PROC FORMAT or using Data step processing are

Read More

Programming Tips | SAS Administrators

Dave NadenAugust 19, 2015 0

Monitor your SASWORK directory from SAS Environment Manager

Everyone who codes with SAS knows what the SASWORK directory space is, and everyone who has ever managed a medium-large installation knows that you need to monitor this space to avoid a huge buildup of worthless disk usage. One of the most common snarls happens when large SAS jobs go

Read More

Data Visualization | Programming Tips

Warren F. KuhfeldAugust 17, 2015 0

Advanced ODS Graphics: Annotating multiple panels

In the past few weeks, I have written two posts on SG annotation and on saving and then modifying the graphs that analytical procedures produce: Modifying dynamic variables in ODS Graphics Annotating graphs from analytical PROCs Today, I finish this series with one more post. This one shows how you

Read More

Programming Tips | SAS Administrators

Bobbie WagonerAugust 13, 2015 0

Visual Analytics 7.3: A peek at HTML5 interfaces

The new 7.3 release of SAS Visual Analytics not only uses the new HTML5 home page as the entry point to the Visual Analytics environment, but also introduces the new HTML5 viewer. The HTML5 home page interface features a personalized welcome message, tiles for content organization (Recent, Links, Favorites), icons to access

Read More

Programming Tips

Stephen FoersterAugust 11, 2015 0

Loading LASR Remotely with DI Studio (SAS/Connect)

The SASIOLA libname engine is now delivered with most SAS software orders so that we can load LASR environments remotely from separate SAS environments. For example, maybe you have an existing SAS “ETL” machine that you use to access your source environments and load your target environments. With the SASIOLA

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerAugust 10, 2015 0

Copy data and column names from SAS Enterprise Guide

While I've often written about how to get your SAS data to Microsoft Excel in some automated way, I haven't really addressed what's probably the most frequently used method: copy and paste. SAS Enterprise Guide 7.1 added a nifty little feature that makes copy-and-paste even more useful. The new "Copy

Read More

Data Visualization | Programming Tips

Warren F. KuhfeldAugust 10, 2015 0

Advanced ODS Graphics: Annotating graphs from analytical PROCs

There are many ways to modify the graphs that SAS creates. Standard graph customization methods include template modification (which most people use to modify graphs that analytical procedures produce) and SG annotation (which most people use to modify graphs that procedures such as PROC SGPLOT produce). However, you can also

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerAugust 3, 2015 0

Using Lua within your SAS programs

With apologies to this candy advertisement from the 1980s: "Hey, you got your Lua in my SAS program." "You got your SAS code in my Lua program!" Announcer: "PROC LUA: Two great programming languages that program great together!" What is Lua? It's an embeddable scripting language that is often used

Read More

Previous 1 … 47 48 49 50 51 … 65 Next