How to land a job as a SAS professional
SAS' Charu Shankar shares six tips for landing a job as a SAS user.
Author
Charu ShankarRSS
Technical Training Specialist
Technical Training Specialist
Charu Shankar has been a Technical Training Specialist with SAS since 2007. She started as a programmer, and has taught computer languages, business and English Language skills. At SAS, Charu teaches the SAS language, SQL, SAS Enterprise guide and Business Intelligence. She interviews clients to recommend the right SAS training to help them meet their needs. She is helping build a center for special needs kids in this project. http://www.handicareintl.org/pankaja/pankaja.swf
New at SAS: Psychometric testing
Human behavior is fascinating. We come in so many shapes, sizes and backgrounds. Doesn’t it make sense that any tests we write also accommodate our wonderful differences?
3 things you need to know about SAS Global Forum 2019 from the conference chair
Find out what SAS Global Forum 2019 conference chair MaryAnne DePesquo says about the upcoming conference in Dallas.
What makes a SAS User? Insight and Community: Josh Horstman
During SAS Global Forum 2018, I sat down with four SAS users to get their take on what makes a SAS user. Read through to find valuable tips they shared and up your SAS game. I’m sure you will come away inspired, as you discover some universal commonalities in being a SAS user.
What makes a SAS user? Order, logic and magic: Louise Hadden
During SAS Global Forum 2018, I sat down with four SAS users to get their take on what makes them a SAS user. Read through to find valuable tips they shared and up your SAS game. I’m sure you will come away inspired, as you discover some universal commonalities in being a SAS user.
What makes a SAS user? SAS thinks like me: Dede Schreiber-Gregory
During SAS Global Forum 2018, I sat down with four SAS users to get their take on what makes a SAS user. Read through to find valuable tips they shared and up your SAS game. I’m sure you will come away inspired, as you discover some universal commonalities in being a SAS user.
What makes a SAS user? Introverts find their tribe: Richann Watson
During SAS Global Forum 2018, SAS instructor Charu Shankar sat down with four SAS users to get their take on what makes them a SAS user. Read through to find valuable tips they shared and up your SAS game. I’m sure you will come away inspired, as you discover some universal commonalities in being a SAS user.
Demystifying SAS Certification (Part 3): To the finish
Want to see my newly minted certified professional badge? Scroll down to take a peek. Yes, I managed to successfully complete the Base SAS Programmer certification exam… with, ahem, flying colors I might add. Here are my tips to tackle the Base SAS certification exam: 1. Get clear on the
Demystifying SAS Certification (Part 2): Write it down
Do you know what the #1 fear in North America is? Most people say fear of public speaking or fear of death, but you may just want to consider this new fear upping the charts - the fear of writing a SAS Certification exam! The real test begins before even
Demystifying SAS certification (Part 1): Getting Started
My fear of headstand took me years to overcome. I had to learn to be safe and protect my neck. I had to learn about structurally positioning my limbs in alignment to prevent injury. I had to overcome my mental fear of being upside down which is quite different from
3 freaky ways PROC FREQ can work in your favor
A ghoulish Halloween Boo to all my readers! Hope my costume freaks you out, but even if it doesn't, I’m positive PROC FREQ will in a few amazing ways! Today’s Programming 2: Data Manipulation Techniques class asked about the power of PROC FREQ. Since I stopped to explain some of it's benefits to
Take that SAS option
Elizabeth is courageous. Scoliosis since birth, corrective spinal surgery replaced her spine with steel, tripping on stairs permanently broke her right ankle. Then she decided to come take yoga with me. To help ease back pain & reduce hip stress, I offered options like bent legs not cross. In class
The difference between the Subsetting IF and the IF—THEN—ELSE—IF statement
My river walk last week turned into a spectacular fall show. But if it rains this week in San Antonio, like the weatherman predicts, what will I do? In the coming days, I’ll be presenting at two user groups, one in eastern Canada in Halifax, and the other all the
What comes shipped free with Base SAS 9.4?
Like unexpectedly seeing this beautiful bird in nature, SAS has tons of free goodies you might be surprised to encounter as you explore your software. A user asked me how to find products licensed at their workplace and that's how this informative blog got started. While individual organizations may have
Learn not one, not two, but four languages in SAS
I started young. Since I was 9 years old, I’ve always loved cooking delicious, tasty and healthy food, and feeding friends and family. My aunt still remembers the delicious chocolate soufflé that trembled and shook but would never collapse that I made for them when I was 18! Word spread.
SAS training leads to certification success
Teaching SAS coding is fun. The best part of teaching is hearing success stories from candidates who earn a SAS certification after taking SAS training. Suiru Jiang is an MBA candidate who successfully passed her SAS certification exam. She took my five-day SAS programming fast track course at Goodman School
Top 3 stocking stuffers for coders
Last Christmas I decided to knit a scarf while at a concert in the Bahamas. A little boy and his sister sitting in front of me watched me very intently. Their eyes grew bigger and bigger as the scarf grew longer and longer. Finally the little boy couldn’t take it
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
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
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.
I can see clearly now thanks to this SAS student
With any software program, there are always new tips and tricks to learn, and nobody can know them all. Sometimes I even pick up tips or techniques from my students while they’re learning broader programming tips from me. Like fine wine, instructors only get better with age. Every customer interaction
Help! Why does the WHERE clause choke on the INPUT function?
A student brought in this coding problem after her manager was struggling with this issue for a while. They played guessing games, but to no avail. Here’s what happened when they submitted data step and proc sql code using a WHERE clause with an INPUT function? data aileen; length hcn
Getting things in order with PROC SQL, macro and a SAS function
Order must be the most frequent cry for help in the SAS classroom. “HELP,” said my student in the classroom. “I work with messy health data. My users want to see data in this order.” T1.col1, t1.col2, t1.col3, t1.col4, t2.col5, t1.col6 and list the remaining columns in column position from
Top 10 SAS coding efficiencies
Tried, tested and true -- I’m sure you already practice some, if not all, of these efficient techniques to save resources. I recently shared these 10 techniques with the Wisconsin Illinois SAS users group in Milwaukee. The conference ran smoothly under the incredibly able guidance of Dr. LeRoy Bessler. I’ll
10 presentation tips from a first-timer
Well really, the gumption, you’re probably thinking—sharing tips with seasoned SAS Global Forum participants! I’m excited beyond measure, thrilled and a little nervous to be presenting in San Francisco. Yes, I know I’m a Global Forum first-timer, but with your permission, I’d like to offer some tips that I've found
A database professional’s best friend
To optimize a Structured Query Language (SQL), the database professional must befriend this order and perhaps even embrace it. Who is your best friend? I’m talking about the order in which SQL processes your statements. Simply put, in what order does SQL do your work? (From my previous post you
#1 SAS programming tip for 2012
What tiny looking operator packs a mighty punch with large datasets? Your queries are big. Your reports span multiple columns. To top it all you have to summarize data in multiple ways. Are you tempted to throw in the towel? Do you feel like saying a firm “Can’t be done”
Go home on time with these 5 PROC SQL tips
How can you go home on time? Take a quick tour with these 5 tips that I was able to summarize for my students in the SAS SQL 1: Essentials class yesterday. Since they found it handy and asked if it could become a blog post, I thought I’d share
What's in a name - SQL Join or SET?
Did that set off a trigger for you? It did for my SAS SQL 1: Essentials class, packed with SQL and SAS programmers alike. To clarify matters I pulled up some examples to help get the differences quickly. Set operators and Joins are similar in that they both combine multiple
Do I have to choose between Excel and SAS?
This question came up while helping my presales colleague with a client’s question: “Is Microsoft Excel in direct competition with SAS?” Not really. I like to think of SAS as partnering with Excel. Because of the following Excel benefits and its synergy with SAS. Excel has been around for years.