Tag: SAS

WUSS and My 7 Minutes and 39 Seconds of Fame

I have just returned from another great Western Users of SAS Software conference.  Normally at this point I would write a summary of the conference, but this year I don’t have to.   Instead, you can hear my summary in this interview by Sy Truong of Meta-Xceed, Inc. To hear all of Sy’s interviews at […]

NOTE: More Enterprise Guide Musings

Earlier in the year I offered some reflections on Enterprise Guide, having had the benefit of spending some solid time with it as a user. There are a few more things worth mentioning…

Enterprise Guide is usually introduced as a tool that e…

NOTE: Blog Roll Additions

I’ve added a couple of Australasian blogs to this site’s blog roll (look at the very end of the home page to find the blog roll and a list of recommended web sites).
At http://blog.saasinct.com/, Shane Gibson has been writing about SAS-related thi…

NOTE: Registration for SAS Global Forum 2011 is OPEN

Registration for SAS Global Forum 2011 opens today – November 8th.

The 2011 SAS Global Forum (SGF) will be in Las Vegas, USA, from April 4th to 7th. SGF is the SAS professionals event of the year. Packed with papers from SAS staff and fellow professio…

Recursion: Biblical Evidences

                    
             To Iterate is Human, to Recurse, Divine. 
      –by L. Peter Deutsch, creator of Ghostscript. (I also love his saying “The best thing about a Boolean is even if you are wrong, you are only off by a bit”)

I learned this quote from Tony Barr, designer and developer of SAS (the Statistical […]

SAS EG: Filtering a dataset via prompt manager variable

Nobody who reads this blog is likely a SAS programmer. However, on the off chance this would be useful to someone who finds it via Google, I wanted to post. Currently, I am working on a project in SAS Enterprise Guide where I needed to allow the user to provide variable value(s) via prompt manager […]

Power of Logic Operators: a trick

Suppose you should group people based on their ages as follows:

ID
Age
agegrp

001
1
1

002
4
2

003
5
2

004
5
2

005
2
1

006
4
2

007
5
2

008
2
1

009
9
3

010
8
3

and the rules:
age<4,           group 1
4<=age<6,     group 2
6<=age<10,  group 3
It is a very simple question and you could use the if/else statement without thinking:
data age;
input ID $ age;
datalines;
001 1
002 4
003 5
004 5
005 2
006 4
007 5
008 2
009 9
010 8
;
data age1;
set age;
if age<4   then agegrp=1;
else if […]

SAS multiple character and varying length Delimiters

I’ve solved a problem I had in my previous post “Strip Characters From Between Two Delimiters”.  At work I was given a strangely formatted data file – example.
I needed to separate out the data chunks to work with it.  While my first solution…