Showing posts from September, 2009
What do you do when standing in line at Starbucks? ... why check your clinical data against CDISC standards :)

CDISC Verification on iPhone

CDISC guidelines helps clinical data comply to a standard intended for submission to the FDA so it is important to ensure that you comply with all the guidelines. If you were to review the CDISC guidelines , you will see hundred of pages of rules which your data must comply with. To do this review manually would be time consuming and most likely lead to errors due to not being able to catching the details. The part that I find challenging about reviewing data against CDISC has to do it multiple times as data is being developed. There are times when I need to review the latest update and I am not at my desk. I have found a solution for this when I am out and about, I can review the latest data on my iPhone. This allows me to see how standardize my data is and I see the status of my CDISC effort at any moment even standing in line at Starbucks. :) I capture a YouTube video as to how this is done which you can see below.
Performing stability analysis according to FDA guidelines on an iPhone? Sounds like an odd combination but it works.

Performing Stability Analysis on iPhone

I was finishing up performing an analysis for a client developing a SAS macro to perform stability analysis. There are some good guidelines for this since the FDA has clearly defined how this is done. I found the article on the FDA website entitled " International Conference on Harmonization (ICH) - Guidance for Industry: Q1E Evaluation of Stability Data " to be very useful. Once I was able to get a SAS macro to perform this task, the next challenge is to have this available on an iPhone so the user can access the latest analysis anywhere on their iPhone. Rather than going into a verbose description here, I recorded a video to illustrate this to you. I find that the iPhone which is a multi-touch graphical user interface can be best explained by showing so hope you find this video useful.
How do you use Social Networking? Here are interesting factoids on how uses of these technologies based on numbers.
2009 Annual Conference Proceedings for WUSS09 are now available at:
meeting with volenteers for VNHELP charity concert and LA last week was sold out and Santa Clara tickets almost out.
Building a data warehouse for Congress Bailout with SAS? The outliers on this analysis should be intriguing.
Does some one at Apple review every App sent to AppStore? My first time experience...

Does some one at Apple review every App sent to AppStore?

I recently submitted an iPhone application to the apple developer program to be approved. This was my first time so the hoops that Apple had me jump through were interesting. The initial application had general information which seems pretty normal. These included things such as: Application Name: BI Flash Application Description: BI Flash delivers business intelligence to information to the iPhone. It takes SAS macros, programs or data on a server and delivers this to iPhone. The user can register the programs or SAS libraries, and then make this available to specified users who can then view this through BI Flash on the iPhone. This is executed in real time so the user gets always the latest data. Primary Category: Business Keywords: Business Intelligence, SAS, Analytics Application URL: These seem pretty standard since they would probably use this for the AppStore. The next step is pretty interesting since it asked for me to check three categories i
Just moved to our new office. I was able to retain the last four digit of our phone number :) The new contact:
How do I connect my iPhone to a SAS server? A four step description explains the process.
How do you go about validating data transformed from legacy to CDISC SDTM and ADaM? Here are some recommended steps.

Validating Transformation to CDISC SDTM and ADaM

You have just finished transforming your data from your operational clinical database into SDTM and ADaM, now how do you go about validating this? In general you want to have a method that reviews both the structure according to the guidelines and the values of the data to ensure that nothing is changed from what was collected. The following steps uses SAS tools to validate and ensure the integrity of your final CDISC data. Transformation Model Validation- A transformation model documenting the source data and how it was transformed confirming the destination and source variables. Data Value Subset Review - An automated report printing out a subset of the data before and after the transformation is reviewed and validated.  This may catch truncation.   Categorical Aggregate Review - An automated summary report is generated summarizing the frequency counts of categorical variables verifying the counts are the same.  This catches missi
Can compact digital camera and one person replace network news? I experimented video blogging at a conference to see.

Video Interviews at WUSS 09 Conference

New media has made it possible for a non professional like me to become a reporter. I did an experiment at a recent conference in San Jose. I took my Canon Elph which is normally used for taking pictures and switch on its video mode. It is so small that members that I interviewed barely noticed it was there. I then talked to the attendees at the conference in their area of expertise similar to what I use to do in the traditional blogging days where I would write up the blog based on the interview. The difference this time is upon completion of the interview, I would upload the videos directly to YouTube and whoa.. la... there it was. I did not edit it or do anything. I realize that while holding the camera on my hand, it was not on a tripod so it was perhaps not stable and I was looking at the person I was talking to so the composition was not optimal but this adds to the whole amateur video blogging experience. This experiment of one man on the fly reporting was interesting. I
SAS delivered as a SAAS. Perhaps SAS can just add another "A" to their name when on the web. :)
Can SAS Macros run on an iPhone? This video shows how it can be done with parameter selection on the iPhone.
Claire Castell shares the history of WUSS and how it got its name. An interview at WUSS09 in San Jose
Lora Delwiche author of Little SAS book shares Debugging Techniques at WUSS09
Marci Russell, Web Project Manager of SAS Institute talks about Online Support at WUSS09 conference
Art Carpenter talks about SAS Macros at WUSS09 and his fifth book in San Jose. I interviewed him in training room:
Michael Raithel delivers keynote address at WUSS09 in San Jose. Video clip available here:
Vincent DelGobbo talks about how BASE SAS can export data to MS Excel in XML format. Interview at WUSS09
Attending WUSS09 in San Jose. Experimenting with video interview with my friend Heather Brown.