Hi,
I have the data in the attached format (please note subject number = country number + site number + sequential number 01, 02, 03 etc)clip.jpg
For instance, Germany country code is 9, so subject #1 at German site #1 will have the following ID: 90101.
Different subjects attended different # of visits thus far.
How do I project visits for the future, grouping them by visit type, month, site, and country? I need the output in the following format:
"in Nov 17 there will be 5 instances of visit 10 at site 101", etc.
To simplify a little bit, let's assume each future visit happens 1 month after the previous one, so that if a given subject had V10 on 15 Oct 17, this means V11 is projected for 15 Nov 17, whereas V12 is projected for 15 Dec 17 etc.
Thanks.
Bookmarks