Lexical order [Software]

posted by Helmut Homepage – Vienna, Austria, 2017-01-20 14:34 (2940 d 17:19 ago) – Posting: # 16991
Views: 6,066

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
23,376 posts in 4,912 threads, 1,667 registered users;
116 visitors (0 registered, 116 guests [including 6 identified bots]).
Forum time: 07:54 CET (Europe/Vienna)

The great tragedy of Science – the slaying
of a beautiful hypothesis by an ugly fact.    Thomas Henry Huxley

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