Lexical order [Software]

posted by Helmut Homepage – Vienna, Austria, 2017-01-20 14:34 (2623 d 21:25 ago) – Posting: # 16991
Views: 5,037

Hi Sundar,

❝ Could you please clarify the reason for getting results of LSM differences and confidence limit values in opposite to one another (eg., negative vs positive or positive vs negative values) when you evaluate the same data using SAS and Phoenix WinNonlin.


Both software packages by default give the LSM difference in lexical order. If you coded test with T and reference with R, the difference will be given as R – T (since R < T).
It might be that your SAS-code changed the order by a statement similar to this one:

lsmeans formulation / pdiff=control("R") CL alpha=0.10;

In Phoenix there is no native method the change the order which you will get in
Bioequivalence > Output Data > LSM Differences.

[image]


My method to recode the LSM differences (which works for any specification of T and R):
LSM Differences > Send To > Data > Data Wizard
Rename to Reordered LSM Differences and add these Custom Transformations:
  1. R: left(Level_Level, search(Level_Level, '-', 1)-2)
  2. T: right(Level_Level, search(Level_Level, '-', 1)-2)
  3. Relevel: concatenate(T, ' - ', R)
  4. Difference: -Estimate
  5. Lower: -Upper_CI
  6. Upper: -Lower_CI
Cosmetics:

[image]



PS: You selected ☑ E-mail notification if there has been a reply to this message
However, both replies bounced from the E-mail server (xxxxxxxx wasn’t found at yyyyyyyy.com. 550 5.1.10 RESOLVER.ADR.RecipientNotFound; Recipient not found by SMTP address lookup).
Since you registered in 2011 with your company’s e-mail address: Did you change your job? If yes, consider updating your profile (once logged in, click on msmnainar in the upper right hand corner [image] Edit User data E-mail click on [ Change e-mail address ]) or refrain from further E-mail notifications. THX.

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

Complete thread:

UA Flag
Activity
 Admin contact
22,957 posts in 4,819 threads, 1,639 registered users;
74 visitors (0 registered, 74 guests [including 9 identified bots]).
Forum time: 12:00 CET (Europe/Vienna)

Nothing shows a lack of mathematical education more
than an overly precise calculation.    Carl Friedrich Gauß

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