New year refresher on reshaping data

As support analysts in the SAS Technical Support division, we answer many phone calls from SAS customers.  As members of the SAS Foundation team, we get questions that vary significantly in content from all of the areas that we support.  We offer coding tips and suggestions as well as point […]

Post a Comment

Will indexing my SAS data sets help?

Will indexing my SAS data sets help? This is one of the most frequent questions I hear in SAS Technical Support.  The response is always the same: “Maybe.  Tell me about your data, and what you are doing with it.”  Here is a primer on effective indexing. Indexing can improve […]

Post a Comment

How to increase the resolution of your SAS graphics output

If your graphics look a little on the fuzzy or blurry side, there are lots of ways to increase the resolution of your SAS graphics output. Let’s go over some of these methods. Before increasing the resolution of your graphics output, check to see what you are creating your graphics […]

Post a Comment

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 […]

Post a Comment

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 […]

Post a Comment

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 […]

Post a Comment

Customizing output from PROC MEANS

Customizing the output data set created using the OUTPUT statement When you request statistics on the PROC MEANS statement, the default printed output creates a nice table with the analysis variable names in the left-most column and the statistics forming the additional columns.  Even if you create an output data […]

Post a Comment

Can you Lag and Lead at the same time? If using the SAS DATA step, yes you can

Within the SAS DATA step, the LAG function is provided to return a variable’s value from a previous data set observation.  With certain data criteria, sometimes there is a need to look ahead at the next observation and you would expect to use a LEAD function, but this does not […]

Post a Comment

ODS PDF destination in SAS 9.4: Come take a look under the hood!

If you have programmed with SAS in the last 15 years, you have probably had a reason to share your SAS results in PDF format. The ODS PDF destination, much like a well-designed car, has evolved over the years, offering progressively nicer features like security, enhanced image formatting and embedded […]

Post a Comment

Turning text files into SAS data sets—6 common problems and their solutions

If you’re reading this blog post, you have probably gotten a text file from someone that needs to be turned into a SAS data set so that it can be manipulated, analyzed and made into a report. It all starts with getting the data into SAS. Sometimes that requires a […]

Post a Comment