Posts

Showing posts from August, 2009
Just recorded a video on how you can view a SAS dataset on an iPhone. http://bit.ly/rHJbX
Heading to Fairmont hotel in San Jose for WUSS conference. Trying to stay cool from south bay heat. :) http://bit.ly/168NW7
Preparing to teach CDISC Course and present new SAS iPhone App and conduct workshop at WUSS http://bit.ly/168NW7
SAS Macro Ran with ERRORs on my iPhone. How SAS Logs can Help... http://bit.ly/TlKd0

My SAS Macro Ran with ERRORs on iPhone. The Beauty of SAS Log

Image
SAS macros are script files that execute SAS instructions similar to other SAS programs.  It is commonly used to automate tasks since the macros can perform repeated tasks with parameters that can be selected by the user.  On the iPhone, this can appear as a list screen with selection choices so the macro can be performed on the server from the selected values on the iPhone.  The SAS programmer that loads the macro on the server will configure the macros with different type of parameter selection type including the following examples: On Off Selector These are similar to check boxes where it can be set to on (checked) or off (unchecked).   Short Text and Passwords The single text entry allows users to enter any text value to the entry.  A similar entry type is the password which will mask the entry so that the text is hidden.   Check List This include a check list where the user can select one value from a list of valid values.   Tex
It looks like today is the last day to register for the WUSS conference. I am such a wussie and wait until 11:58 pm :) http://bit.ly/19o18J
Who are artists performing at a benefit concert in September? I started a new blog for this good cause. http://ping.fm/ruIsI
Social Media Revolution? hm.... I just saw this video which purports that we are in the midst of a revolution. http://bit.ly/3XEoXq
What a challenge keeping data standards for the latest CDISC guidelines. These are findings even for standards group. http://bit.ly/19CA3E
How do you view SAS datasets on an iPhone? You chunk it.... http://bit.ly/3ys8iS

How do you view SAS datasets on an iPhone? You chunk it.

Image
Data Overview SAS datasets are stored in libraries on the server similar to how files are stored in folders. Each library is associated with a different folder on the server which contains one or more datasets . You then have the option of selecting the library which contains datasets you wish to view. The screen that lists the available datasets can be accessed through the " Dataset " navigational button at the bottom of your screen. This will list all the available SAS dataset from the specified library. You can then view the contents of the data by selecting on dataset from the list. This is accomplished by tapping anywhere on the row of the displayed dataset name. Selecting Data The main dataset screen displays all datasets that you have access to in the specified library. The list displays a short dataset name followed by the more descriptive dataset label below each dataset . You can select a different library by selecting the library name at the top of the
Our CDISC team is debating between two DEFINE.XML styles: Green or Minimal. Which one do you like? http://bit.ly/dao0C http://bit.ly/xAFfI
How do you have SAS macro parameters display on the iPhone? The iPhone has some unique new GUI controllers. http://bit.ly/12lUcj
Its nice to still get snail mail call for papers for SAS Global Forum in this day and age. :) http://bit.ly/YEpmp
Finalizing DEFINE.XML for CDISC SDS Metadata Team. Almost there. The latest version can be viewed at: http://bit.ly/dao0C
Preparing to teach CDISC class tomorrow in San Jose. Looking forward to CDISC enlightment… :) http://bit.ly/2eXQB
Most Overlooked Variable Length Error for SAS CDISC Data, Why do electronic submissions fail? http://bit.ly/YQ9C3

Most Overlooked Variable Length Error for SAS CDISC Data

