Jedi SAS Tricks: FUNC(y) Formats

Mark Jordan
Mark Jordan|May 10, 2012

In the previous episode, we built our own custom SAS function – a masterful trick indeed. Gordon Keener, a developer here at SAS, responded exuberantly “You think that’s cool? – try THIS!” and proceeded to demonstrate prodigious powers with the SAS by using a custom function in a custom informat [...]

Post a Comment

Jedi SAS Tricks – Roll Your Own Function

Mark Jordan
Mark Jordan|May 3, 2012

A SAS user (who lives in the the US) emailed me a question about SAS functions. He was reading UTC (Coordinated Universal Time) datetime values from server logs, and to make future calculations and comparisons easier, he wanted to transform the value to local datetime.  The INTNX() function worked great, but [...]

Post a Comment

Syntactic sugar - 6 SAS essentials

Charu Shankar
Charu Shankar|April 12, 2012

The 25 boys I teach on Sundays loved these cupcakes I baked for them for Easter… the sugared peeps had them completely satisfied. I love my tea or coffee laced with sugar. I think you‘d all agree that it is always more pleasant to meet a nice customer service person [...]

Post a Comment

Jedi SAS Tricks: These aren't the droids... Episode 1

Mark Jordan
Mark Jordan|January 13, 2012

How the power of the Force makes ridding yourself of problematic characters so much easier! I recently was invited to become an alternate instructor for Ron Cody’s SAS Business Knowledge Series class, “SAS Functions by Example”, and had the privilege of taking the class as a student under Ron’s tutelage. [...]

Post a Comment

Calculated values in PROC REPORT Compute Blocks

Linda Jolley
Linda Jolley|January 9, 2012

Dear Miss SAS Answers, In PROC REPORT can I use one calculated (computed) variable in the calculation of another computed variable? In the example below, I’m trying to use the value of the Bonus column to calculate the Total column:   compute Bonus;     Bonus =sal.sum*0.05;   endcomp;   compute Total;     total=sum(sal.sum, Bonus.sum);   endcomp; [...]

Post a Comment

Jedi SAS Tricks: Building a Name Suffix variable list

Mark Jordan
Mark Jordan|November 18, 2011

If you’ve taken one of my SAS classes you may recall “Mark’s 3 rules of programming”, the first of which is “Lazy programmers are GOOD programmers.”  One of the things I love about best about SAS programming is the plethora of functions and shortcuts built into the language, all designed [...]

Post a Comment

A man called Bloom and my take on him

Charu Shankar
Charu Shankar|September 28, 2011

Wondering about Bloom and what he has to do with SAS programming.  For any learner, he is someone to respect. For anyone wishing to learn more about the levels of the learning process, this is the master. Bloom classified cognitive, a big word for thinking skills, into 6 broad categories. [...]

Post a Comment

Dear Miss SAS Answers: Help me see my ODS output

Linda Jolley
Linda Jolley|July 8, 2011

Dear Miss SAS Answers, I have a problem getting PDF, HTML, and RTF output from the Output Delivery System (ODS). It asks me to connect to a remote browser. When I try that, I have a connection failure. I am using Base SAS 9.2 software. What am I doing wrong? [...]

Post a Comment

Is something missing or is it a ZERO?

Charu Shankar
Charu Shankar|June 21, 2011

As far as numbers go, the number zero is rather mysterious for data. Is it something or is it nothing? What happens when you have missing data but enter 0? This topic triggered an intriguing discussion in my recent Programming 2: Data Manipulation Techniques class. In this post I’d like [...]

Post a Comment

Sometimes It's the Journey, Not the Destination

Mark Stevens
Mark Stevens|February 22, 2011

Recently, I read Dr. AnnMaria De Mars’ blog post "Translating Ruby to SAS (or vice versa)." I found that I really liked it, and not just because she mentions me (although that was pretty cool). But rather, I like the end of the post, where she identifies a key value [...]

Post a Comment