Hi all,   I would like to create 3 groups by date: 1, 2 and 3, by group. I also would like to know the interval days by each day.    So my main goal is: to create 3 groups by date( and my question is how to create the group "2", because in second group could have more then one day. My other goal is to create the interval day for all days.   Observation: Is it possible to select the two earliest days?    Thanks all,   Daniel   My code is :  proc sql want as; select id; min(date), as first_date, max(date) as last_date from have group by id; quit; Have   Want     Id Date   Id Date Group   A 8-Aug-19   A 8-Aug-19 1 (first date) A 8-Aug-19   A 8/19/2019- 29 Aug 2   A 8-Aug-19   A 3-Sep-19 3 (last date) A 19-Aug-19           A 19-Aug-19           A 19-Aug-19           A 29-Aug-19           A 29-Aug-19           A 29-Aug-19           A 29-Aug-19           A 29-Aug-19           A 3-Sep-19           A 3-Sep-19           A 3-Sep-19           A 3-Sep-19           ... View more

Hi all, I am wondering to count how many days an event occurred. In this example, the interval between the first day and the last days is 20 days. So, there are repeatable days; thus, I would like to know how many days this event occurs. For example, in this case, it occurred in 10 days, even it was 20 days interval. Therefore, I wish to get this result: 10 days.   Thanks all   data want ; set have; ; by id date ; (I think it is right) /* this part that I am not sure */ run;   HAVE   WANT     id date   id date Number of days A 13-Sep-19   A 13-Sep-19 10 A 18-Sep-19   A 18-Sep-19   A 18-Sep-19   A 18-Sep-19   A 18-Sep-19   A 18-Sep-19   A 18-Sep-19   A 18-Sep-19   A 19-Sep-19   A 19-Sep-19   A 19-Sep-19   A 19-Sep-19   A 24-Sep-19   A 24-Sep-19   A 25-Sep-19   A 25-Sep-19   A 25-Sep-19   A 25-Sep-19   A 25-Sep-19   A 25-Sep-19   A 25-Sep-19   A 25-Sep-19   A 25-Sep-19   A 25-Sep-19   A 27-Sep-19   A 27-Sep-19   A 27-Sep-19   A 27-Sep-19   A 30-Sep-19   A 30-Sep-19   A 30-Sep-19   A 30-Sep-19   A 30-Sep-19   A 30-Sep-19   A 1-Oct-19   A 1-Oct-19   A 1-Oct-19   A 1-Oct-19   A 2-Oct-19   A 2-Oct-19   A 2-Oct-19   A 2-Oct-19   A 2-Oct-19   A 2-Oct-19   A 3-Oct-19   A 3-Oct-19   A 3-Oct-19   A 3-Oct-19   ... View more

Hi all,   I am using a code with PROC GLM for a multivariate regression. I would like to get the adjusted R-Square. I have numeric and categoric variables.   How could I get this Adjusted R-Square working with proc glm?   Thanks all in advance,   Daniel ... View more

Hi community,   I would like to know how to transpose values from a table that I have to table that I want as it is described below: What I have ID Marketed Value1 Value2 Value3 F1 A 13 207 1 F1 A 13 207 1 F1 A 13 207 1 F1 B 18 205 3 F1 B 18 205 3 F1 B 18 205 3 F1 B 18 205 3 F1 C 15 208 4 F1 C 15 208 4 F2 A 19 220 8 F2 A 19 220 8 F2 B 14 210 6 F2 C 12 212 5 F3 A 15 230 10   So, my goal is this next table below (because in the end I will transform each ID in a single line: What I want ID Value1A Value1B Value1C Value2A Value2B Value2C Value3A Value3B Value3C F1 13 18 15 207 205 208 1 3 4 F1                   F1                   F1                   F1                   F1                   F1                   F1                   F1                   F2 19 14 12 220 210 212 8 6 5 F2                   F2                   F2                   F3 15     230     10       Thanks in advance community,   Daniel   ... View more

Hi all,   I wish to extract some words from the variable observation. My goal is to extract these words (such as " H1", "N1")  from the variable (observation) to the variable observation1.   Thanks all in advance,    So my data is described below:   data test2; set test2;   user Observation observation1 367 sample type      indicated the presence of subtype H1. However,  H1 1427 sample type  indicated the presence of subtype H1. However, the               H1 3046 sample type  this case and indicated the presence of         multiple types, including H1, H3, N1, and N2.                H1, H3 and N1 3146 sample  type and indicated the presence of    multiple types, including H1, H3, N1, and N2.         H1, H3, N1, and N2     8910 sample type (H,N)  fluid    indicated the presence of               multiple types, including H1, H3 and N2.  H1, H3 and N2 9091 sample type      indicated the presence of type N1.   N1 ... View more