Beyond the Basics: Using SAS With …. Track

Taking XML's Measure: Using SAS to Read In and Create XML for Analytic Use and Websites

Louise Hadden

XML has become a standard over the years for populating websites and transferring information. This presentation demonstrates how to parse mystery XML files, read in XML files that you can’t right-click on, read into Microsoft Excel using SAS®, how to use maps and schemas to input and output various XML representations, and how to construct and output “measure code” data sets from input data to maximize the flexibility of XML data representation and usage.

Text analysis accuracy and ease in SAS Text Miner vs. Python's NLTK package

Jacob Braswell

With machine learning conquering many facets of data analysis, jobs that used to be time consuming are now streamlined into simple tasks. One aspect is text analytics. With many companies receiving thousands of open response complaints daily, text analytics helps companies know exactly what their customers need and how to best address those needs without having to spend hours reading through each individual response. At BYU Institutional Planning and Assessment we are constantly collecting data about our students’ experiences here at BYU, much of this data is free form text responses. With text analytics we are able to cut down the time spent analyzing this data by more than half and still have the same accuracy as we would analyzing it by reading and coding it non mechanically.

In this paper we discuss the process of using text analytics to code through and analyze open response survey data in both SAS Text Miner and Python and compare the two methods in regards to accuracy and user friendliness. We will also discuss the other applications and benefits of using Text analytics at institutions where they need to access large amounts of information stored in the form of qualitative data both effectively and efficiently.

Is Really No PR Bad PR? Debunking the Myth

Imran Selim and Devanand Chintoju

Communication in product promotion is no longer one way. Now, customers, or even non-customers can express their opinion about any ad through social media. Recently, some advertisements have faced public backlash in social media. For example, Dove ran a commercial where a black woman turns into a white woman or Gap Inc. had a commercial where a black child wore a sweatshirt that said ‘Coolest Monkey in the Jungle’. For Dove, this was not the first time they were accused of airing controversial ads. The “Dove Visible Care” ad of 2011 was also accused of being racist. Is it intentional? Does it conform to the myth that ‘No PR is bad PR’?

In this paper, we examined a number of controversial ads from 2017 and analyzed public sentiment for those ads expressed in YouTube comments posted during the quarter when the ad was first published or the event took place to see if there was a correlation between negative public sentiment and a company’s performance during the same time-period. A firm’s performance was measured by quarterly reported revenue and closing stock prices for the firm accused of the controversial ad.

A sentiment analysis was conducted to identify the sentiment from YouTube comments. A web scrapper was built using Selenium package for Python and approximately 1,000 comments from each post was scrapped in CSV format.

For this study, ads from three different companies (Pepsi, Dove, and Adidas) and a highly publicized incident (United Airlines) were examined using SAS® Viya.

Stay Connected to Work Away from Work: A Simple Approach to Send Emails from SAS�® using VBScript

Nikita Sathish

Clinical trial monitoring requires that SAS® programmers periodically generate statistical analysis reports and distribute the reports to cross-functional teams for review.  Most reports are distributed via email or an enterprise content management system.  Manual generation of email, however, can introduce errors.  For example, recipients can be omitted, formatting errors can occur, and reports may not be sent in a timely manner. SAS programmers can avoid these limitations by sending reports directly from SAS to large, customized, email distribution lists.

SAS programmers can further improve report distribution by combining SAS with VBScript.  VBScript allows programmers to overcome security concerns associated with SAS, by not having to store login credentials or tweak the configuration file.  We recommend that programmers send emails from SMTP server through SAS using VBScript.  This approach allows programmers to send emails with attachments, pass through SAS macro variables to VBScript, and build dynamic email contents.  In this paper, we detail this simple approach and present ways to send emails using PC SAS and SAS server.

Automating SAS Job Streams with the Power of VB Script

Lindsey Whiting and Joey Kaiser

When making important business decisions it is crucial to have the ability to manipulate and analyze large amounts of data. With the amount of data available to us in the world today, automating SAS jobs has become a necessity to provide efficient and critical business improvements. A great strategy to automate SAS jobs and give the ability for custom error checking is to leverage VB Scripting with your SAS code. This paper will discuss job stream automation and utilizing SAS to check files’ statuses, notify users of program errors and automatically send out the results of your code.