The DO Loop

Learn SAS

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

Learn SAS

Rick WicklinOctober 28, 2013 12

How to order categories in a two-way table with PROC FREQ

If you've ever tried to use PROC FREQ to create a frequency table of two character variables, you know that by default the categories for each variable are displayed in alphabetical order. A different order is sometimes more useful. For example, consider the following two-way table for the smoking status

English

Learn SAS

Rick WicklinOctober 21, 2013 4

Assign the diagonal elements of a matrix

SAS/IML programmers know that the VECDIAG matrix can be used to extract the diagonal elements of a matrix. For example, the following statements extract the diagonal of a 3 x 3 matrix: proc iml; m = {1 2 3, 4 5 6, 7 8 9}; v = vecdiag(m); /* v = {1,5,9}

English

Learn SAS

Rick WicklinOctober 18, 2013 2

Rotating matrices

This article is about rotating matrices. No, I don't mean "rotation matrices," I mean rotating matrices. As in turning a matrix 90 degrees in a clockwise or counterclockwise direction. I was reading a program written in MATLAB in which the programmer used a MATLAB function called ROT90, which rotates a

English

Learn SAS

Rick WicklinOctober 7, 2013 1

How to create a library of functions in PROC IML

What is the best way to share SAS/IML functions with your colleagues? Give them the source code? Create a function library that they can use? This article describes three techniques that make your SAS/IML functions accessible to others. As background, remember that you can define new functions and subroutines in

English

Advanced Analytics | Learn SAS

Rick WicklinSeptember 30, 2013 16

Generate combinations in SAS

Last week I described how to generate permutations in SAS. A related concept is the "combination." In probability and statistics, a combination is a subset of k items chosen from a set that contains N items. Order does not matter, so although the ordered triplets (B, A, C) and (C,

English

Advanced Analytics | Learn SAS

Rick WicklinSeptember 23, 2013 5

Generate permutations in SAS

I've written several articles that show how to generate permutations in SAS. In the SAS DATA step, you can use the ALLPEM subroutine to generate all permutations of a DATA step array that contain a small number (18 or fewer) elements. In addition, the PLAN procedure enables you to generate

English

Learn SAS

Rick WicklinSeptember 13, 2013 9

The difference between frequencies and weights in regression analysis

This week I read an interesting blog post that led to a discussion about specifying the frequencies of observations in a regression model. In SAS software, many of the analysis procedures contain a FREQ statement for specifying frequencies and a WEIGHT statement for specifying weights in a weighted regression. Theis

English

Learn SAS

Rick WicklinSeptember 3, 2013 4

Convert a string into a vector of characters

Sometimes it is useful in the SAS/IML language to convert a character string into a vector of one-character values. For example, you might want to count the frequency distribution of characters, which is easy when each character is an element of a vector. The question of how to convert a

English

Learn SAS

Rick WicklinAugust 26, 2013 3

Determine the version of SAS software at run time

Recently I wrote about how to determine the age of your SAS release. Experienced SAS programmers know that you can programatically determine information about your SAS release by using certain automatic macro variables that SAS provides: SYSVER: contains the major and minor version of the SAS release SYSVLONG: contains the

English

Learn SAS

Rick WicklinAugust 19, 2013 29

Errors that cause SAS to "freeze"... and what to do about them

Even the best programmers make mistakes. For most errors, SAS software displays the nature and location of the error, returns control to the programmer, and awaits further instructions. However, there are a handful of insidious errors that cause SAS to think that a statement or program is not finished. For

English

Blogs

Blogs

Learn SAS