Ravi
★    

India,
2010-04-24 08:16
(5478 d 09:06 ago)

Posting: # 5209
Views: 6,910
 

 Missing value in WinNonlin [Software]

Dear All,

We have conducted a 12 subjects biostudy. From the concentration time data it was observed that for some subjects data was missing at 96 and 120 hr time point and for other subjects data was missing for 72 and 168 hrs. There are certain subjects for whom 48 hr observation is missing. Data corresponding to these time points is missing either in Period 1 or Period 2 or in both the periods.

Now my question is how to treat the absent value (e.g. corresponding to 96 and 120hr) while feeding the data in WinNonlin. Some Options comes to my mind are:
  1. Just write Missing in place of Absent corresponding to 96 and 120hr data point and follow the usual procedure of NCA to generate the PK Parameters.

  2. Other option can be exclude all the data form 96 hr onward when sampling was done upto 216 hr for both the periods and follow the usual procedure of NCA to generate the PK Parameters.

I have asked the same question to Parsight support but was not satisfied from their answer.
Parsight reply to my question was

"We suggest that ........ the 96 and 120 observation rows for both test and reference should be excluded prior to running the NCA."

From their reply again question comes to my mind is

If I follow suggested approch (in red) then for different subjects I will have different sampling points at least for the NCA analysis i.e. for some subjects sampling scheme would be 0, 1, 2, 2.5, 3, 3.5, 4, 4.5, 5, 5.5, 6, 6.5, 7, 8, 10, 12, 16, 24, 48, 72, 144, 168, 216 and for other subjects sampling scheme would be 0, 1, 2, 2.5, 3, 3.5, 4, 4.5, 5, 5.5, 6, 6.5, 7, 8, 10, 12, 16, 24, 48, 96, 120, 144, 216. Like wise for some subjects sampling scheme would look like 0, 1, 2, 2.5, 3, 3.5, 4, 4.5, 5, 5.5, 6, 6.5, 7, 8, 10, 12, 16, 24, 72, 96, 120, 144, 168, 216.

Now my question is,
  1. Is it write or wrong to have different time points for different subjects in the same study?
  2. My second question is what is wrong with the first approach which I have suggested i.e. Just write missing in place of absent corresponding to 96 and 120hr data point for Period 1 and follow the usual procedure of NCA to generate the PK Parameters.

Please suggest me the correct way of tackling this issue. Please provide some detail or literature in support of your answer.

Waiting for your invaluable response.


Edit: Category changed. [Helmut]

Thanks & Regards
Ravi Pandey
Helmut
★★★
avatar
Homepage
Vienna, Austria,
2010-04-24 18:21
(5477 d 23:01 ago)

@ Ravi
Posting: # 5212
Views: 5,913
 

 Data imputation

Dear Ravi!

❝ […] data was missing at 96 and 120 hr time point and for other subjects data was missing for 72 and 168 hrs. There are certain subjects for whom 48 hr observation is missing.


The sampling schedule was …, 48, 72, 96, 144, 168, 216 h. It does not matter what text you write in a data cell instead of a numeric result. WinNonlin's default (≤5.3) is 'Missing'; however any other text ('Absent' or even 'blabla') is treated in the same way (see below). In Phoenix (≤6.1) it's an empty cell - imported datasets are converted automatically and you can't write text into a numeric field any more.

❝ […] what is wrong with the first approach which I have suggested i.e. Just write missing in place of absent


Have you tried that before asking here? You would have noticed that there's no difference in results. Have you given Pharsight’s support all information? I can't imagine they suggested to essentially exclude measured concentrations of subjects with nonmissing values from the dataset.
However in WinNonlin as well in Phoenix missing values in the profile embedded within measured ones are problematic, because if you have specified the linear trapezoidal in NCA these values are always interpolated in a linear manner, which will give a positive bias of the AUC after tmax.
See also these threads: #3723 and #4182.
It is possible to calculate partial AUCs with the lin/log-option and sum them up later on. But this is a quite cumbersome procedure; for the technical details consider asking your question at Pharsight's Extranet.

I would suggest to log/linear-interpolate missing values; however, I would not interpolate more than two values in a row. Formula: Ci=exp{ln(Ci-1)+(ti-ti-1)×[ln(Ci+1)-ln(Ci-1)]/(ti+1-ti-1)}

Example-function C=100×exp(-0.025×t): 72/96/120/144; 96 & 120 missing, interpolation based on 72 and 144:
  t     C
 72   16.53
 96  Missing
120  Missing
144    2.732

C96 =exp{ln(16.53)+( 96-72)×[ln(2.732)-ln(16.53)]/(144-72)}=9.071
C120=exp{ln(16.53)+(120-72)×[ln(2.732)-ln(16.53)]/(144-72)}=4.978


