Thanks, it's done!! [Software]
Hi Helmut,
Now you made my day!! I import a table of CINV and everything works out just fine. I'll have to redo it to tidy the workflow a bit to ease of use for others but that shouldn't present any problem now.
well, that's better than mine. After discovering they don't even have max min, and x**2 is not working as square of x, as SAS would do, I did this:
if(abs(lower_ci) > abs(upper_ci), abs(lower_ci)* abs(lower_ci), abs(upper_ci)*abs(upper_ci)).
Where did you get the idea that ^ means to raise power?
nice to know.
No, it's not necessary now. But thanks anyway.
By the way, I seems to get slightly different CI as well. I need to run more SAS to confirm it but the difference I got is usually very small, always happens to the last decimal. But imagine some day you have 125.01% instead of 125.00%..., there would be a lot of
with regulator to get the approval. or not.
Now you made my day!! I import a table of CINV and everything works out just fine. I'll have to redo it to tidy the workflow a bit to ease of use for others but that shouldn't present any problem now.
❝ t and χ² are used internally in Phoenix, they are not accessible as a function in a custom transformation.
❝ you have noticed that min()
and max()
are not available as well (bug 11570). Instead of simply using
❝ (max((abs(Lower_CI)), (abs(Upper_CI))))^2
❝ I had to workaround
❝ if(abs(Lower_CI)>=abs(Upper_CI), (abs(Lower_CI))^2, (abs(Upper_CI))^2)
well, that's better than mine. After discovering they don't even have max min, and x**2 is not working as square of x, as SAS would do, I did this:
if(abs(lower_ci) > abs(upper_ci), abs(lower_ci)* abs(lower_ci), abs(upper_ci)*abs(upper_ci)).


❝ Right now my workflow is rather lenghty (if you want I can send you the project file off-list).
No, it's not necessary now. But thanks anyway.
By the way, I seems to get slightly different CI as well. I need to run more SAS to confirm it but the difference I got is usually very small, always happens to the last decimal. But imagine some day you have 125.01% instead of 125.00%..., there would be a lot of

—
All the best,
Shuanghe
All the best,
Shuanghe
Complete thread:
- SAS and missing values Helmut 2012-01-06 01:47 [Software]
- 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
- Thanks, it's done!!Shuanghe 2012-01-19 22:42
- Import from external source Helmut 2012-01-19 14:24
- How to obtain CINV value in Phoenix Shuanghe 2012-01-19 11:43
- FDA's RSABE: Phoenix ‘validated’ against SAS Helmut 2012-01-13 16:39
- Congratulations for both of us :-D Shuanghe 2012-01-13 16:14
- THX & another request Helmut 2012-01-13 13:31
- SAS and missing values JMCardot 2012-01-31 03:12
- SAS and missing values Shuanghe 2012-01-13 11:17