Hello,  I'm trying to create a table for each new value combination across 2 variables.  Here is the example data:   Member  Description         Comment 1                 given 2 doses      Ingested doses 2                given 3 doses      Did not ingest doses 4                given 3 doses      Did not ingest doses 6                given 2 doses      Did not ingest doses   So ideally 3 data tables would be output based on unique combinations of description and comment.  Output:   Table 1: Member  Description         Comment 1                 given 2 doses      Ingested doses   Table 2: Member  Description         Comment 2                given 3 doses      Did not ingest doses 4                given 3 doses      Did not ingest doses   Table 3: Member  Description         Comment 6                given 2 doses      Did not ingest doses ... View more

Hi, I'm looking to get the dates in between 2 dates according to the criteria of a third variable.  Here is what my data looks like: Animal       Visit          Date 100            Day -1      05/19/21 100            Day 14     06/03/21 100            Day 28     06/17/21 100            Day 42     07/01/21 100            Day 70     07/28/21 100            Day 84     08/11/21   I need the dates in between when visit= 'Day 28' and visit= 'Day 42' and then the dates between when visit= 'Day 70' and visit= 'Day 84', with an addition variable to signify the days calculated as 'observation' and the visit days as 'visit' Also, I need 14 consecutive days calculated after visit= 'Day 84'.  I presume an intck or intx formula would need to be used to avoid going past the correct last day of the month in a given calendar year.   The output would look like this: Animal       Visit          Date           Label   100            Day -1      05/19/21     visit 100            Day 14     06/03/21     visit 100            Day 28     06/17/21     visit 100                            06/18/21      observation 100                            06/19/21      observation 100                            06/20/21      observation ... 100            Day 42     07/01/21     visit 100            Day 70     07/28/21     visit 100                            07/29/21      observation 100                            07/30/21      observation 100                            07/31/21      observation ... 100            Day 84     08/11/21     visit 100                             08/12/21     observation 100                             08/13/21     observation 100                             08/14/21     observation ...   I put '...' to signify that the iterated rows would continue until it reaches the end point designated by visit      ... View more

Hello, I need to remove characters from a string based on multiple conditions.  The data I have looks like this: Animal     Form        Days                     Days_Expected    Days_Missing 1001        exam        1,2,3,36,103        0,1,2,4,36,103          0,4  1001        lab            1,2,3,36,100        0,1,2,4,30,100          0,4,30    So I need a function that will remove characters from the missing value based on criteria in the days value. For instance, If form=exam and days contains '3', then remove '4' from days_missing and if form=exam and days contains '1', then remove '0' from days missing.  Also, if form=lab and days contains '1' then remove '0' from days_missing   The outcome wanted would be this:   Animal     Form        Days                     Days_Expected    Days_Missing 1001        exam        1,2,3,36,103        0,1,2,4,36,103            1001        lab            1,2,3,36,100        0,1,2,4,30,100          4,30    ... View more