Blogs

Blogs

Learn SAS

Learn about the latest tips, tutorials, upcoming events and certifications

Analytics | Learn SAS

Rick WicklinAugust 1, 2018 0

Which variables are in the final selected model?

When you use a regression procedure in SAS that supports variable selection (GLMSELECT or QUANTSELECT), did you know that the procedures automatically produce a macro variable that contains the names of the selected variables? This article provides examples and details. A previous article provides an overview of the 'SELECT' procedures

Read More

Analytics | Learn SAS | Programming Tips

Rick WicklinJuly 30, 2018 0

Meaningful names for columns of a design matrix

A programmer recently asked a question on a SAS discussion forum about design matrices for categorical variables. He had generated a design matrix by using PROC GLMMOD and wanted to use the design columns in a subsequent procedure. However, the columns were named COL1, COL2, COL3,..., so he couldn't tell

Read More

Learn SAS | Programming Tips

Jane EslingerJuly 25, 2018 0

Fun with Dots in PROC REPORT

You should play a little. Add dots. Add color. Your PROC REPORT output does not have to be boring. As a matter of fact, it can be both functional and appealing. Any Unicode value will do, but this blog shows how to use the Unicode value for a dot (filled

Read More

Learn SAS | Programming Tips

Joe FurbeeJuly 25, 2018 0

Using RStudio with SAS Viya

Getting started with SAS Viya and RStudio -- making the connection, and submitting my first commands via CAS actions.

Read More

Analytics | Learn SAS | Programming Tips

Rick WicklinJuly 23, 2018 0

How to use the %BOOT and %BOOTCI macros in SAS

Since the late 1990s, SAS has supplied macros for basic bootstrap and jackknife analyses. This article provides an example that shows how to use the %BOOT and %BOOTCI macros. The %BOOT macro generates a bootstrap distribution and computes basic statistics about the bootstrap distribution, including estimates of bias, standard error,

Read More

Learn SAS | Programming Tips

Chris Hemedinger

Chris HemedingerJuly 20, 2018 0

SAS code golf: find the max digit in a string of digits

"Code golf" is a fun programming pastime that challenges you to solve a problem with the least amount of code possible. Like regular golf, the goal is to use fewest code "strokes" to hit the mark. Here's a recent challenge that was posted to me via Twitter. @cjdinger @SASJedi got

Read More

Learn SAS | Programming Tips

Kathryn McLawhornJuly 19, 2018 0

Keeping the top frequency count (n) for each character variable in a SAS data set

Which character variables have the highest frequency count? You can easily determine this using a variety of procedures that calculate frequency count. For example, the FREQ Procedure or the MEANS Procedure. This blog post illustrates this process through two examples.

Read More

Data Management | Learn SAS | Programming Tips | SAS Administrators

Leonid BatkhanJuly 17, 2018 0

SAS administrators tip: Automatically deleting old SAS logs

SAS batch jobs can generate many log files that accumulate over time. In this post, we present a SAS program that cleans up old log files on your system.

Read More

Learn SAS

Sian RobertsJuly 16, 2018 0

What DS2 can do for the DATA step

The Base SAS DATA step has been a powerful tool for many years for SAS programmers. But as data sets grow and programmers work with massively parallel processing (MPP) computing environments such as Teradata, Hadoop or the SAS High-Performance Analytics grid, the data step remains stubbornly single-threaded. Welcome DS2 –

Read More

Data Management | Learn SAS

Natasha Ulanowski

Natasha UlanowskiJuly 10, 2018 0

No typical SAS user: how three professionals prep data using SAS

Did you know that 80 percent of an analytics life cycle is time spent on data preparation? For many SAS users and administrators, data preparation is what you live and breathe day in and day out. Your analysis is only as good as your data, and that's why we wanted

Read More

Data Visualization | Learn SAS | Programming Tips

Jim SimonJune 29, 2018 0

Custom Maps in SAS Visual Analytics: My Neighborhood

The Geo Map Visualization has several built-in geographical units, including country and region names and codes, US state names and codes, and US zip codes. You can also define your own geographic units. This paper describes how to identify any geographic point of interest, or collection of points, on a map to create custom maps in SAS.

Read More

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeJune 25, 2018 0

Pie Charts Redux

It seems only a few months back I posted an article on creating Pie Charts using a GTL based macro. Well, looking back, that was almost 6 years ago!! Recently, a colleague here at SAS needed to create Pie Charts in his report along with other plots created using SGPLOT

Read More

Learn SAS | Programming Tips

Jody CarltonJune 22, 2018 0

A transcoding story (or, How Oliver S. Füßling lost his last name and comes to find it again)

There are many ways to avoid transcoding problems when you have national language characters in SAS programs that you save from a SAS®9 (English) session and move to a UTF-8 environment. In this article, we'll share tips to help you avoid such issues.

Read More

Learn SAS | Programming Tips

Excel named range

Chris Hemedinger

Chris HemedingerJune 21, 2018 0

How to use SAS to read a range of cells from Excel

I've said it before: spreadsheets are not databases. However, many of us use spreadsheets as if they were databases, and then we struggle when the spreadsheet layout does not support database-style rigor of predictable rows, columns, and variable types -- the basic elements we need for analytics and reporting. If

Read More

Learn SAS | Programming Tips

Allison SaitoJune 18, 2018 0

Changing font size in SAS

When making a new piece of code, I like to use the smallest font I can read. This lets me fit more text on the screen at once. When presenting code to others, especially in a classroom setting, I like to make the font large enough to see from the back of the room. Here’s how I change font size in SAS in our three programming interfaces.

Read More

Analytics | Learn SAS

Rick WicklinJune 18, 2018 0

The BOOTSTRAP statement for t tests in SAS

Bootstrap resampling is a powerful way to estimate the standard error for a statistic without making any parametric assumptions about its sampling distribution. The bootstrap method is often implemented by using a sequence of calls to resample from the data, compute a statistic on each sample, and analyze the bootstrap

Read More

Data Visualization | Learn SAS

Rick WicklinJune 13, 2018 0

Attrs, attrs, everywhere: The interaction between ATTRPRIORITY, CYCLEATTRS, and STYLEATTRS in ODS graphics

If you use PROC SGPLOT to create ODS graphics, "ATTRS" are everywhere. ATTRS is an abbreviation of "attributes." Most options that change the attributes of a graphical element end with the ATTRS suffix. For example, the MARKERATTRS option modifies attributes of markers, the LINEATTRS option modifies attributes of lines, and

Read More

Learn SAS | Programming Tips

Rick WicklinJune 11, 2018 0

6 ways to use the _NULL_ data set in SAS

In SAS, the reserved keyword _NULL_ specifies a SAS data set that has no observations and no variables. When you specify _NULL_ as the name of an output data set, the output is not written. The _NULL_ data set is often used when you want to execute DATA step code

Read More

Learn SAS | Programming Tips

Rick WicklinJune 8, 2018 0

Video: A new syntax for lists in SAS/IML

I recently recorded a short video about the new syntax for specifying and manipulating lists in SAS/IML 14.3. This is a video of my Super Demo at SAS Global Forum 2018. The new syntax supports dynamic arrays, associative arrays ("named lists"), and hierarchical data structures such as lists of lists.

Read More

Learn SAS | Programming Tips | SAS Administrators

Leonid BatkhanMay 30, 2018 0

Are you developing foolproof solutions?

It is imperative for developers, whether hardware or software engineers, to foresee unintended (probable or improbable) system usages and implement features that will make their creations foolproof, that is protected from misuse. Learn more about developing foolproof solutions with this old Russian anecdote.

Read More

Analytics | Learn SAS | SAS Events

Lexi HawksMay 29, 2018 0

Top 10 tips for SAS Enterprise Miner

SAS Enterprise Miner has been a leader in data mining and modeling for over 20 years. The system offers over 80 different nodes that help users analyze, score and model their data. Here are the Top Ten Tips for Enterprise Miner from a user with more than 20 years of experience.

Read More

Learn SAS | Programming Tips

Rick WicklinMay 29, 2018 0

6 easy ways to specify a list of variables in SAS

The SAS language provides syntax that enables you to quickly specify a list of variables. SAS statements that accept variable lists include the KEEP and DROP statements, the ARRAY statement, and the OF operator for comma-separated arguments to some functions. You can also use variable lists on the VAR statements

Read More

Learn SAS | Programming Tips

Jane EslingerMay 23, 2018 0

Custom Style Templates: Start Small

SAS author Jane Eslinger shows give you tips for working with PROC TEMPLATE when diving into the Output Delivery System (ODS) world. Learn how to create a custom style template to get the stylized output you want.

Read More

Learn SAS | Programming Tips

Martin MinceyMay 18, 2018 0

How to change your working directory for SAS® with the DLGCDIR DATA step function

Learn how to change your working directory for SAS. Beginning with SAS® 9.4 TS1M4, you can use a new DATA step function, DLGCDIR, to change the location of your working directory.

Read More

Learn SAS | Machine Learning | Programming Tips

SAS KoreaMay 18, 2018 0

[프로그래밍 팁] SAS VDMML로 딥러닝 모델 구축하는 방법

SAS 솔루션으로 다양한 종류의 심층 신경망(DNN;Deep Neural Network) 모델을 구축할 수 있습니다. 구체적으로 컨볼루션 신경망(convolutional neural networks), 순환 신경망(recurrent neural networks), 순방향 신경망(feedforward neural networks), 오토인코더 신경망(autoencoder neural networks) 등을 생성할 수 있는데요. 오늘은 ‘SAS VDMML(Visual Data Mining and Machine Learning)'을 이용해 딥러닝 모델을 구축하는 방법을 자세히 설명해 드리고자 합니다. ‘SAS 클라우드 분석 서비스’를 활용한 딥러닝

Read More

Data Visualization | Learn SAS | Programming Tips

Sanjay MatangeMay 13, 2018 0

A Combined WaterFall and Swimmer Plot

The PharmaSUG 2018 conference was held two weeks ago, with great enthusiasm and a record attendance. The highlight for me was the large spread on visual presentation of data, from papers to poster presentations. I will provide a more detailed report on all the exciting graphical presentations. One topic of

Read More

Health Care | Life Sciences

Learn SAS | SAS Events

Larry LaRussoMay 9, 2018 0

Knowledge from the SAS family: SAS Global Forum 2018 papers and videos now available

For those of you who weren't able to attend SAS Global Forum 2018, you can still learn a lot from the content shared there. Gain knowledge from your SAS family. SAS Global Forum 2018 papers and videos now available.

Read More

Learn SAS | SAS Events

Sian RobertsMay 8, 2018 0

Top 10 bestselling titles at SAS Global Forum 2018

In this blog post you'll find out the top 10 bestselling titles at SAS Global Forum 2018.

Read More

Learn SAS | Programming Tips

Jim SimonMay 7, 2018 0

"Wide" versus "Tall" data: PROC TRANSPOSE v. the DATA step

Datasets can present themselves in different ways. Identical data can bet arranged differently, often as wide or tall datasets. Generally, the tall dataset is better. Learn how to convert wide data into tall data with PROC TRANSPOSE.

Read More

Learn SAS | Programming Tips

Jim SimonMay 7, 2018 0

Deleting global macro variables

Do you periodically delete unneeded global macro variables? You should! Deleting macro variables releases memory and keeps your symbol table clean. Learn how the macro language statement that deletes global macro variables and about the %DELETEALL statement that can be a life saver for macro programmers.

Read More

Previous 1 … 21 22 23 24 25 … 41 Next