I have a love-hate relationship with spreadsheet data. I am interested in finding data to analyze, and if it arrives in the form of a spreadsheet, I'll take it. And I like to deliver results and reports, but often my constituents ask for it as a spreadsheet that they can
Search Results: ODS Excel (302)
Note: as this is a popular topic, I've added a few notes with minor updates, including a link to a popular how-to tutorial video. In case you missed it, the first maintenance release for SAS 9.3 was recently released. Because we're all friends here, you may call it "SAS 9.3M1"
August was a busy month for our SAS Text Analytics team, but I was very pleased to get the invite to attend this year’s CIO 100 Conference hosted by Maryfran Johnson, Editor-in-Chief of CIO Magazine. As Master of Ceremonies, she inspired lively discussions and shared insights on IT leadership, technology
Leonid Batkhan reveals programming technique to build adaptive SAS programs to facilitate transition between various environments for a smoother SDLC.
This blog demonstrates how to create a report that provides only the column headings for data that is missing. The blog also explains how to create, select, and exclude output objects as well as how to generate reports with the SAS® Output Delivery System (ODS). These concepts are relevant to the task of generating a report with the column headings for a data set that contains no (0) observations.
This blog post, inspired by my work on this topic with a SAS customer, focuses on how to create and use locale-specific informats to read in numeric values from a Microsoft Excel file and then transform them into SAS character values. I incorporated this step into a macro that transforms ones and zeroes from the Excel file into meaningful information for multilingual readers.
Learn how to use SAS code (PROC HTTP) to read and write files from your Microsoft OneDrive, Microsoft Teams or SharePoint Online. You'll learn how to create a Microsoft Office 365 app, connect to it with SAS, and automate the integration with your office productivity environment.
In case you missed the news, there is a new edition of The Little SAS Book! Last fall, we completed the sixth edition of our book, and even though it is actually a few pages shorter than the fifth edition, we managed to add many more topics to the book.
Find out about the changes and enhancements to the best-selling book, The Little SAS Book.
I was sitting in a model railroad club meeting when one of our more enthusiastic young members said, "Wouldn't it be cool if we could make a computer simulation, with trains going between stations and all. We could have cars and engines assigned to each train and timetables and…" So,
Have you adopted use of Microsoft Office 365? How has working "in the cloud" affected your integration with SAS applications? SAS product management wants to hear from you.
Do you want to insert blank rows into your TABULATE procedure tables? Here's a SAS sample and two other methods that will get the job done.
In this blog post you'll find out the top 10 bestselling titles at SAS Global Forum 2018.
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.
Summer is here, which means vacations and time at the pool with a good book. If expanding your knowledge is a goal of yours this summer, SAS has a shelf full of new titles becoming available over the next few months. From new editions of classics – such as SAS® for Forecasting
Not everything that happens in Vegas stays in Vegas. At this year’s SAS Global Forum 2016, so many exciting things happened that I have to share some highlights. From the use of analytics in college administration to the teaching of analytics in the classroom, the range of information presented was quite
To kick off his presentation at MWSUG2015, SAS’ Chevell Parker flashed a picture of an old-school phone booth and asked the audience where he could find the nearest one. Met with several seconds of silence, he smiled. “Don’t all answer at once!” The point of his question was obvious: as
Hello, 1992 called. They want their DDE Excel automation back. Perhaps the title of this article is too pessimistic. Of course your SAS programs that use DDE (dynamic data exchange) can still work perfectly, as long as you situate your SAS software and its DDE "partner" (usually Microsoft Excel) to
It’s no secret, everyone is talking about generative AI (GenAI). In 2023, funding shot up five times year over year. According to a McKinsey report, “Generative AI could add the equivalent of $2.6 trillion to $4.4 trillion annually… by comparison, the United Kingdom’s entire GDP in 2021 was $3.1 trillion.”
SAS' Varun Valsaraj demonstrates how to build a digital assistant for a warehouse space optimization use case.
In a first course in numerical analysis, students often encounter a simple iterative method for solving a linear system of equations, known as Jacobi's method (or Jacobi's iterative method). Although Jacobi's method is not used much in practice, it is introduced because it is easy to explain, easy to implement,
Have you ever been curious about your monthly water consumption and how it compares to others in your community? Recently, I had this question and decided to get ahold of my family's water usage data for analysis. Harnessing the power of data visualization, I compared my family of four's monthly
These are a few of my favorite things. —Maria in The Sound of Music For my annual Christmas-themed post, I decided to forgo fractal Christmas trees and animated greeting cards and instead present a compilation of some of my favorite data visualization tips for advanced SAS users. Hopefully, this
Over the last year, generative AI has captivated the public imagination. Many of us have become newly acquainted with the concept of an approaching Singularity coined by John von Neumann or Nick Bostrom’s Paper Clip thought experiment. Fortunately, Microsoft’s office assistant, Clippy, has yet to dutifully transform our planet into
I recently had two incredible opportunities: to visit the White House for a landmark executive order signing and to make remarks at a US Senate AI Insight Forum. The AI Insight Forum was part of a bipartisan Congressional effort to develop guardrails that ensure artificial intelligence is both transformative and
Recently I wrote about numerical analysis problem: the accurate computation of log(1+x) when x is close to 0. A naive computation of log(1+x) loses accuracy if you call the LOG function, which is why the SAS language provides the built-in LOG1PX for this computation. In addition, I showed that you
This summer, SAS Academic Programs recognized four faculty members from across the country for their excellence in teaching data analytics. Awardees of the SAS Distinguished Award and the Emerging Educator Award received plaques at the SAS Summer Educator Conference, where they participated in a panel discussion about their experience teaching
Did you know that you can embed one graph inside another by using PROC SGPLOT in SAS? A typical example is shown to the right. The large graph shows kernel density estimates for the distribution of the Cholesterol variable among male and female patients in a heart study. The small
We’re taught the rainbow has 7 primary colors - red, orange, yellow, green, blue, indigo and violet - and in this occasional series, we’ve discussed the unique set of nutrients and health benefits each of these colors provide. But what about the other colors that exist in nature?
The concept of sustainability has evolved significantly over the past few years. It is no longer just a trendy buzzword but has become an essential element of business models. Major multinational companies such as IKEA, PepsiCo and Amazon lead sustainability transformation by setting ambitious goals and implementing new initiatives. IKEA