AUC with imputed values within [72,144] will be 568.3, whilst Phoenix/WinNonlin will give 693.4 - or a positive bias of 20 % (theoretical from function: 551.9).
The only easy solution I know in PHX/WNL is to calculate AUCs for all (!) subjects by the lin-up/log-down trapezoidal - which is a good idea anyhow (Model Options > NCA Settings > Calculation Method > Linear Up/Log Down). AUC within [72,144] will be 551.9. If you have stated this procedure in the protocol, you don't have to worry about missing values any more.
Overview:
no imputation, linear trapezoidal:          693.4 (bias +20.41 %)
96 & 120 imputated, linear trapezoidal:     568.3 (bias  +2.89 %)
no imputation, lin-up/log-down trapezoidal: 551.9 (unbiased)


If you use data-imputation you must not use these values in the estimation of lambda-z later on (in PHX/WNL these values must be excluded). Hopefully you have still at least three values in the log/linear phase.

For the next study state your procedure in the protocol (regulators don't like post-hoc data manipulations). I received not a single deficiency letter in the past thirty years for this procedure. :cool:
BTW, why have you sampled beyond 72 hours?

Dif-tor heh smusma 🖖🏼 Довге життя Україна! [image]
Helmut Schütz
[image]

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

India,
2010-04-26 08:35
(5476 d 08:47 ago)

@ Helmut
Posting: # 5224
Views: 5,771
 

 Data imputation

Dear HS,

Thanks for the detailed response.

We have outsourced this study to a CRO and their PK expert is using this approach i.e.

Exclude all the data form 96 hr onward when sampling was done upto 216 hr for both the periods and follow the usual procedure of NCA to generate the PK Parameters.

Please tell flaws in this procedure.

Thanks in advance.

Thanks & Regards
Ravi Pandey
SDavis
★★  
Homepage
UK,
2010-04-28 21:15
(5473 d 20:07 ago)

@ Ravi
Posting: # 5261
Views: 5,703
 

 Data imputation

Dear Ravi,
In your initial post you said, (PHST reference #130355).

❝ some subjects data was missing at 96 and 120 hr time point and for other subjects data was missing for 72 and 168 hrs. There are certain subjects for whom 48 hr observation is missing. Data corresponding to these time points is missing either in Period 1 or Period 2 or in both the periods.


1) why is it missing, is it 'consistent' ?

❝ We have outsourced this study to a CRO and their PK expert is using this approach i.e.


Exclude all the data form 96 hr onward when sampling was done upto 216 hr for both the periods and follow the usual procedure of NCA to generate the PK Parameters.


2) if you have data beyond 96 hours, even with embedded missing data then I don't really see the advantage in excluding your raw data; just make your comparison to AUCinf or perhaps if they were very different to define AUClast as that to the last common quantifiable time point between the two. However in the data I saw on this record the subject's concentrations were quantifiable in both periods to 168h. Therefore I don't think I agree with the decision to ignore data after 96 hours

3) actually in Phoenix it is acceptable to set your concentration to be a TEXT column to hold these additional flags if you need; just be aware that when performing any numerical operation on a text column e.g. NCA, Graphing etc. those text values will all be missing (since not real numbers).

4) If you want to play at substitutions with a profile e.g. for embedded BLQs you could use the BLQ wizard but personally I would be very cautious about this for regulatory submissions and would make sure that the rule set I was going to use was described in the protocol/DAP BEFORE the study was run.

5) Lastly it's useful to send the data you want someone to look at for you as an actual data file e.g. CSV, XLS, PWO. so they don't have to type it all in to recreate your problem.

Best regards,
Simon.
Pharsight- A Certara™ Company
Get tips and discuss Pharsight products with other users;
Ravi
★    

India,
2010-04-29 08:36
(5473 d 08:46 ago)

@ SDavis
Posting: # 5265
Views: 5,674
 

 Data imputation

Dear Simon,
Thanks for your response.

Therefore I don't think I agree with the decision to ignore data after 96 hours


I agree with your view.

❝ Lastly it's useful to send the data ... as an actual data file e.g. CSV, XLS, PWO.


Ok will do it next time. Sorry for Inconvinence.

Please tell me how to attach a xls file while posting a question on this forum.

Thanks & Regards
Ravi Pandey
SDavis
★★  
Homepage
UK,
2010-04-29 11:42
(5473 d 05:40 ago)

@ Ravi
Posting: # 5266
Views: 5,664
 

 Data imputation /PHST reference #130355

Dear Ravi,
On this Forum it is only permitted to attach Images using the Upload or Image buttons on the right hand side of the Reply box.

My comment about sending the data file was in reference to the original Support question sent to Pharsight where I didn't see the data file attached, only data pasted into the email that was not possible to easily read back into a dataset.

Simon.

Simon
Senior Scientific Trainer, Certara™
[link=https://www.youtube.com/watch?v=xX-yCO5Rzag[/link]
https://www.certarauniversity.com/dashboard
https://support.certara.com/forums/
UA Flag
Activity
 Admin contact
23,424 posts in 4,927 threads, 1,670 registered users;
25 visitors (0 registered, 25 guests [including 3 identified bots]).
Forum time: 17:22 CEST (Europe/Vienna)

The difference between a surrogate and a true endpoint
is like the difference between a cheque and cash.
You can get the cheque earlier but then,
of course, it might bounce.    Stephen Senn

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