Monday, November 30, 2009

How does independent SAS compete with Big Blue as IBM tries to take customers in analytics software?

Wednesday, November 25, 2009

In two weeks, over $1.5K, over 100 teddy bears from New York, San Jose going to Saigon :) Happy Thanksgiving.

Sunday, November 22, 2009

SAS leadership is important in the Asian Pacific region. It is good to see some recent development from SAS.

Saturday, November 21, 2009

We just received over $1K now for the orphans. This will go a long ways with the US dollar relative to VN. :)

Friday, November 20, 2009

Invited to present running SAS macros on iPhone at HASUG in New London, CT in Feb 2010. What is fun to do in CT?

Thursday, November 19, 2009

For the best company that everyone never knows about, award for Leader in BI industry is well deserved.
Participating on a panel discussing CDISC DEFINE.XML in SSF today. How more geeky can that be? :)

Wednesday, November 18, 2009

Just placed an order for DELL Adamo advertised as being available before Christmas. My delivery date with overnight shipping is 12/30 hmm...

Tuesday, November 17, 2009

Will SAS integration with other analytic databases such as Teradata, IBM and AsterData be done through SAS/Access?

Saturday, November 14, 2009

It is a great start with $670 raised for the orphans. It is good to see such kindness and generosity...

Friday, November 13, 2009

How do you make the mundane, boring and time consuming task such as creating CDISC SDTM SUPPQUAL fun? do it on iPhone

CDISC SDTM Suppqual Domain on iPhone

I was working on a project requiring the creation of many SUPPQUAL data which are supplemental qualifiers data domains within the CDISC data model. The majority of this effort is to identify the SUPPQUAL variables and its related identification variables. You would then need to transpose the source data into the vertical structure for this special purpose domain data structure as specified in SDTM. This does not require a rocket scientist, so I have created an interface on the iPhone where you can create this SUPPQUAL data and then get a preview of the resulting dataset.

The video I have recorded below will illustrate how this can be done with relatively little effort.

Tuesday, November 10, 2009

Latest CDISC DEFINE.XML style is generated from an iPhone App. Style over Substance... :)

DEFINE.XML Style Sheet on iPhone

"A style does not go out of style as long as it adapts itself to its period. When there is an incompatibility between the style and a certain state of mind, it is never the style that triumphs."
Coco Chanel

I was working on updating the style sheet of the DEFINE.XML and incorporated this update to the iPhone BI Flash version as well. This means that DEFINE.XML can be generated as before but not it has the option to have the style sheet that contains the colors that was chosen by the CDISC SDS team. This video illustrates how the DEFINE.XML with this style can be generated.

Friday, November 6, 2009

SAS programming on an iPhone? I refer to this as the Web 3.0 of SAS programming.

Web 3.0 of SAS Programming

SAS programming has changed and adapted to the fast changing computing environments. When I first started programming SAS years ago, I had used editors such as VI on Unix and TPU on VMS among a myriad of editors the PC. I refer to this form of developing and editing using these editors as version 1.0 of SAS programming. SAS’s strengths lies in its analytical tools used for exploring and analyzing data. To take advantage of these tools, I then started to use SAS display manger interactively and then Enterprise Guide as a way of developing SAS programs. These tools provided more data exploration capabilities so I am referring to this as version 2.0 of SAS programming. I see that we are about to enter a new era in SAS programming that can be accomplished anywhere with mobile computing which will be known as version 3.0 of SAS programming. In this case, you can be anywhere away from your office yet still having the ability to edit your SAS programs, submit it and review its output. I will describe the steps that I took to accomplish this.

Step 1 – Grant Permissions
The first step is to get access your SAS programs on a mobile device like an iPhone. The assignment of permissions to the SAS programs is applied on the SAS application server where the SAS programs and data reside. This can also be accomplished through a web browser as shown here.

Step 2 – Open and Edit Program
Now that permissions have been granted, I then access the SAS program directly on the iPhone. I first select the library in which the program is stored at:

Once I selected a specific program, I then tap on the “Edit” button to edit the program with an editor not too much different than how I edit emails on my iPhone.

Once the edits are complete, I then submit or run the program by tapping on the “run” button.

Step 3 – Review Edit History
Each time I edit or submit a program using this method, it will automatically create a copy of the current version. This also records my user name and the time in which I performed this edit for a complete audit trail for better change management. The history of the changes are therefore available through reports which I can also generate directly from my iPhone.

By running one of these reports, I can review the history of all the edits that anyone in my team has applied and have the ability to roll back on the server to an older version if that is required.

Editing SAS Programs 3.0 Summary
This process illustrates how a SAS program can be edited through a mobile device such as an iPhone and then submitted with complete version control. This does not mean that I no longer have the ability to edit your SAS program in EG or use your favorite text editor. This is an added tool which complements my existing set of tools and methods I use so now I can gain greater flexibility having the option to perform powerful SAS analytics anywhere with an iPhone.

Thursday, November 5, 2009

Are we going to see SAS referenced in movies as protagonist use analytics to safe the day?