Blogs

Blogs

Learn SAS

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

Learn SAS

Rick WicklinJuly 20, 2015 0

Create a density curve with shaded tails

A SAS programmer wanted to plot the normal distribution and highlight the area under curve that corresponds to the tails of the distribution. For example, the following plot shows the lower decile shaded in blue and the upper decile shaded in red. An easy way to do this in SAS

Read More

Data Visualization | Learn SAS | Programming Tips

Leonid BatkhanJuly 16, 2015 0

Integrating SAS reports with Google maps: two-pane solution

➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in

Read More

Learn SAS

Rick WicklinJuly 13, 2015 0

Compare the performance of algorithms in SAS

As my colleague Margaret Crevar recently wrote, it is useful to know how long SAS programs take to run. Margaret and others have written about how to use the SAS FULLSTIMER option to monitor the performance of the SAS system. In fact, SAS distributes a macro that enables you to

Read More

Analytics | Learn SAS

Maggie MillerJune 30, 2015 0

Top 3 reasons to attend Analytics 2015 in Las Vegas

I’m not a big gambler, but there is something I would put my money on – analytics. Analytics is helping companies turn information into value. And yes, I mean money. If you want to learn about the latest analytics trends and get in on some of that “value” – attend

Read More

Learn SAS

Rick WicklinJune 29, 2015 0

An easy way to use numbers for column headers

When I am computing with SAS/IML matrices and vectors, I often want to label the columns or rows so that I can better understand the data. The labels are called headers, and the COLNAME= and ROWNAME= options in the SAS/IML PRINT statement enable you to add headers for columns and

Read More

Learn SAS | Programming Tips | SAS Events

Maggie MillerJune 24, 2015 0

2 days. 2 exams. 2 SAS certifications.

In just one weekend Shang-Hua Wu went from a SAS user to a super SAS user by getting not just one, but two SAS certifications – SAS Certified Base Programmer and SAS Certified Advanced Programmer. Wu wanted to earn his certifications to position himself for new career opportunities in the

Read More

Analytics | Data Visualization | Learn SAS

Robert AllisonJune 19, 2015 0

How to handle time (mm:ss.ss) values in SAS

