Ok, so you know how to create multiple sheets in Excel, but can anyone tell me how to control the name of the sheets when they are all created at once? In the ODS destination for Excel, the suboption SHEET_INTERVAL is set to TABLE by default. So what does that
I recently asked a SAS user, “Which interface do you use for SAS?” She replied, “Interface? I just install SAS and use it.” “You’re using the SAS windowing environment,” I explained, but she had no idea what I was talking about. This person is an extremely sophisticated SAS user who
There's an old song that starts out, "You Can Get Anything You Want at Alice's Restaurant." Well, maybe you are too young to know that song, but if you’re a SAS users, you’ll be glad to know that you can capture anything produced by any SAS procedure (even if the
This post is from SAS Author Sanjay Matange. It's part of our SAS Author Tips series. Do you have a complex multi-cell graph created in ODS Graphics Designer that you’d like to reuse with different data? Ideally, you’d like to change the data without having to change the plots in each cell. The
Editor's note: This series of blogs addresses the questions we are most frequently asked at SAS Press! It worth spending some time on this. Arguably, this is one of the most important parts of the book. The table of contents and outline provide the blue print of your book –
Editor's note: This series of blogs addresses the questions we are most frequently asked at SAS Press! In our last post about how to write a good outline, we discussed the importance of developing an outline for your proposed SAS Press book and gave some tips on how to do
Whether your resolution is to get SAS certified or to become a more advanced SAS programmer, we’ve got you covered with these new titles and upcoming SAS Press books, many of which will be making their bookshelf debut at SAS® Global Forum 2017 in Orlando, FL! Want to be notified when a new book
How many of you have been given a SAS data set with variables such as Age, Height, and Weight and some or all of them were stored as character values instead of numeric? Probably EVERYONE! Yes, we all know how to do the old "swap and drop" (rename and convert), but
SAS temporary arrays are an underutilized jewel in the SAS toolbox. I find that many beginning to intermediate SAS programmers are not familiar with temporary arrays. The good news is that there is nothing complicated about them and they are very useful. First of all, what is a temporary array?
Editor's note: This series of blogs addresses the questions we are most frequently asked at SAS Press! Do you have a great book idea already in mind, or think you might want to write about an analytics or industry topic? Consider writing a SAS Press book or a SAS &
As technology expands, we have a similarly increasing need to create programs that can be handed off – to clients, to regulatory agencies, to parent companies, or to other projects – and handed off with little or no modification needed by the recipient. Minimizing modification by the recipient often requires
Editor's note: This series of blogs addresses the questions we are most frequently asked at SAS Press! Ever thought about writing your own SAS or JMP book? Here are a few reasons why writing a SAS Press book can be a fantastic career move! 1. Your book establishes you as
Jared Cohen, President of Jigsaw, formerly Google Ideas, and Chief Advisor to Alphabet Executive Chairman (former Google CEO) Eric Schmidt, presented a very interesting keynote at Analytics Experience this month. In it he mentioned the idea of a ‘digital self’. He explained most people have not one but numerous digital
SAS Programming Professionals, SAS & bugs & rock & roll? But, of course! SAS Because of its amazing versatility, SAS is indisputably the greatest software package currently in use anywhere within the Milky Way Galaxy. Can SAS input every type of flat file imaginable? Yes! Can SAS read and write
Data science may be a difficult term to define, but data scientists are definitely in great demand! Wayne Thompson, Senior Product Manager at SAS, defines data science as a broad field that entails applying domain knowledge and machine learning to extract insights from complex and often dark data. To further
It’s back to school time again. If you’re working to get your lesson plans in place, we have something that might help you and your students - Exercises and Projects for The Little SAS Book. This book is perfect for instructors and students in a classroom setting, especially when used
In the spirit of our “40 and forward” theme to celebrate 40 years of SAS, this blog focuses on David Dickey, an accomplished SAS user since 1974 and a SAS instructor since 1981. He actually co-wrote the original Time Series SAS course in 1981, and helped with the most recent
SAS Author Derek Morgan is a programming rock star… in more ways than one. Not only has he been a professional SAS programmer in the pharmaceutical industry for almost 30 years and written two editions of The Essential Guide to SAS® Dates and Times, Derek also plays electric bass in
The one thing, above all others, that I wish PROC REPORT could do is know which observations from my data set that I want kept together on a single page of non-Listing output. This is problematic for two reasons. 1. PROC REPORT cannot read my mind! 2. PROC REPORT does
Have you been kicking around ideas for a great SAS book, but don’t know how to get started? Don’t wait another day – connect with the Publish with SAS community and let those amazing folks at SAS Press help you get your project rolling. You won’t regret it! I’m SO
As the excitement of SAS Global Forum begins to die down and we dust off our sequins for another year, it’s time to get back behind the desk. This year at SAS Global Forum we hosted a "Top Tips from Your Favorite SAS Press Authors" lunch where we asked three or four
At SAS Global Forum in Las Vegas I was asked the question, “What does PROC REPORT do?” It is a simple question, but I hesitated to answer. I’m normally so deep inside the nitty gritty details of PROC REPORT that I don’t often think about what it would be like
When you’re making a report, how do you choose which procedure to use? The answer is – it depends. It depends on: whether you are doing an ad hoc analysis or creating a final report that many people will see whether you will run statistical tests with your data or
Did you know one of the attendees' favorite events at SAS Global Forum is to meet our bestselling authors? This year at SAS Global Forum 2016 we are planning a "Top Tips from Your Favorite SAS Press Authors" lunch where we will ask 3 or 4 authors to present a top tip
In my SAS Press book Business Statistics Made Easy in SAS® I place a strong focus on the skill of extrapolating analytics/statistical outcomes to key business implications (similar techniques can be used to link statistics to other key societal outcomes). Unfortunately, business analytics often stops short of defining the impact
In “Explaining statistical methods to the terrified & disinterested: A focus on metaphors”, I discuss the usefulness of metaphors for explaining abstract statistical concepts to non-technical readers. This is an approach taken in my new SAS Press book, Business Statistics Made Easy in SAS®, since many readers of this level
In a previous blog I suggested that many readers in many applied areas are reading statistics texts under duress for a course or project, and are in truth somewhere between disinterested and terrified. In my new SAS Press book Business Statistics Made Easy in SAS® I make use of various
What do you think is the most important new feature in SAS/STAT? Well it depends! In this video, SAS developers talk about their new work and which customers will be excited about it and why. Healthcare professionals may lean toward the new rare events control charts in QC, which allows
Whether your New Year’s resolution is to get SAS certified or to become a more advanced SAS programmer, we’ve got you covered with these upcoming SAS Press books, many of which will be making their bookshelf debut at SAS® Global Forum 2016 in fabulous Las Vegas! The SAS® Programmer’s PROC
Continuing your education can be daunting. Just thinking about all of that time that could be spent relaxing and you have to carve out two hours to study…really! Trust me when I say, I feel your pain. BUT, you will reap the rewards ten-fold, I promise. Check out these top
