Hi All,
Can any one explain easily understanding way to do Shift table.
Hi Kurt, I'm late to replay and I hope by now you have figured it out about the shift table. Here is a link how others talk about shift table: https://www.lexjansen.com/cgi-bin/saspapers_query.php title search for "shift table".
Shift table is important only because it was not easy to get for some important parameters in clinical trials. We have done change from Baseline for continuous variables all the time, but for a very long time people haven't figure it out that we can do the same for categorical variables as we did for continuous variables. In the case of 4 possible categorical outcomes, a 4 by 4 table (shift table) is used to present the result. It takes a lot of space, and most of those 16 cells have no values. A little bit more complicated when you compare tables. A simplified and short-handed shift table is proposed. See the attached.
Best Regards
Jianmin Long
PS: the data in the attached is openly available on https://www.cdisc.org/sdtmadam-pilot-project
Please be more specific. What do you mean by "shift"?
Shift table for Physical examination in clinical trails.
@KalaBhairava wrote:
Shift tables are very important in clinical trial studies. A shift table is a table that displays the number of
subjects who are low, normal or high at baseline and the shift at post-dose.
So you need to do a certain transformation of the data in a single table.
If you provide some usable example data (data step with datalines), and the expected outcome, I can tinker around with it.
Hi Kurt, I'm late to replay and I hope by now you have figured it out about the shift table. Here is a link how others talk about shift table: https://www.lexjansen.com/cgi-bin/saspapers_query.php title search for "shift table".
Shift table is important only because it was not easy to get for some important parameters in clinical trials. We have done change from Baseline for continuous variables all the time, but for a very long time people haven't figure it out that we can do the same for categorical variables as we did for continuous variables. In the case of 4 possible categorical outcomes, a 4 by 4 table (shift table) is used to present the result. It takes a lot of space, and most of those 16 cells have no values. A little bit more complicated when you compare tables. A simplified and short-handed shift table is proposed. See the attached.
Best Regards
Jianmin Long
PS: the data in the attached is openly available on https://www.cdisc.org/sdtmadam-pilot-project
I assume your following CDISC models? If so then its just a matter of merging on baseline record to all post-baseline records, then reporting this to a table. So your data would look like:
USUBJID ... ANRIND BNRIND
xxx LOW HIGH
xxx NORMAL HIGH
Then its a matter of processing that information into the output shell you have. Unfortunately, exact code and such like is company IP, so you will need to do this yourself, using your company standards, shells, macros.
Yes thanks for replay and i need clarification on how to start procedures not code because i am new to this shift tables.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need courses to help you with SAS Life Sciences Analytics Framework, SAS Health Cohort Builder, or other topics? Check out the Health and Life Sciences learning path for all of the offerings.