Image
The FDA review of an electronic submission requires the merging of submitted data to confirm that the source produces the same aggregate results of the submitted summary analysis. This can only be accomplished if there are clearly defined keys between the datasets and that the keys have standard attributes. A common error that would occur is that the length of the key fields is slightly different. For example, the study identifier (STUDYID) of one set of data is set to length of 7 and another is set to 10. When the two sets are merged, some of the variable values will be truncated leading to errors. An evaluation if key field lengths are crucial in standardizing the key field lengths. CDISC standards are very helpful in getting the variable attributes such as names and labels standardized. It however, does not enforce the standards of lengths leaving it up to you to evaluate and come up with the correct length for each study submitted. The following steps are recommended to standard yo
Caught myself saying "burtdeh" instead of birthday... "what de heo". I am getting a Vietnamese accent. :)
Last couple of days before the end of discounted registration for SAS Class Conference Registration in San Jose for Sept http://bit.ly/5rYBA
The Simplest SAS PROCs Can Verify CDISC Transformations. Three steps towards validation bliss... :) http://bit.ly/GEeD6

The Simplest SAS PROCs Can Verify CDISC Transformations

Image
Clinical data that has been originally captured from case report forms and then transformed into CDISC SDTM format requires rigorous verification and validation. This will ensure that it meets the guidelines data structure and that the clinical data that has been transformed has not been affected during the transformation. I will recommend a series of steps that uses very basic SAS procedures including PROC PRINT, PROC FREQ and PROC MEANS that will assist you in this validation endeavor. Step 1 – Print Sample You can create a PROC PRINT of a subset of just three subjects. This can then be visually reviewed to make sure there are no major changes. Step 2 – Frequency Counts For variables that have a small set of distinct values or otherwise known as categorical data, a PROC FREQ is useful for verify if the summary counts between the source and destination matches. Step 3 – Means Statistics For numeric variables with lots of values or otherwise known as continuous data, a PROC MEANS can v
The final schedule for the new WUSS Section CDISC Methodologies for FDA Submissions has been set. http://bit.ly/motS6
When are CDISC Datasets Useful for ISS? Even CDISC SAS datasets can not be used in integrated safety summary... http://bit.ly/hHUqn

When are CDISC Datasets Useful for ISS?

Image
One important objective in converting to CDISC standards is to then gain the ability to perform an ISS (integrated safety summary) analysis between multiple studies. Once the data is created in a standard format, it makes it easier to merge the data from a pool of studies since they are in the same CDISC structure. Even though the variables names and labels are standardize, the guideline does not strictly specify the length and other detail attributes. In a recent set of studies I was working on, we ran into discrepancies between two studies even though it was converted to CDISC . The following report illustrates this problem. Most of the issues came about due to length differences between the two studies. This can lead to truncation if any of these key fields are merged. Other less common issues are things such as labels being different. This can be due to using different versions of the guidelines such as 3.1.1 versus 3.1.2. I ran a % difftest macro which then revealed some diffe
Just been requested to perform CDISC SDTM transformation for new client Isotechnika. Any thing fun to do in Alberta? :) http://bit.ly/JvMgD
New CDISC Wiki made it to the top on Google search results for "CDISC List". http://bit.ly/2m2DLK
How do I post SAS dataset onto my Facebook Wall? http://bit.ly/G1UrH

Post SAS Data on Facebook Wall

Image
In the age of Google, information is liberated and readily avialable. However, SAS data is often locked behind servers limited to analysts and statisticians. Facebook is the most popuplar social network and is a common way how users share information. I will show you how you can share SAS dataset on Facebook by doing the following steps. View Data - You would view your SAS datasets as before with Syview. Select the view which best represent your data. Post to Facebook - From the data view on Syview , select the menu: Tools > Post to Facebook Note that a thumbnail view will be captured of the current view. Write Something - When posting things on Facebook walls, it is recommended that you write a little short message. This describe to your reader what this is about. View Posting - Log onto Facebook and view the data posted. Note that a thumbnail image of the data view is created along with the message you typed. Users can click on the thumbnail for detail view. Detail Data View -
Just had members from MDCI from MA booked to fly out to San Jose for my CDISC ODM, SDTM and DEFINE.XML Seminar, welcome http://bit.ly/UoN9S
Just had a graphic artist create a new logo for SAS CDISC Forum. Hope you like it... http://bit.ly/CzxwB
A new world's largest cave was recently discovered in Vietnam. I have to visit this later this year... :) http://bit.ly/UYesx