Macro Myth: The closest non-empty symbol table

This SAS tip is from Robert Virgile and his book “SAS Macro Language Magic: Discovering Advanced Techniques”. We hope you find this tip useful. You can also read an excerpt from Virgile’s book. When CALL SYMPUT creates a new macro variable, it places that variable in “the closest non-empty symbol […]

Post a Comment

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

Post a Comment

Keep your hands off of my SAS data sets

I am all about sharing.  Knock on my door and I will gladly lend you a stick of margarine, a cup of sugar, an egg or two, some flour, a corkscrew, or a beer.  Not a problem to borrow a tie, one of my extra belts, a white shirt (if […]

Post a Comment

What to do when all your boss wants is a spreadsheet

Most SAS programmers have been here. Someone just wants a handful of numbers that they can add to a graph or power point presentation that is due tomorrow. You have the data files, you have a job to summarize it, and you have a dilemma. How do I get my […]

Post a Comment

SAS author’s tip: Bayesian analysis of item response theory models

This SAS tip comes from Clement A. Stone and Xiaowen Zhu, authors of Bayesian Analysis of Item Response Theory Models using SAS. Item response theory (IRT) models are the models of choice for analyzing item responses from assessments in the educational, psychological, health, social, and behavioral sciences. SAS PROC MCMC […]

Post a Comment

Raiders of the lost spreadsheet

Have you ever peered intently into an unfamiliar data delivery directory, realized what was in it, rolled over onto your side, stared blankly into the distance, and dejectedly uttered something akin to: "Spreadsheets! Why did it have to be spreadsheets?" If so, then we are definitely on the same page. […]

Post a Comment

I Know What You Did Last Summer!

I know what you did last summer. If it was unintentional, then you probably don't know what I am talking about.  If it was intentional, then you probably thought that I would never find out.  Either way, the damage is done.  The actions that you took on that warm summer […]

Post a Comment

The lowdown on the downloads

I would bet that the most popular four-letter-word in the English language; the one that gets the most attention; the one that everybody loves to see; the one that makes people the happiest is: free. Everybody likes to get something for free. We love it when we purchase two garments […]

Post a Comment

SAS author's tip: Identifying FIRST.row and LAST.row in by-groups

A popular DATA step programming technique frequently used by SAS users is the ability to identify the beginning and ending observation in by-groups. The way it works is whenever a BY statement is specified with a SET statement, two temporary variables are created in the Program Data Vector (PDV), FIRST.variable […]

Post a Comment

Stay curious! Benefit yourself and your organization

Recently one of our most popular authors, Michael Raithel, a Senior Systems Analyst for Westat, presented a SAS Talks and was interviewed for an AllAnalytics radio show.  Michael is the author of more than 25 SAS technical papers, four SAS Press books, and a popular lecturer at SAS Global Forum […]

Post a Comment