Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Programming Tips

Kathryn McLawhornMay 20, 2016 0

Seeing the FREQ procedure's one-way tables in a new light

PROC FREQ is often the first choice when you want to generate basic frequency counts, but it is the last choice when it is compared to other statistical reporting procedures. People sometimes consider PROC FREQ last because they think they have little or no control over the appearance of the

Read More

Programming Tips | SAS Administrators

Dave NadenMay 18, 2016 0

Creating custom reports from the Data Mart

My previous blog discussed the SAS Environment Manager Report Center, and talked about its organization, and how to start using some of the prompts to get the reports you want. The next step is to learn to use some of the example reports provided to help you design your own, production-level

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMay 15, 2016 0

Ad-hoc reporting with SAS: Tips for the e-mail jockey

What's the most common data reporting mechanism? Is it web-based reporting? PDFs? How about spreadsheets? Maybe, but in my experience many reports are delivered using a less-scalable and transient mechanism: e-mail. I'm a data steward at SAS. Specifically, I look after the operational data around our blogging program and our

Read More

Data Management | Programming Tips

Mary Kathryn QueenMay 13, 2016 0

Improving matching results in DataFlux Data Management Studio with cluster comparison

Trusted data is key to driving accurate reporting and analysis, and ultimately, making the right decision. SAS Data Quality and SAS Data Management are two offerings that help create a trusted, blended view of your data. Both contain DataFlux Data Management Studio, a key component in profiling, enriching monitoring, governing

Read More

Programming Tips | SAS Administrators

Edoardo RivaMay 4, 2016 0

Is your new grid behaving oddly?

New default parameter values for Platform Suite for SAS Sometimes, when your kids grow older, they change their habits and you don’t recognize their behaviors any more. “We play this game every year at the beach. Don’t you like it anymore?” you ask. “Dad, I’m not seven years old any

Read More

Programming Tips

Tweet says "Make this a button in base SAS"

SAS JediMay 1, 2016 0

Jedi SAS Tricks - Make This a Button in Base SAS

A recent post, Jedi SAS Tricks: The DATA to DATA Step Macro, engendered a lot of response on Twitter. One of the re-tweets included a call to action - make this a button in Base SAS!

Read More

Programming Tips

Bobbie WagonerApril 29, 2016 0

Dealing with Dates in SAS Visual Analytics Designer

In a previous blog, I discussed SAS date and time values, and how date and time formats can be used to your advantage in SAS Visual Analytics. That blog addressed some of the features provided for handling date information, like date formats, date hierarchies, and calculated data items based on time

Read More

Data Visualization | Programming Tips

Teri PatsilarasApril 27, 2016 0

Use parameters to pick your metric in Visual Analytics Reports

Look at the report below. Imagine being asked to allow your users to select which Measure, highlighted in yellow, they are looking at: Income, Expense or Profit. This is a frequent report requirement and I’m going to outline just one of the ways you can design your report to satisfy

Read More

Learn SAS | Programming Tips

Charu ShankarApril 22, 2016 0

SAS training leads to certification success

Teaching SAS coding is fun. The best part of teaching is hearing success stories from candidates who earn a SAS certification after taking SAS training. Suiru Jiang is an MBA candidate who successfully passed her SAS certification exam. She took my five-day SAS programming fast track course at Goodman School

Read More

Programming Tips

Russ TyndallApril 22, 2016 0

Solutions for missing DATA step features within DS2

The DS2 programming language gives you the following powerful capabilities: The precision that results from using the new supported data types Access to the new expressions, write methods, and packages available in the DS2 syntax Ability to execute SAS Federated Query Language (FedSQL) from within the DS2 program Ability to

Read More

Programming Tips | SAS Administrators

Uttam KumarApril 19, 2016 0

Accessing SPD Engine Data using Hive

With the release of SAS® 9.4 M3, you can now access SAS Scalable Performance Data Engine (SPD Engine) data using Hive. SAS provides a custom Hive SerDe for reading SAS SPD Engine data stored on HDFS, enabling users to access the SPD Engine table from other applications. The SPD Engine

Read More

Learn SAS | Programming Tips | Risk Management

Leonid BatkhanApril 13, 2016 0

Automatic data suppression in SAS reports

Have you ever used SAS to produce reports for publishing? Have you ever thought of or been told about suppressing data in such reports? Why do we need to suppress (in the sense of withholding, concealing, obscuring or hiding) data in published reports? The reason is simple - in order

Read More

Programming Tips | SAS Administrators

Tricia JenkinsApril 12, 2016 0

Let me help you with that! A technical SAS resource guide

On the search for some SAS notes, workarounds or sample code? What you may not know is that there are a ton of SAS resources out there providing examples, tips and tricks that are great to have in your tool belt! Many of these resources provide sufficient insight and resolutions

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerApril 6, 2016 0

Boaty McBoatface is on the run

I know what you're thinking: two "Boaty McBoatface" articles within two weeks? And we're past April Fool's Day? But since I posted my original analysis about the "Name our ship" phenomenon that's happening in the UK right now, a new contender has appeared: Poppy-Mai. The cause of Poppy-Mai, a critically

Read More

Programming Tips

Edoardo RivaApril 6, 2016 0

SAS Studio Parallel Process Flows

One of the hidden gems of SAS Studio is the ability to run process flows in parallel. This feature really shines when used in a grid environment. Let’s discuss this one step at a time. First, what is a process flow? When working in the Visual Programmer perspective, you have

