Bioequivalence and Bioavailability Forum • SAS and missing values

SAS and missing values [Software]

posted by Helmut – Vienna, Austria, 2012-01-06 02:47 (4872 d 05:40 ago) – Posting: # 7871
Views: 8,761

Dear SAS-users,

as you might have guessed from this post I’m struggling with translating FDA’s RSABE code into PHX and R. For simplicity I hijacked EMA’s two Q&A data sets. What puzzles me is how SAS deals with empty cells (f.i. in the full replicate). We have 77 subjects and lat1t (77), lat2t (71), lat1r (76), lat2r (74). Is it correct that SAS throws a ‘.’ (line: lilat=0.5*(lat1t+lat2t-lat1r-lat2r);) in all but the 69 cases where we have complete data?

My results so far (Phoenix/WinNonlin 6.2.1.51 on logdata):

Data set I (full replicate TRTR|RTRT)

pointest 1.1546132 x 0.018259609 boundx 0.050907573 s2wr 0.20401347 y -0.16253523 sWR 0.4516785 boundy -0.12501551
Since sWR ≥ 0.294 apply scaled ABE:
a. -0.12501551 ≤ 0 &
b. 0.80 ≤ 1.1546 ≤ 1.25
Scaled Average BE shown (CV_WR 47.57%)

Data set II (partial replicate TRR|RTR|RRT)

pointest 1.0226439 x -0.00034955932 boundx 0.0052688215 s2wr 0.01298983 y -0.010348851 sWR 0.11397294 boundy -0.0066520374 critbound -0.0039728893
Since sWR < 0.294 apply unscaled ABE:
unscabe_pointest 1.0226 unscabe_lower 0.9705 unscabe_upper 1.0776
0.80 ≤ 0.9705 & 1.0776 ≤ 1.25
Average BE shown (CV_intra 11.55%)

—
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:

SAS and missing valuesHelmut 2012-01-06 01:47
- SAS and missing values Shuanghe 2012-01-13 11:17
  - THX & another request Helmut 2012-01-13 13:31
    - Congratulations for both of us :-D Shuanghe 2012-01-13 16:14
      - FDA's RSABE: Phoenix ‘validated’ against SAS Helmut 2012-01-13 16:39
        
        How to obtain CINV value in Phoenix Shuanghe 2012-01-19 11:43
        
        Import from external source Helmut 2012-01-19 14:24
        
        Thanks, it's done!! Shuanghe 2012-01-19 22:42
        
        Thanks, it's done!! Helmut 2012-01-20 00:10
- SAS and missing values JMCardot 2012-01-31 03:12