SAS author Jane Eslinger shows give you tips for working with PROC TEMPLATE when diving into the Output Delivery System (ODS) world. Learn how to create a custom style template to get the stylized output you want.
SAS Viya is our latest extension of the SAS Platform and interoperable with SAS® 9.4. Designed to enable analytics to the enterprise, it seamlessly scales for data of any size, type, speed and complexity. It was also a star at this year’s SAS Global Forum 2018. In this series of articles, we will review several of the most interesting SAS Viya talks from the event. Our first installment reviews Hadley Christoffels’ talk, A Need For Speed: Loading Data via the Cloud.
Technology that gets the most from the Cloud
Few would argue about the value the effective use of data can bring an organization. Advancements in analytics, particularly in areas like artificial intelligence and machine learning, allow organizations to analyze more complex data and deliver faster, more accurate results.
However, in his SAS Global Forum 2018 paper, A Need For Speed: Loading Data via the Cloud, Hadley Christoffels, CEO of Boemska, reminded the audience that 80% of an analyst’s time is still spent on the data. Getting insight from your data is where the magic happens, but the real value of powerful analytical methods like artificial intelligence and machine learning can only be realized when “you shorten the load cycle the quicker you get to value.”
Data Management is critical and still the most common area of investment in analytical software, making data management a primary responsibility of today’s data scientist. “Before you can get to any value the data has to be collected, has to be transformed, has to be enriched, has to be cleansed and has to be loaded before it can be consumed.”
Benefits of cloud adoption
The cloud can help, to a degree. According to Christoffels, “cloud adoption has become a strategic imperative for enterprises.” The advantages of moving to a cloud architecture are many, but the two greatest are elasticity and scalability.
Elasticity, defined by Christoffels, allows you to dynamically provision or remove virtual machines (VM), while scalability refers to increasing or decreasing capacity within existing infrastructure by scaling vertically, moving the workload to a bigger or smaller VM, or horizontally, by provisioning additional VM’s and distributing the application load between them.
“I can stand up VMs in a matter of seconds, I can add more servers when I need it, I can get a bigger one when I need it and a smaller one when I don’t, but, especially when it comes to horizontal scaling, you need technology that can make the most of it.” Cloud-readiness and multi-threaded processing make SAS® Viya® the perfect tool to take advantage of the benefits of “clouding up.”
SAS® Viya® can addresses complex analytical challenges and speed up data management processes. “If you have software that can only run on a single instance, then scaling horizontally means nothing to you because you can’t make use of that multi-threaded, parallel environment. SAS Viya is one of those technologies,” Christoffels said.
Challenges you need to consider
According to Christoffels, it’s important, when moving your processing to the cloud, that you understand and address existing performance challenges and whether it will meet your business needs in an agile manner. Inefficiencies on-premise are annoying; inefficiencies in the cloud are annoying and costly, since you pay for that resource.
It’s not the best use of the architecture to take what you have on premise and just shift it. “Finding and improving and eliminating inefficiencies is a massive part in cutting down the time data takes to load.”
Boemska, Christoffels’ company, has tools to help businesses find inefficiencies and understand the impact users have on the environment, including:
- Real-time diagnostics looking at CPU Usage, Memory Usage, SAS Workload, etc.
- Insight and comparison provides a historic view in a certain timeframe, essential when trying to optimize and shave off costly time when working in cloud.
- Utilization reports to better understand how the platform is used.
Optimizing inefficiencies with SAS Viya
But scaling vertically and horizontally from cloud-based infrastructure to speed the loading and data management process solves only part of the problem. Christoffels said SAS Viya capabilities completes the picture. SAS Viya offers a number of benefits in a Cloud infrastructure, Christoffels said. Code amendments that make use of the new techniques and benefits now available in SAS Viya, such as the multi-threaded DATA step or CAS Action Sets, can be extremely powerful.
One simple example of the benefits of SAS Viya, Christoffels said, is that with in-memory processing, PROC SORT is a procedure that’s no longer needed; SAS Viya does “grouping on the fly,” meaning you can remove sort routines from existing programs, which of itself, can cut down processing time significantly.
As a SAS Programmer, just the fact that SAS Viya can run multithreaded, the fact that you don’t have to do these sorts, the way it handles grouping on the fly, the fact that multithreaded nature and capability is built into how you deal with tables are all “significant,” according to Christoffels.
Data preparation and load processes have a direct impact on how applications can begin and subsequently complete. Many organizations are using the Cloud platform to speed up the process, but to take full advantage of the infrastructure you have to apply the right software technology. SAS Viya enables the full realization of Cloud benefits through performance improvements, such as the transposing of data and the transformation of data using the DATA step or CAS Action Sets.
For those of you who weren't able to attend SAS Global Forum 2018, you can still learn a lot from the content shared there. Gain knowledge from your SAS family. SAS Global Forum 2018 papers and videos now available.
The post Knowledge from the SAS family: SAS Global Forum 2018 papers and videos now available appeared first on SAS Learning Post.
SAS Global Forum 2018 is just days away, and if you're one of the 6,000 SAS users heading to Denver for the event, get ready for four days of learning from SAS peers, exchanging ideas, discovering new techniques for using SAS, and a bit of fun as well.
But what if you can't make the trip to Denver this year? Is there another way to experience some of the great content that will be shared there? I'm happy to say the answer is yes!
SAS Global Forum 2018 Virtual Event
Once again, SAS will provide dozens of hours of live video streaming from the event. Register for an All-Access Pass and watch select sessions including Opening Session, keynote talks, select breakouts, Tech Talks, updates from The Quad, interviews with SAS executives and developers, and more. You can find livestream presentations and add them to your calendar here. Coverage will be available for on-demand viewing on SAS Global Forum Video Portal after the conference as well.
Get involved via Social Media
Video not your thing? No worries. SAS will provide several other ways to stay up to date. For starters, you can read any of a number of blog posts from the event. Posts will come from many different SAS blogs, but all posts from SAS Global Forum will be aggregated here.
If you're on LinkedIn, Twitter or Facebook, you can stay connected with what's happening and engage with attendees on SAS’ social media channels. Join the conversation, comment on some of the cool presentations you attended or viewed, discuss the exciting news coming out of the event, or simply follow along. The channels sure to have the most activity are the SAS Users LinkedIn group, the SAS Twitter account, the SAS Users Group Facebook page; and Instagram. The hashtag for SAS Global Forum is #SASGF; be sure to use the hashtag in all your posts.
SAS Global Forum 2018 Proceedings
If you want a deeper dive into a particular talk, or if you're interested in presentations that may not be part of the Live Stream, the proceedings for SAS Global Forum 2018 are already available. Here you'll find abstracts, PDF of papers, e-posters, slides, data files, and more.
With all the opportunities to follow along, connect and contribute, you can be a part of SAS Global Forum 2018, whether you're attending in person or not.
Enjoy the event...whether you're going or not!
Participate in SAS Global Forum 2018...even if you're not going was published on SAS Users.
SAS Global Forum 2018 takes place April 8-11 in Denver. The following post is from Sebastian Dziadkowiec and Piotr Czetwertynski, presenters at the event. You can join Sebastian and Piotr for their talk: “An Agile Approach to Building an Omni-Channel Customer Experience” on April 9 at 2 p.m. in Meeting Room 302. We'll also post their presentation here after the event has concluded.
Keys to building a successful and future-proof omni-channel customer experience
Most organizations acknowledge that building a seamless and consistent customer experience is critical to long-term success. The big question is: Now what? With all of the channels to stitch together – from brick and mortar experiences to online clicks – how do you track and make sense of all that customer data? And, more importantly, how do you use that data to create the very best customer experience?
Over many years of implementing SAS Customer Intelligence and helping our clients give their customers exactly what they want and when they want it, our team has identified some characteristics that make for successful projects. Here are some of the key components that most often make or break a Customer Intelligence project.
Time to market
Everyone likes to see value generated quickly and reaching the break-even point for project within weeks of project launch is critical. In case of campaign management, it is possible. Instead of following the traditional waterfall path, with all the IT-heavy components like requirements gathering and analysis, solution design, many streams of implementation and testing, it is worth considering releasing a minimum viable product as soon as possible. Such approach allows us to focus on delivering business value and field-testing all the creative ideas, rather than building an IT system in perfect accordance to requirements, and one that may no longer be relevant at the day of release.
Applying analytics in the decisioning process
Go beyond traditional, rule-based approach to get the most out of the data you have. Nowadays, everyone speaks about machine learning, big data, NBA, artificial intelligence and so on. It is up to each organization and CI project to forge those fancy buzz words into real value, by embedding advanced analytics techniques in the decisioning process. There are many ways to boost various use cases by the advanced methods; make sure you will be able to use all you need and integrate their results seamlessly, regardless of when and how you engage with your customers.
While working on a CI project you should also keep in mind other areas: project organization, building a future-proof solution that will stay relevant for years, and constant search for additional opportunities to use available data and solutions to generate incremental value beyond the core scope of customer intelligence project.
There isn’t a one-size fits all approach to implementing a CI project, but these lessons learned can greatly increase your chances for project success – successful delivery generating a high ROI in a short timeframe while staying relevant in the long run - through the very best possible customer experience.
Find out more at the SAS Global User Forum 2018
Join Sebastian and Piotr for their “An Agile Approach to Building an Omni-Channel Customer Experience” Breakout Session at SAS Global Forum April 9 at 2 p.m. in Meeting Room 302.
About the Authors
Piotr is Customer Analytics Manager in Accenture. He has 11 years of experience in Campaign Management and Analytics. Currently he is one of the people responsible for launching of Accenture Center of Excellence for SAS CI in Warsaw, Poland.
Piotr recently focuses on solutioning & strategy in the areas of campaign management, BI & Analytics.
Sebastian has 8 years of experience in technology and management consulting, mostly in communications industry. He went through the entire project lifecycle on numerous engagements, starting from programmer, through business and technical analyst, up to solution architect and team manager on large-scale analytics projects.
Sebastian specializes in analytics solutions technology architecture, particularly focusing on customer intelligence and big data. He serves as technology lead in Accenture Center of Excellence for SAS CI in Warsaw, Poland.
According to Glassdoor, data scientist tops the list of the 50 Best Jobs in America. The rankings are determined by combining three factors: number of job openings, salary and overall job satisfaction rating. With a median base salary of $110,000, an abundance of unfilled positions and high job satisfaction, there’s no denying that data science is hot.
Goutam Chakraborty is a busy man. In addition to serving as SAS professor of marketing analytics at Oklahoma State University, Dr. Chakraborty is the director and founder of the SAS and Oklahoma State University MS in Business Analytics and an award winning author and professor. He teaches courses in such areas as business analytics, marketing analytics, data mining, marketing research, and web strategy, and has been preparing students to enter the workforce with advanced skills in marketing and analytics for more than 20 years. Throw in the regular consulting engagements he has with some of the world's top companies and it makes you wonder if Dr. Chakraborty has time to add anything else to his already full plate. Well, this year at least, you add SAS Global Forum 2018 Chair to the list - likely at the expense of a good night's sleep.
As the largest gathering of SAS users in the world, SAS Global Forum will attract more than 5,000 SAS professionals for several days of learning and networking. Recently, I sat down with Dr. Chakraborty to talk with him a bit about this year's conference, which takes place April 8-11, 2018 in Denver. I left excited about SAS Global Forum 2018 and, at the expense of losing credibility as a fair and balanced reporter, convinced that Dr. Chakraborty is one of the nicest individuals you'll ever meet.
Larry LaRusso: I know you've been preparing to chair SAS Global Forum 2018 for more than three years, but now that the event is only a few weeks away, how excited are you to kick this thing off?
Goutam Chakraborty: More excited than you know Larry. I've participated in many SAS Global Forums, but serving as chair gives you the ability to influence every aspect of the event, from speaker and content selection to charity-related events and networking opportunities. It's been a wonderful opportunity to give back to the SAS user community, one I'll never forget.
LL: What excites you most about this year's event?
GC: There are so many new things about this year's conference, all geared toward providing an enriching experience for all SAS users. I'll mention three that immediately come to mind.
One thing we've tried to do well this year is connect industry with academics. While we'll have a full program of events and talks specifically geared toward students and professors, this year we'll emphasize partnerships with industries in a new way. I might be most excited about Sunday's Talent Connection. This event brings students and SAS professionals together to network, discuss career opportunities and share knowledge, research and partnership opportunities that might exist with each other. I anticipate it being a great success for both students and industry looking to connect with young analytical talent.
Another strong focus for us is career development and learning for SAS users at all levels. We'll have a full menu of traditional training and certification opportunities for data scientists, business and data analysts and SAS programmers, but we're also providing opportunities to build on soft-skills development, such as networking, analytical story-telling and much more. We'll also have an on-site Learning Lab, available for several hours each day, where users can explore more than 25 e-learning courses for free.
Finally, I'll mention our volunteer opportunities. We'll have several ways for users to give back, but I'm particularly excited about our STEM-related charity event. During meals and evening networking receptions, both Monday and Tuesday, attendees will have the opportunity to work with RAFT Colorado (Resource Area For Teaching), and build STEM-inspired teaching kits for local teachers to use in their classrooms. Each kit will repurpose educational items RAFT has collected and make them available to teachers as creative tools for teaching STEM – inspiring the next generation of thinkers, innovators, problem-solvers and creators. It's an extraordinary opportunity to impact local area children.
LL: Speaking of extraordinary, this year's conference theme is "Inspire the Extraordinary." What does that theme mean to you?
GC: It means never accept "good enough." I always tell my students to push for something above and beyond what's expected of them, to be extra-ordinary. We expect the same for this year's SAS Global Forum. Knowing the event like I do, I feel confident we're going to deliver a SAS Global Forum that surprises and delights our users in a way they didn't expect.
LL: We all know that one of the best things about SAS Global Forum is its incredible content. What can you tell us about the content you’re putting together for this year’s event?
GC: Thanks to tons of hard work and research from a lot of SAS users, we've selected fantastic content from renowned speakers from across the world. Perhaps the best part of our content planning this year is the variety. Topics range from deep hard-core programming to high-level strategic thinking about data and analytics. From sessions that will help you to develop yourself personally as a better human-being to learning about optimizing Monday night NFL schedule for best viewership to thinking strategically about data as a currency – there is something of value for everyone.
LL: SAS Global Forum is likely to attract more than 5,000 data scientists, analytics professionals and business leaders. Every year it amazes me how many of those users are attending SAS Global Forum for the first time. What advice would you give first-timers?
GC: First piece of advice: Have a plan and build a personalized agenda so you don’t get overwhelmed by the large number of available sessions. Second, take every opportunity to engage and network with other attendees. One of the best things about this conference is how willing veteran SAS users (regulars at this conference) are to help and welcome newcomers. So, take advantage of it. If you are sitting down for breakfast or lunch, take the time to introduce yourself to people around you. You may be surprised where it could lead. I'd also encourage attendees to take time to visit the Quad. The Quad is a casual and interactive space where attendees can network with other SAS enthusiasts, view demos and visit with experts from SAS and our sponsors. And, last but not the least, have some fun! Attend the social events we have planned, especially the Kick Back Party at Mile High Stadium on Tuesday evening.
LL: As an academician, I know you’re passionate about learning? What additional learning opportunities, beyond the session talks, are available to attendees?
GC: There are so many learning opportunities at SAS Global Forum that it is mind-numbing. Of course, the 20 and 50 minute session talks are the main modes of content delivery, but there are also e-posters, table talks and super demos in the Quad. We'll also have dozens of pre-conference tutorials, post-conference training, and all the activity in the Learning Labs, including hands-on workshops and the ability to take individual e-learning courses.
LL: Given your personal interests, I know one of your goals for this year’s conference is to increase participation in the event for students and professors. Can you tell me a little more about the special events you have planned for this audience?
GC: For starters, SAS Global Forum is completely “free” for students! As long as you are a full-time enrolled student of an accredited, degree-granting academic institution you can attend free of charge. There are credit hour minimums that must be reached to be eligible, so I'd encourage students to visit the website for complete details.
Programmatically, we have the Sunday afternoon sessions entirely dedicated to academics. We have a fantastic academic keynote speaker, Temple Grandin from Colorado State University, and special training sessions for professors interested in teaching analytics at their universities. For students, we offer a number of opportunities to network and special courses, such as how to best use social media for networking while looking for a job, to help them make a successful transition from student to working professional. We also encourage students, and really anyone who has an interest, to attend the presentations students make as winners of the SAS Global Forum Student Symposium Student Symposium. Though closed now, the Symposium provides an opportunity for teams of two to four students and a faculty adviser to showcase their skills and compete with other teams in the application of SAS Analytics in solving a big data problem. This year, more than 60 teams entered; the top eight will present 20-minute talks during the event.
LL: Dr. Chakraborty, I've taken a lot of your time, but is there anything else you'd like to share with our readers?
GC: Actually, I'd like to thank the many volunteers who have helped put this conference together. From serving on our SAS Global Users Group Executive Board to helping evaluate and select talks, to serving in our Presenter Mentor Program, hundreds of users have invested their time to make this conference the best one yet. SAS Global Forum is truly a user's conference and we depend on the user community to plan, promote and execute so many tasks and activities related to the event. Though I can't call them out by name, I would be remiss if I didn't mention their contributions and take a minute to thank them.
LL: Well let's hope they're reading! Dr. Chakraborty, I want to thank you again for your time. I look forward to seeing you in Denver in April.
Continue the conversation: Join our live Tweetchat, Wednesday, March 7, 2018
How are you inspiring the extraordinary?
The next analytics extraordinary use case is just waiting to be discovered. We believe that in the hands of lifelong learners, the future of data is unlimited, especially when education and business join forces. That is why we are warming up to SAS Global Forum 2018 in Denver with a tweetchat on Wednesday 7th March (simply search #SASchat or #SASGF). We kick off at 6pm CET, 5pm UK, noon ET and 9am Pacific. Will you join us? The discussion will kick off with the following questions, posed to our expert panel:
- Why is there more interest in lifelong learning now?
- How does lifelong learning contribute to the analytics economy?
- What are your favorite examples of analytics in the not-for-profit sector?
- How is the education sector influencing the development of citizen data scientists?
- What trends do you see in the consumption of analytics?
A conversation with SAS Global Forum 2018 Chair Goutam Chakraborty was published on SAS Users.
Do a quick search on “data scientist” on any of the popular job boards and there’s no denying the global shortage of data scientists is a real one. And, whether you’re looking for the salary commensurate with the prestigious title, a fast pass to the C-suite, or simply want to [...]
The post SAS Academy for Data Science creates top-rate analytical professionals appeared first on SAS Learning Post.
This April, more than 5,000 SAS users and business leaders will converge on Denver CO for the premier event for SAS professionals: SAS Global Forum 2018. The event provides an excellent forum to expand your SAS knowledge and network with users of all skill levels. (Last year I found myself having lunch one day sandwiched between a consultant who had built a three-decade career around SAS and a graduate student who started using SAS three months earlier. How's that for diversity!)
And because SAS Global Forum attracts users from across the globe; in every industry imaginable; and from countless government and academic institutions, it really is a user event not to be missed. Thanks to the SAS Global Users Group Executive Board there are a couple of award programs in place to help those who might otherwise have a hard time getting to the event... well, get to the event!
New SAS® Professional Award
For relatively new SAS users who want to experience the conference for the first time, there's the New SAS® Professional Award. This award provides full-time SAS professionals with five years or less of SAS experience the opportunity to earn a free conference registration and one free pre-conference tutorial. You are eligible if you have never attended a SAS Global Forum in the past and would not otherwise be able to attend without assistance.
SAS® Global Forum International Professional Award
A similar award, the SAS® Global Forum International Professional Award, provides users outside of the 48 contiguous U.S. states a similar opportunity. To qualify for this award, you must be a full-time SAS professional who has never attended a SAS Global Forum and would not otherwise be able to attend. This award provides free registration, including meals; one free pre-conference tutorial; and an invitation to an awards recognition luncheon on Sunday, April 8.
Both awards are managed by SAS users who will assume leadership roles in future conferences.
MaryAnne DePesquo, the 2019 SAS Global Forum Chair, is in charge of the 2018 International Professional Awards, while Lisa Mendez, SAS Global Forum Chair in 2020, manages the 2018 New SAS Professional Awards. Direct questions about either program to MaryAnne or Lisa.
To be considered for either program, you must submit your application by Jan. 29, 2018. You will be notified if you received an award no later than March 5, 2018.
Hope to see you in Denver!
Interested? Hear more from a couple of last year's award recipients
It’s true. The ODS destination for PowerPoint now has the STARTPAGE= option, which provides you with greater control and flexibility when creating presentations.
Added to the ODS POWERPOINT statement in SAS® 9.4TS1M4, the STARTPAGE= option enables you to force the creation of a new slide between procedures and between ODS layout containers. Inserting a slide break between layout containers is one of the most impactful ways that you can use this option.
A new layout container does not automatically trigger a new slide within the presentation. A new slide is started when the current slide is full. That is the default, but the new STARTPAGE= option gives you the ability to start a new slide between containers even if the current slide is not full.
Shown below are four procedures placed within three layout containers.
- The first PROC ODSTEXT step is placed in the first layout container. Its purpose is to generate a slide of text, with that text roughly centered in the slide.
- The second PROC ODSTEXT step is in the second container. Its purpose is to provide useful information about the table and graph.
- The PROC TABULATE and SGPLOT steps make up the third container. They are the results of the analysis and, as such, need to be displayed side by side.
Default Behavior of ODS POWERPOINT, Without STARTPAGE=
Let’s look at the default behavior. In this example, the STARTPAGE= option is not used.
ods powerpoint file='example1.pptx' options(backgroundimage="saslogo_pptx.png"); title; ods layout gridded x=10% y=25%; proc odstext; p "Have you heard?" /style=[just=c fontsize=42pt color=RoyalBlue]; p "The STARTPAGE= option has been added to the ODS POWERPOINT statement!" /style=[just=c fontsize=24pt]; run; ods layout end; ods layout gridded rows=1 columns=1; ods region; proc odstext; p 'Table Shows Total Runs and Hits for Each League'; p 'The Graph Contains One Bubble for Each Player. The Size of Each Bubble Represents the Magnitude of the RBIs.'; run; ods layout end; ods graphics / width=4.5in height=4in; ods layout gridded columns=2 column_widths=(47% 47%) column_gutter=1pct; ods region; proc tabulate data=sashelp.baseball; class league; var nruns nhits nrbi; tables league='', sum='Totals'*(nruns nhits)*f=comma12.; run; ods region; proc sgplot data=sashelp.baseball; bubble x=nhits y=nruns size=nrbi/ group=league transparency=.3; run; ods layout end; ods powerpoint close;
Here is the resulting slide output:
Those results are not what we hoped they would be. The output from the second PROC ODSTEXT step, which is to provide information about the table and graph, is on the first slide. So is the graph!!! And the graph does not look good because it is the wrong size. The table is by itself on the second slide. This is not the desired output at all.
Here Is Where STARTPAGE= Helps!
In this example, an ODS POWERPOINT statement with the STARTPAGE= option is added. It is placed after the ODS LAYOUT END statement for the first container.
ods powerpoint file='example2.pptx' options(backgroundimage="saslogo_pptx.png"); title; ods layout gridded x=10% y=25%; proc odstext; p "Have you heard?" /style=[just=c fontsize=42pt color=RoyalBlue]; p "The STARTPAGE= option has been added to the ODS POWERPOINT statement!" /style=[just=c fontsize=24pt]; run; ods layout end; ods powerpoint startpage=now; /* <---- Triggers a new slide */ ods layout gridded rows=1 columns=1; ods region; proc odstext; p 'Table Shows Total Runs and Hits for Each League'; p 'The Graph Contains One Bubble for Each Player. The Size of Each Bubble Represents the Magnitude of the RBIs.'; run; ods layout end; ods graphics / width=4.5in height=4in; ods layout gridded columns=2 column_widths=(47% 47%) column_gutter=1pct; ods region; proc tabulate data=sashelp.baseball; class league; var nruns nhits nrbi; tables league='', sum='Totals'*(nruns nhits)*f=comma12.; run; ods region; proc sgplot data=sashelp.baseball; bubble x=nhits y=nruns size=nrbi/ group=league transparency=.3; run; ods layout end; ods powerpoint close;
The STARTPAGE= option gave us exactly what we need. The first slide contains just the text (from the first layout container). The second slide contains more text along with the table and graph (from the second and third layout containers).
Use It Wisely!
The most important thing to know about using the STARTPAGE= option with layout containers is that it has to be placed between containers. It cannot be placed within a container. So you cannot put the statement between the ODS LAYOUT GRIDDED and ODS LAYOUT END statements.
For more information about ODS destination for PowerPoint and all of its options, visit this The Dynamic Duo: ODS Layout and the ODS Destination for PowerPoint. Take a peek at it for more examples of using ODS Layout with the ODS destination for PowerPoint.
The ODS Destination for PowerPoint Has a New Option was published on SAS Users.