Verifying CDISC Date Values on the Go

I have analyzed data which contain date variables for years and in the past, they were stored as numeric date variables in SAS format. However, more recently, my date variables are stored as characters since it is often stored in ISO format according to CDISC standards. This makes it challenging to verify since I can not easily apply computations upon a character date value.

I therefore have been using a macro named "datetest" which perform a series of checks against the date values to see if it is invalid. Things it catches include examples such as the month being 13 or the day is missing. There are times when I needing to look at many datasets and it is useful to perform this verification on the go on an iPhone. I will share with you this approach in applying the date test on an iPhone as shown in this video.

Comments

Post a Comment

Popular posts from this blog

SASGF12 Opening Session with Jim Goodnight starting a technical demo ... nice :) Here is a video of it: http://ping.fm/sn6dY
Read more

Clinical Trials Terminology for SAS Programmers

Image
Introduction The drug development process is a clinical process that has its own language. It is not required that SAS programmers function as a MD or a regulatory expert, but working knowledge of the terminology is important to be effective. This section will walk through the drug development process from discovery to Phase IV. It will explain a wide range of acronyms such as IND, NDA , GCP and MedDRA . It will also describe some of the terminologies used within the process of clinical trials as a drug is developed and submitted to the FDA . This will give SAS programmers a larger perspective and context to their work during the analysis and reporting of clinical trials data. This section will tell a fictitious story about a college graduate named James who is starting a new position at a pharmaceutical company. Each new term James encounters is presented in bold and italicized for emphasis. As he enters a new professional world, he meets many people and learns new processes that...
Read more

SAS iPhone App Architecture

Image
The delivery of SAS data and reports to an iPhone application is unique and requires a different architecture as compared to traditional client server systems. This is similar to web applications in how it is delivered to a browser but in this case, the application replaces the browser. The diagram below illustrates the components of the iPhone SAS application architecture including: the iPhone application , a web server and the BI Flash server. In this example, the iPhone application on the iPhone communicates through standard TCP / IP protocol to a web server. The web server then communicates to an application server which is actually a SAS session processing SAS programs and data. The output resulting from the SAS program is then delivered back to the iPhone in a similar way a web browser would access a web page the serer. The distinction however is that the iPhone application is not a web browser and the SAS session running on the server is more dynamic compare to ...
Read more