Read More

Programming Tips | SAS Administrators

Scott McCauleyApril 4, 2016 0

SAS Visual Analytics autoload configuration made easy

In the past, configuring a new autoload library for SAS Visual Analytics was a manual process involving steps to create very specific folder structures and to copy and edit scripts and SAS programs. No more! Updates to the SAS Deployment Manager have added a new task that creates and configures new autoload libraries

Read More

Data Visualization | Programming Tips

Warren F. KuhfeldMarch 31, 2016 0

Basic ODS Graphics Examples

I have written a new book: Basic ODS Graphics Examples. It is available as a free PDF file on the web. It is in color, and all of the SAS code is available by double clicking a link at the beginning of each example. This new book complements my other

Read More

Programming Tips | SAS Administrators

Dave NadenMarch 30, 2016 0

Opening Up the SAS Environment Manager Report Center

The SAS Environment Manager Report Center is a set of SAS stored processes and SAS macros which leverage the SAS Data Mart for the purpose of monitoring and auditing a SAS installation. Full documentation on the structure and functioning of the Data Mart can be found in the SAS Environment Manager

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMarch 25, 2016 0

And it's Boaty McBoatface by an order of magnitude

In a voting contest, is it possible for a huge population to get behind a ridiculous candidate with such force that no other contestant can possibly catch up? The answer is: Yes. Just ask the folks at NERC, the environmental research organization in the UK. They are commissioning a new

Read More

Programming Tips

Bobbie WagonerMarch 22, 2016 0

Making Best Use of Date Formats in Visual Analytics Designer

You may have noticed that when using date information in SAS Visual Analytics, that the date data values can be displayed in a variety of ways. You may see your dates displayed like Jan1916, 03Jun1915, or 03/12/16, for example. In this blog I’ll help you understand SAS date and time

Read More

Programming Tips

SAS JediMarch 11, 2016 0

Jedi SAS Tricks: The DATA to DATA Step Macro

I was answering questions about SAS in a forum the other day, and it struck me how much easier it is to help folks if they can provide a snippet of data to go along with their program when asking others to help troubleshoot. This makes it easy to run

Read More

Programming Tips

Kevin RussellMarch 11, 2016 0

Using a pipe to return the output of an operating system command to SAS® software

Being able to access information about your operating system from within SAS can be incredibly useful. For example, if you have a directory that contains an unknown number of CSV files that you would like to read into SAS, you certainly would not want to have to write an IMPORT

Read More

Data Management | Programming Tips

Nicolas RobertMarch 7, 2016 0

Data Governance Series: Share DataFlux Data Quality profiling metrics in SAS Visual Analytics (Part 2)

In this post, I continue the journey of getting data profiling results into SAS Visual Analytics. In my first blog I described the process of collecting DataFlux Data Quality profiling metrics to load a datamart. Now we load this datamart into memory (LASR) and then plug a VA report on

Read More

Learn SAS | Programming Tips

Leonid BatkhanMarch 4, 2016 0

Data-driven SAS macro loops

In my previous post, Introducing data-driven loops, I suggested a way of implementing programming loops with a list of index variables pulled from an external data table. These ordinary programming loops iterate during code execution while processing some data elements of an input data table. SAS macro loops, on the

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerMarch 4, 2016 0

Add files to a ZIP archive with FILENAME ZIP

In previous articles, I've shared tips about how you can work with SAS and ZIP files without requiring an external tool like WinZip, gzip, or 7-Zip. I've covered: How to create ZIP files with ODS PACKAGE ZIP (available since SAS 9.2) How to "unzip" and read ZIP files using FILENAME

Read More

Programming Tips

Edoardo RivaMarch 1, 2016 0

Avoid the pitfalls of parallel jobs

I recently received a call from a colleague that is using parallel processing in a grid environment; he lamented that SAS Enterprise Guide did not show in the work library any of the tables that were successfully created in his project. The issue was very clear in my mind, but

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerFebruary 28, 2016 0

The zoomiest new feature in SAS Enterprise Guide 7.12

Have you ever been in a meeting in which a presenter is showing content on a web page -- but the audience can't read it because it's too small? Then a guy sitting in the back of the room yells, "Control plus!". Because, as we all know (right?), "Ctrl+" is

Read More

Programming Tips | SAS Administrators

Uttam KumarFebruary 22, 2016 0

Copy data to Hadoop using SAS Data Loader

The SAS Data Loader directive ‘Copy Data to Hadoop’ enables you to copy data from DBMS to Hadoop Hive tables. The SAS Data Loader for Hadoop can be configured to copy data from any external database which offers JDBC database connectivity. SAS Data Loader uses the Apache Sqoop™ and Oozie

Read More

Programming Tips

Chris Hemedinger

Chris HemedingerFebruary 20, 2016 0

A custom task to list and stop your SAS sessions

Last week I described how to use PROC IOMOPERATE to list the active SAS sessions that have been spawned in your SAS environment. I promised that I would share a custom task that simplifies the technique. Today I'm sharing that task with you. How to get the SAS Spawned Processes

Read More

Programming Tips

Kim WilsonFebruary 19, 2016 0

Reasons to love PROC DS2

PROC DS2 (DS2) is a new SAS programming language that extends the power of the traditional DATA step. Some customers have wondered if this new functionality is simply the “DATA step on steroids,” meaning that we simply added more robust functionality so that it’s a replacement for the DATA step.

Read More

Previous 1 … 48 49 50 51 52 … 65 Next