One of my earlier blogs on handling percent (%) values in SAS was very popular (it's been viewed over 34,000 times!), so I thought I'd write a similar blog on handling time (mm:ss.ss) values in SAS ... This past weekend I was in a dragonboat race (that's me in the

Read More

Sports & Entertainment

Learn SAS | Programming Tips

Cindy CraginJune 17, 2015 0

SAS Enterprise Guide: Suppress Output Data tab when programming

Have you ever waited a bit for SAS Enterprise Guide to display the Output Data tab when submitting a SAS program that generates multiple output tables? Or, perhaps your program only generates one big output table but it takes a little while for it to surface on the Output Data

Read More

Advanced Analytics | Learn SAS

Rick WicklinJune 17, 2015 0

Everything you wanted to know about writing SAS/IML modules

One of the fundamental principles of computer programming is to break a task into smaller subtasks and to modularize the program by encapsulating each subtask into its own function. I have written many blog posts over the years about how to define and use functions in the SAS/IML language. I

Read More

Advanced Analytics | Learn SAS | Students & Educators

Polly Mitchell-GuthrieJune 11, 2015 0

Three final talent tips: how to hire data scientists (part 4)

How do we hire data scientists at SAS, since we are not unique in our search for a rare talent type that continues to be in high demand? This post is the last in a series on finding data scientists, based on best practices at SAS and illustrated with some

Read More

Learn SAS | Programming Tips

Chris Hemedinger

Chris HemedingerJune 11, 2015 0

Ask the Expert: Creating custom tasks for SAS Enterprise Guide

If you have not yet discovered the new Ask the Expert series on the SAS Training site, you are missing out on a treasure. Visit the site right now and review all of the available topics, from "Newbie" to Analytics to Visualization to good ol' SAS programming. Go on; I'll

Read More

Learn SAS

Jim SimonJune 8, 2015 0

DATA STEP text file tricks

When reading a text file (common extensions: TXT, DAT; or, for the adventurous: HTML) with the DATA STEP, you should always view several lines from the text file, and compare to the record layout, before completing the INPUT statement. There are many ways to view a text file. I use

Read More

Data Visualization | Learn SAS | Programming Tips

Sample of Google map with embedded SAS ODS output

Leonid BatkhanJune 5, 2015 0

SAS ODS destination - Google maps

➤ DISCLOSURE! In June 2018 Google introduced changes to the way it handles its Maps platform. They now require API key in order to embed a map, plus Google Maps "projects" must now be associated with a billing account. Unless these new Google rules are met, Google maps described in

Read More

Learn SAS

Jim SimonJune 4, 2015 0

Weird PROC FREQ trick

Default PROC FREQ output looks like this: Suppose you don't want the two cumulative statistic columns above. No problem. Those can be suppressed with the NOCUM option on the TABLE statement, like this: proc freq data=sashelp.shoes; table product / nocum; run;

Read More

Learn SAS | Programming Tips

Charu ShankarJune 1, 2015 0

Looking for a SAS job? Join the 21-day SAS challenge

I recently taught a SAS training course where the students were very engaged. They had so many questions, I could have spent the next month writing helpful blog posts that came from that one class. However, I picked this one question that the class begged for me to share. The

Read More

Learn SAS

Rick WicklinJune 1, 2015 0

SAS/IML functions that operate on columns of a matrix

A SAS programmer asked for a list of SAS/IML functions that operate on the columns of an n x p matrix and return a 1 x p row vector of results. The functions that behave this way tend to compute univariate descriptive statistics such as the mean, median, standard deviation, and quantiles. The following

Read More

Learn SAS

Rick WicklinMay 28, 2015 0

Five reasons to use ODS EXCLUDE to suppress SAS output

I previously wrote about the best way to suppress output from SAS procedures. Suppressing output is necessary in simulation and bootstrap analyses, and it is useful in other contexts as well. In my previous article, I wrote, "many programmers use ODS _ALL_ CLOSE as a way to suppress output, but

Read More

Learn SAS | SAS Events

Sian RobertsMay 27, 2015 0

Top 10 bestselling titles at SAS Global Forum 2015

The final figures are in! This year there was a fierce battle for the top spot of the SAS Global Forum 2015 books bestseller list. In a nail biting finish, newcomer, Exchanging Data between SAS and Microsoft Excel: Tips and Techniques to Transfer and Manage Data More Efficiently, beat off

Read More

Learn SAS | Programming Tips

Charu ShankarMay 27, 2015 0

Life saver tip for comparing PROC SQL join with SAS data step merge

“Phew! That tip alone was a life saver,” said a student in one of my SAS SQL classes. “Before, I would have to read about ten Google search results before I could find that content of the sort you shared in class.” That student was referring to the tip I

Read More

Learn SAS

Lauren Haworth LakeMay 26, 2015 0

3 reasons you need the new edition of PROC TABULATE by Example

What prompted me to find a co-author and write a new edition of my original book on PROC TABULATE? It’s those inventive developers at SAS. They keep adding new features to make the product even better. There are too many new features and techniques in the book to name, but these are

Read More

Learn SAS | Programming Tips

Chris Hemedinger

Chris HemedingerMay 20, 2015 0

Using LIBNAME XLSX to read and write Excel files

The XLSX libname engine in SAS allows you to read and write Microsoft Excel files in the same way that you can work with other data sets and databases. This article describes the basic (and some limitations) of the XLSX engine.

Read More

Learn SAS

Jim SimonMay 18, 2015 0

Dataset too big for PROC PRINT?

Dataset too big for PROC PRINT? One weird trick solves your problem! proc print data=bigdata (obs=10); run; The OBS= dataset option specifies the last observation to process from an input dataset. In the above example, regardless of dataset size, only the first 10 observations are printed; an easy way to

Read More

Advanced Analytics | Learn SAS

Rick WicklinMay 11, 2015 0

Finding observations that satisfy multiple conditions: The LOC-ELEMENT technique

A common task in data analysis is to locate observations that satisfy multiple criteria. For example, you might want to locate all zip codes in certain counties within specified states. The SAS DATA step contains the powerful WHERE statement, which enables you to extract a subset of data that satisfy

Read More

Learn SAS | Programming Tips

Michael A. RaithelMay 8, 2015 0

Doctor, I have this friend who has a pain right about here

We have all heard the old joke about the person who sidles up to a doctor at a party and describes in great detail a medical problem a "friend" is having in order to get free medical advice. It could just as easily be a person buttonholing an accountant for

Read More

Learn SAS | Programming Tips

Charu ShankarMay 6, 2015 0

10 reasons to learn SAS code even when you have Enterprise Guide

New York City Mayor, Michael Bloomberg made a new-year's resolution to learn code. Apple’s Steve Jobs said, “I think everybody in this country should learn how to program a computer because it teaches you how to think.” President Barrack Obama said, "Don't just buy a new video game, make one.

Read More

Learn SAS

Michael SmithMay 4, 2015 0

Become SAS certified at PharmaSUG and save 50% on the exam cost

If you’re one of the hundreds of SAS users registered for PharmaSUG, scheduled for May 17-20 in Orlando, you should give extending your stay some serious thought. In just a few hours, you can set yourself apart with a professional certification from SAS! SAS is offering something no theme park

Read More

Learn SAS

Rick WicklinMay 4, 2015 0

An easy way to clear your SAS titles

Did you know that if you have set multiple titles in SAS, that there is an easy way to remove them? For example, suppose that you've written the following statements, which call the TITLE statement to set three titles: title "A Great Big Papa Title"; title2 "A Medium-sized Mama Title";

Read More

Learn SAS

Patricia SpainMay 1, 2015 0

Where do you e-learn SAS?

We’re celebrating the student in all of us and you’re invited. Email us a photo of yourself or your fav SAS user learning SAS. Send it to sastraining@sas.com. You can also Tweet us your best shot using #SASworldclass Our planet-friendly training is available worldwide, wherever you may be. Show us

Read More

Learn SAS | SAS Events

Carrie VetterApril 24, 2015 0

Technical experts on hand at SAS Global Forum

The SAS Training and Certification groups are excited to participate in SAS Global Forum 2015! We’ll have a booth in the Quad where you can stop by to ask questions, talk to your favorite instructor and register to win an iPad! We offer courses on almost every SAS product so to

Read More

Advanced Analytics | Learn SAS

Rick WicklinApril 22, 2015 0

Sum a series in SAS

A customer asked: How do we go about summing a finite series in SAS? For example, I want to compute for various integers n ≥ 3. I want to output two columns, one for the natural numbers and one for the summation of the series. Summations arise often in statistical

Read More

Previous 1 … 32 33 34 35 36 … 41 Next