I have a big data where the ID repeats multiple times (table 1) in a column and I want to reduce into 1/observation (table 2). Ones the IDs are reduces to 1 per obs, I want to merge table 2 with table 3. Table 1 ID 1 1 2 3 3 3 4 4   I want the output to be Table 2 ID 1 2 3 4   I want to merge table 2 with table 3 below to have an output like table 4 Table 3 ID Visit1 Visit2 Visit3 1 1/4/18 6/9/18 10/12/18 3 7/8/16 7/30/18 9/6/18   I want the output to be Table 4 ID Visit1 Visit2 Visit3 1 1/4/18 6/9/18 10/12/18 2 . . . 3 7/8/16 7/30/18 9/6/18 4 . . .   ... View more

I have a table below and I want to create a table where the first 'ID' is 'test'' =1. If the first 'ID' isn't 'test' =1 then to have it in a separate column. ID date test 1 6/7/18 1 1 8/12/28 1 2 5/4/18 3 3 6/20/18 1 3 10/4/18 2 4 5/8/18 3 4 7/23/18 3 5 3/9/18 1 5 7/4/18 1 5 11/20/18 1   I want the output to look like this ID date test Test1 Test2 1 6/7/18 1 1   1 8/12/28 1   1 2 5/4/18 2   2 3 6/20/18 1 1   3 10/4/18 2   2 4 5/8/18 3   3 4 7/23/18 3   3 5 3/9/18 1 1   5 7/4/18 1   1  5 11/20/18 1   1 ... View more

I have a data that looks like the table below. how do i calculate the number of days between dates in the row by ID  ID Date 1 11/20/18 1 11/20/18 1 11/28/18 3 6/4/18 3 6/20/18 I want an output that looks like the table below ID Date DiffDate 1 11/12/18   1 11/20/18 8 1 11/28/18 8 3 6/4/18   3 6/20/18 16   ... View more

I have a table below and I want to create a table where the first 'ID' is 'test'' =1. If the first 'ID' isn't 'test' =1 then to have it in a separate column. ID date test 1 6/7/18 1 1 8/12/28 1 2 5/4/18 3 3 6/20/18 1 3 10/4/18 2 4 5/8/18 3 4 7/23/18 3 5 3/9/18 1 5 7/4/18 1 5 11/20/18 1   I want the output to look like this ID date test Test1 Test2 1 6/7/18 1 1   1 8/12/28 1     2 5/4/18 2   2 3 6/20/18 1 1   3 10/4/18 2     4 5/8/18 3   3 4 7/23/18 3     5 3/9/18 1 1   ... View more

I have a table that looks like this and I want a the variable status to be split into two with one variable containing only "1" and the 2nd variable containing "2 and 3"   ID Status 1 1 1 3 1 1 1 1 2 1 2 3 2 1 3 1 3 2   I want the result to look like this table below ID 1st Status 2nd Status 1 1   1   3 1 1   1 1   2 1   2   3 2 1   3 1   3   2 ... View more

I have a code that is coded in .Z character and I would like to know what .Z means.  if  .z < LD <= 80 then Test = 1; ... View more

Hello; I have this kind of data  Data have; input id value count; record; 1 2 1 1 8 1 1 12 0 2 35 0 2 15 0 2 3 1 3 11 0 3 5 1 3 4 1 4 72 0 4 8 1 4 67 0   I want an the outcome table to look like this id value 1 2  1 8  3 5  3 4  I want to count only two consecutive 1's in "count" variable.  ... View more