|
SAS Data and Stored Process on
BlackBerry
ABSTRACT
In the competitive smart phone environment, RIM BlackBerry® remains the leading smart phone worldwide changing how we use mobile computing. Although both the iPhone and Android have been making the headlines,
BlackBerry is quietly growing in the area of mobile applications with its introduction of App World 2.0 and
BlackBerry OS 5.0. All major websites such as Google, eBay, and Amazon have their services available as an “App” rather than requiring the user to launch a web browser. These
BlackBerry applications add an efficient use of local mobile device resources that enhance the user mobile experience while leveraging traditional client server computing features that are similar to that of a web browser. Models such as
BlackBerry Curve, Tour, Storm, Pearl, and Bold all provide feature sets such as GPS tracking, voice communication, digital video recorder, and multitudes of other functionality that raise the bar beyond web 2.0. SAS® has been an analytical business intelligence powerhouse for many years; yet it is a relative late comer to this mobile computing revolution. This paper demonstrates how a SAS dataset can be viewed on a
BlackBerry. It also takes a sample SAS stored process, or a traditional SAS macro, and its parameters which can be presented through a GUI for user selection on a
BlackBerry. It then will execute the program with the output results displayed on the
BlackBerry for review. Imagine how you can access the most up to date and dynamic business information delivered directly to you - anywhere where there is a cellular signal. At last, business analytics is no longer placed behind walls guarded by legions of power users, but rather it will be unleashed to users on the go!
iPhone
and iPad SAS Reports with Patient Profile
The days of the traditional PCs
are numbered as there is a movement towards mobile computing.
This requires a different way of generating and reviewing
reports for mobile devices such as iPhone and iPad.
This paper will use Patient Profiles as an example to
illustrate techniques on how to optimize the generation of SAS
reports and graphs for mobile devices.
Some of the methods it will cover include:
-
Selecting Report – Navigation and selecting reports by category and data domain classifications
-
Display – Optimize display view of text report and graph reports on varying mobile devices
-
Review – The report and graph may have multiple pages so with details so flip and zoom is useful
-
Data Refresh – The dynamic changes of the source data required refreshing technique for live view
-
Search – Applying searches upon the contents of the reports can get to the data point quickly
-
Sharing – Graphs and reports can be emailed as attachments as a sharing technique
In an environment
where the report can mean life and death for a patient such as in
the example of a patient profile, it becomes essential to have up
to date reports and graphs in real time.
It is also useful to deliver this information to medical
monitors and clinical research associates on mobile devices since
these professional are on the go at clinical hospital sites.
The delivery of patient profile reports to iPhone and iPad
represents the future of SAS reporting.
Validating
and Migrating SAS 9.13 to 9.2
The rapid updates to the SAS software
implemented in a regulated controlled environment within the
Pharmaceutical Industry have created validation challenges.
The users require the functionality of version upgrade such
as those offered in SAS 9.2 but the complexity of computing
environments in a dynamic hardware and software platform makes it
difficult to maintain an optimal validated SAS system.
This paper will share practical methodologies and
techniques used in the validation of an upgrade for SAS 9.1.3 to
version 9.2 including file migrations to a new server.
Some of the areas it will cover include:
- SAS IQ/OQ – SAS 9.2 is bundled with a series of scripts for
performing installation and operational qualifications.
- Performance Qualification – Performance tuning and testing is
not covered by SAS tools.
This paper will illustrate methods and macros on how to
perform this testing.
- Third Party Software – SAS connects to other databases and
analysis tools. The
upgrade of SAS triggers change control that requires
revalidating other related software.
- File Migration – Moving SAS files while maintaining all the
same permissions and related applications requires rigorous
testing.
Maintaining
a validated SAS system is critical in performing analysis of
clinical data in a regulated environment.
The lessons learned based on real world SAS upgrade will be
shared in this paper that will save time and ensure the integrity
of SAS upgrades to 9.2 or any future release.
Analyzing
Social Media Tweets with SAS
The library of congress is archiving all Twitter
messages since the messages posted capture the most unfiltered
and immediate opinion representing the ethos of pop culture.
The information posted on Twitter expresses the most up to date
pulse on a large range of topics and is a powerful research
tool. With several billion messages posted since 2006 along
with constant new posts; this create challenges in finding the
information of your particular interest. This paper
describes techniques on how SAS macros is used to analyze the
messages or tweets that you posted and compares it
with all other posts. It uses PROC CLUSTER along with other
SAS logic to find the best correlation of ideas and topic that are
of similar interest. It then presents this recommended feed
to you. The analysis of SAS goes beyond an individual
ability to manually search since the criteria is constantly
updated with what you post and what you decide to read from the
recommended feed. Similar to how Amazon.com recommends a
book or CD if you buy something, this paper presents a method that
if you express certain interest through your social media tweets;
it will recommend others that are like yours.
|
