Log in
Register|
ElMaestro ★★★ Denmark, 2014-10-11 15:34 (3816 d 01:09 ago) Posting: # 13687 Views: 15,428 |
|
|
Hi all, now that reference datasets have been produced and published with (hopefully correct) reference results by some BE wackos I wonder about software PQ. It can be argued that a system -in this case the computer doing the BE analysis- needs to be kept updated on several fronts and protected from undesired pertubations. It quickly becomes the eternal discussion of isolation versus options of updating. Noone really knows and can control well what goes on when you hook up a computer with e.g. Windows to the internet. There is absolutely no good way of telling the system that any traffic that could cause interference with SAS or WinNonlin or Minesweeper is prohibited while internet connections for good cause is required. You never know if the next anti-virus update screws up a dll of some other software without the user having a chance to know. Restricting access thorugh the fireall for some programs doesn't solve it. And so forth. So I wonder wouldn't it be very solid and a good idea to simply perform some degree of PQ "every day" or "immediately before" a reported analysis; spend 30 secs literally on running the reference datasets through the stats package, compare the output and tick off the results, and then if the results match conclude that the system is PQ that day and run the necessary analysis? Would be a minute or two of extra work on the day of analysis, and would require an extra form and possibly a sentence or two in a SOP. And we'd all sleep better. No? Edit: Category changed. [Helmut] — Pass or fail! ElMaestro |
|
Helmut ★★★   Vienna, Austria, 2014-10-17 19:23 (3809 d 21:20 ago) @ ElMaestro Posting: # 13748 Views: 14,448 |
|
![[image]](img/uploaded/image273.png) Hi ElMaestro,❝ So I wonder wouldn't it be very solid and a good idea to simply perform some degree of PQ "every day" or "immediately before" a reported analysis; […] I like the idea very much! ❝ No? Yes! To the right one of the RSABE-templates* we developed last year. Both reference datasets from EMA’s Q&A-document are part of the project-file. It’s foolproof (I hope): Two PDFs are directly accessible: The Q&A itself and a step-by-step instruction how to import data, map variables, perform the analysis,  …After entering #1-3 in the Data-section, in #4 of the Workflow the desired dataset is chosen. Run EMA’s examples first. There is a table in the output where the actual results can be compared to the ones reported by the almighty oracle.
❝ […] if the results match conclude that the system is PQ that day and run the necessary analysis? I guess in any software one could modify the code after the check and before the analysis, right? But that’s plain fraud and not the topic of this thread.
— Dif-tor heh smusma 🖖🏼 Довге життя Україна! ![[image]](https://static.bebac.at/pics/Blue_and_yellow_ribbon_UA.png) Helmut Schütz ![[image]](https://static.bebac.at/img/CC by.png) The quality of responses received is directly proportional to the quality of the question asked. 🚮 Science Quotes |
|
jalgorta ☆ Spain, 2015-05-06 00:45 (3609 d 15:59 ago) @ Helmut Posting: # 14750 Views: 12,231 |
|
|
Dear Helmut, unfortunately the FDA RSABE template doesn't work (at least on my hands!!!). I tried many times with an small Full replicate BE study and the first step (Preparation of data set) works fine, but when entering into the analysis the repeated message is ERROR 11051 Parising error. Illegal numeric value. Of course, the data etc are revised several times... Desperate""" Jalgorta Edit: Full quote removed. Please delete everything from the text of the original poster which is not necessary in understanding your answer; see also this post! [Helmut] |
|
Helmut ★★★ Vienna, Austria, 2015-05-06 01:00 (3609 d 15:43 ago) @ jalgorta Posting: # 14751 Views: 12,138 |
|
|
Hi Jalgorta, can you send me your data (CSV-format preferred) by e-mail (address over there)? I will have a look ASAP. Please tell me also your Windows version, 32- or 64bit, and the version of Phoenix you are using (I have 6.3.0395 and 6.4.0.768, 32/64bit on my machine). — Dif-tor heh smusma 🖖🏼 Довге життя Україна! Helmut Schütz The quality of responses received is directly proportional to the quality of the question asked. 🚮 Science Quotes |
|
ElMaestro ★★★ Denmark, 2015-05-06 03:00 (3609 d 13:43 ago) @ jalgorta Posting: # 14752 Views: 12,180 |
|
|
Hi Jalgorta, this may be a dumb question, but I note that Spain uses comma as decimal separator while the US default is a dot. While it sounds trivial to get a dot converted to a comma on import it is anything but. Especially when you have locale settings for both the OS as well as for the compiler used to built the software you are using. So could this come down to a plain comma/dot mismatch in one of Nonlin's importer/helper functions? — Pass or fail! ElMaestro |
|
jalgorta ☆ Spain, 2015-05-06 15:45 (3609 d 00:58 ago) @ ElMaestro Posting: # 14762 Views: 12,256 |
|
|
❝ this may be a dumb question, but I note that Spain uses comma as decimal separator while the US default is a dot. While it sounds trivial to get a dot converted to a comma on import it is anything but. Especially when you have locale settings for both the OS as well as for the compiler used to built the software you are using. So could this come down to a plain comma/dot mismatch in one of Nonlin's importer/helper functions? Hi ElMaestro, good point (and sometimes works)...but unfortunately before the posting I tried with comma, dot, and without decimals!!! Yesterday I spent more than 10 hours with the trial & error methodology... |
|
Helmut ★★★ Vienna, Austria, 2015-05-06 19:55 (3608 d 20:48 ago) @ jalgorta Posting: # 14766 Views: 12,088 |
|
|
Hi Jaime, I just send you my project-files. Worked like a charm. I guess (!) something went wrong in "Prepare Dataset for Analysis " – "Determine Order of Formulations" – "Step 2 Transformation". The code for the new column "Data_Ln" is if(flag="N", ln(Data), Data)In my project the value of Subject 1, Period 1 is displayed as 12.522701 and given in full precision with 12.5227008568555. Identical to yours. In the following "Append Worksheets" I have exactly the same numbers as above, but in yours it is displayed as 1.2522701E+14 and in the cell as 12,5227008568555. If I re-execute this step on my installation, the value changes to the correct one. So it might be a problem related to the locale. Pharsight recommends to run PHX in EN(US) – which I never did. When I was ~sixteen I decided to use the period as the decimal separator (even in handwriting) because I thought it looks cool and more scientific.  Therefore, I’m running PHX in a German locale DE(AT), but changed my general Windows-settings to decimal separator period, thousands separator comma, field separator semicolon. Consider giving it a try on your machine. I would suggest to register at Certara’s Forum, where you could upload your project-file. They should have a look, IMHO. PS: Since I code a lot – in all languages I use (R, PHP, SQL, JavaScript) the decimal separator is mandatorily the period. The comma sucks. — Dif-tor heh smusma 🖖🏼 Довге життя Україна! Helmut Schütz The quality of responses received is directly proportional to the quality of the question asked. 🚮 Science Quotes |
|
SDavis ★★ UK, 2018-05-02 17:46 (2516 d 22:57 ago) @ jalgorta Posting: # 18751 Views: 7,597 |
|
|
Apologies for replying to such an old thread but just today I was answering a question on RSABE that caused me to check Helmut's excellent repository and I only just saw it. Hopefuly you and others have worked this out but absolutely your data should have decimal places defined by point as the separator. I would recommend actually that you change your regional settings to use decimal point and restart Phoenix to ensure this is consistent, see pages 8&9 of the Getting Started guide (within menu, Help>Documents) ![[image]](img/uploaded/image207.jpg) 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/ |
Ing. Helmut Schütz