Hello,   I got stuck in the process to calculate the difference between two dates under a specific requirement. My data looks like below (Diff and Count are the variables that I desire to have) ID   Date          FirstPositive  Diff       Count A     1/1/2020        .                .              . A      1/3/2020      1                 .             1  A      1/4/2020       .                 1             2 A      1/5/2020       .                 1             3 B      1/4/2020      1                 .              1 B      1/5/2020       .                 1             2 I want to calculate the difference between dates for each ID, but start from the row when FirstPositive =1. I also would like to have the count variable which count the number of rows for each ID start from the row when FirstPositive =1.   Any advice would be appreciated! Thank you! ... View more

Hello,   I have a problem to keep ALL data in the most recent quarter for each measure.    Characters in my data; 1. The most recent quarter depends on the measure you select  2. The most recent quarter changes every month for each measure   My data look like: ID     Measure    Quarter 1        A               Q1 2020 2        A               Q2 2020 3        B              Q2 20202 4        B              Q3 2020 5        B              Q3 2020   I like to keep ID 2, 4 and 5, since ID 2 is in the most recent quarter of measure A and ID 4&5 are in the most recent quarter of measure B.   Any advice will be appreciated.   Thank you! ... View more

Hello,   I'm wondering if there is a way to calculate the difference between two dates in different variables listed in different rows. My data looks like below: MemberID   InDate     OutDate 1                  1/1/2019   1/3/2019 1                  1/4/2019   1/7/2019 2                  1/15/2019   1/16/2019 2                  1/20/2019    1/25/2019   Result that I'd like to have is MemberID   InDate     OutDate            IntervalDays 1                  1/1/2019   1/3/2019           . 1                  1/4/2019   1/7/2019             1 (difference between 1/4/2019 and 1/3/2019) 2                  1/15/2019   1/16/2019          . 2                  1/20/2019    1/25/2019         4(difference between 1/20/2019 and 1/16/2019)   Any advice will be helpful!! Thank you!     ... View more

Dear all,   I have many categories of variables and each of category include a lot of variables. I would like to create a statement that for each individual observation,  if there is at least one variable has non missing value, then we can use this observation. Now I only know the statement like below: if apple ne . or banana ne . or  grape ne. then flag='yes';  However, since I have tons of variables in each category, it will be very time consuming to type them individually. I'm wondering if there is an efficient way to do it.   I appreciate any thoughts and recommendations. Thank you! ... View more

Dear all,   I would like to create a table to count the number of non missing values for hundred of columns. My data looks like this:   col1 col2 col3 col4 ... col888 1       10     .       5  ...    23 56      .       4      23  ...  44 .         .       .       10  ...  23 1       10     .        5   ...    .   The table I would like to have is like this: col1         3 col2         2 col3         1 col4         4 ... col888     3   Really appreciate any help and advice. Thank you so much!!     ... View more