Hi,
I am a big R user and sometimes having difficulty with the limitations of the data wizard.
I am trying to fill down DOSE and DOSENUMBER in a data merge in Phoenix WNL. I want to do this by subject ID and visit day.
As in Rstudio, this is quite easy (see attachment), I am having trouble getting the same results in Phoenix.
Does anyone have any tips that do not include the R-script node?
Cheers, Meike
Hi Meike, I’m not very familiar with R, but if you were to post a representative PHX project then I would try to show yuo how I would merge (or Join) two sets.
Alternatively I would use the option External software>Rshell, to launch the R send my code and data there and return the results into Phoenix where it can be picked up for the next step(s),
There is a basic example of using this feature in
C:\Program Files (x86)\Certara\Phoenix\application\Examples\R
anf you can read more about it here; online help R-script
Simon.
Hi Meike,
You can use the data tool crossproduct to do what you are asking for. I have attached a Phoenix project that I think might help you understand this data tool. In the results, look at worksheet BA.
Hope this helps,
Ana Henry
filldown.phxproj (141 KB)
Hi Ana,
I saw your workflow and this is exactly what I was looking for! So thank you so much. I tried cross product before, but did not think about first filtering the null doses out.
Cheers, Meike
