CDISC datasets from R. Why not? [Software]

posted by Helmut Homepage – Vienna, Austria, 2019-03-21 15:43 (757 d 14:34 ago) – Posting: # 20066
Views: 5,495

Hi WhiteCoatWriter,

» While Phoenix needs an additional package to be purchased, I feel that the same can be done by creating tables on phoenix (or importing in .csv) and exporting it to .xpt without the specific package which I assume will only help with limited datasets.

[image]I did that myself before I got Certara’s CDISC-license. Never tried anything else than raw-data (scheduled & actual time points, concentrations) and NCA-results.

» » If you are an experienced R-coder, consider writing a package …
» I might not be an expert coder/programmer, but I have been working on this for quite some time. Thank you for the references, will definitely try doing something.

Needs patience and the learning curve is not flat. A coding environment like R-Studio and an account at GitHub greatly helps.

» It really has been a challenge to get it validated using pinnacle validator.

I believe it. Congratulations!

» Also, when it comes to Adam datasets it specially requires SAS date format which I assume is not possible to be created on R.

SAS’ date value (days since 1960-01-01) and datetime (seconds since 1960-01-01 midnight) are a pain in the ass. The format ddmmmyy:hh:mm:ss is just ugly. I played around in R a bit and see what you mean. I wouldn’t say it’s impossible, only tricky.*
The “origin” of date- and time-objects in R is (like the UNIX Epoch time) 1970-01-01 00:00:00 UTC. The timezone is important. Is National Language Support (NLS) part of SAS’ base installation? Without, everything is in local time. I found a funny document stating

The last counter is the datetime counter. This is the number of seconds since midnight, January 1, 1960. Why January 1, 1960? One story has it that the founders of SAS wanted to use the approximate birth date of the IBM 370 system, and they chose January 1, 1960 as an easy-to-remember approximation.

Heck, did they mean the timezone (EST = UTC-5) of Poughkeepsie, NY?
The man-page of as.POSIX() claims that the origin of SAS’ datetime is 1960-01-01 00:00:00 GMT but I prefer to avoid a second-hand reference.

» While No other regulatory mandates datasets for Bio equivalence study, I still keep wondering what really sparked the USFDA in the mid of Dec 2016 to make CDISC datasets mandate for regulatory submission.

Not the slightest idea.

Dif-tor heh smusma 🖖
Helmut Schütz

The quality of responses received is directly proportional to the quality of the question asked. 🚮
Science Quotes

Complete thread:

 Admin contact
21,419 posts in 4,475 threads, 1,509 registered users;
online 17 (0 registered, 17 guests [including 3 identified bots]).
Forum time: Saturday 06:17 UTC (Europe/Vienna)

I never did anything worth doing by accident,
nor did any of my inventions come by accident;
they came by work.    Thomas Alva Edison

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz