Hi SAS Experts, I have dataset including dates. data Have; input id $ datestr :$10. Yes_No; format date mmddyy10.; date = input(datestr!!"-01",yymmdd10.); drop datestr; datalines; 1 2015-04-01 1 1 2015-04-12 0 1 2015-05-01 0 1 2016-02-14 1 1 2016-07-22 1 2 2015-01-07 0 2 2015-06-25 1 2 2015-07-19 0 2 2015-11-25 1 2 2015-12-24 0 2 2015-12-31 0 2 2016-01-20 0 ; run;   I want to create a new table that each record has the date of the observation with Yes_No=1 and then has the following dates of the observations with Yes_No=0 on the same record until next date with Yes_No=1. If there is another record with Yes_No=1 for the same ID, then a new record generated, and so on. Within each ID, every record has the date when Yes_No=1 followed with the dates Yes-No=0. Only special is that if first observation is a Yes_No=0, then leave it there.   The dataset I want: (the variables following_date_1-3 can be created as needed) ID Yes_NO date following_date_1 following_date_2 following_date_3 1 1 4/1/2015      4/12/2015       5/1/2015 1 1 2/1/2016 1 1 7/1/2016 2 0 1/1/2015 2 1 6/24/2015      7/2/2015 2 1 11/25/2015    12/24/2015     12/31/2015     1/20/2016   Thank you so much for any help! Best regards, C ... View more

Hi SAS Pros,   I have a dataset that each ID has many observations. I want to create two variables. One is called combination with the values from a1 to a5. The other is called type, which is assigned with different value for different combination and same value for same combination. But the combinations assigned with a same number between different IDs don't necessarily have to be the same. For example, the combination of 'axoo1' for ID=1 with a value of 1 in type is different with the combination of 'esjl4' for ID=2 who also has a value of 1 in type. The value for type within each ID should be continuous. data Have; length a1 $1 a2 $1 a3 $1 a4 $1 a5 ; infile datalines; input ID a1 a2 a3 a4 a5 ; return; datalines; 1 a x o o 1 1 b x o p 2 1 c y q s 6 1 c y q s 6 2 e s j l 4 2 h e w p 5 2 k k u u 9 2 k k u u 9 2 q q s i 7 ; run; What I want: ID a1 a2 a3 a4 a5 type combination 1 a x o o 1              1    axoo1 1 b x o p 2              2    bxop2 1 c y q s 6              3    cyqs6 1 c y q s 6              3    cyqs6 2 e s j l 4              1    esjl4 2 h e w p 5              2    hewp5 2 k k u u 9              3    kkuu9 2 k k u u 9              3    kkuu9 2 q q s i 7              4    qqsi7   Thank you so much for any help! Best regards, C ... View more

Hi SAS Pros, I have a dataset like showed below. data Have; input ID first_date :mmddyy10. last_date :mmddyy10. edu class; format first_date mmddyy10.; format last_date mmddyy10.; datalines; 1 02-01-2015 02-01-2015 3 3 1 02-01-2015 02-12-2015 3 1 1 02-01-2015 02-16-2015 3 3 1 02-01-2015 03-01-2015 3 3 1 08-20-2015 09-01-2015 3 3 1 10-06-2015 10-09-2015 2 1 2 10-19-2017 10-19-2017 1 1 2 10-19-2017 10-21-2017 3 1 2 10-19-2017 11-05-2017 2 2 2 10-19-2017 11-11-2017 1 1 2 10-19-2017 12-22-2017 1 1 2 12-25-2017 12-25-2017 3 2 ; run; I would like to recode the last dates if the records under the same ID match on ID, first_date, edu, and class, with only last dates are different. One of these set of records has a first date and last date are the same (i.e. the first record for each ID). The I would like to enter the date of the record with same first and last dates (i.e. 02-01-2015 for ID=1 and 10-19-2017 for ID=2) for the last dates for those records match on ID, first_date, edu, and class under the same ID.   If the records under the same ID are different in any of ID, first_date, edu, and class, then just leave as them own, regardless first date is different or the same as the last date.   The Want data is also post below. 1 02-01-2015 02-01-2015 3 3 1 02-01-2015 02-12-2015 3 1 1 02-01-2015 02-01-2015 3 3 1 02-01-2015 02-01-2015 3 3 1 08-20-2015 09-01-2015 3 3 1 10-06-2015 10-09-2015 2 1 2 10-19-2017 10-19-2017 1 1 2 10-19-2017 10-21-2017 3 1 2 10-19-2017 11-05-2017 2 2 2 10-19-2017 10-19-2017 1 1 2 10-19-2017 10-19-2017 1 1 2 12-25-2017 12-25-2017 3 2   Thank you very much for any help!   Best regards,   C ... View more

Hi SAS Pros,   I am having a dataset that is sorted by ID and date with the following variables:   data have; input group date $ age gender ; cards; 1 1/1/2017 3 0 1 1/2/2017 1 1 1 1/3/2017 10 1 1 1/9/2017 5 0 1 1/11/2017 11 1 2 1/1/2017 12 0 2 1/3/2017 10 1 2 1/7/2017 9 1 2 1/11/2017 16 0 2 1/20/2017 15 1 ; run; What I want to do is to create a new variable called Enroll_Yes that lets the first student (sorted by date for each group) who is greater or equal to 10 years old boy (gender=1) have a value of 1 (this student is enrolled, which is the 3rd observation of group 1) and the following students as long as they are greater or equal to 10 years old regardless whether they are boys or girls (gender= 0 or 1 are both fine) also have a value of 1 (the 5th observation of group 1). For group 2, the students who should be enrolled are 2nd, 4th, and 5th. The first observation should NOT be enrolled because the first enrolled one for each group has to be >=10 yrs BOY.    What I want is listed as follows: group date $ age gender 1 1/1/2017 3 0 0 1 1/2/2017 1 1 0 1 1/3/2017 10 1 1 1 1/9/2017 5 0 0 1 1/11/2017 11 0 1 2 1/1/2017 12 0 0 2 1/3/2017 10 1 1 2 1/7/2017 9 1 0 2 1/11/2017 16 0 1 2 1/20/2017 15 1 1 Thank you so much for any help in advance!   Best regards,   C   ... View more

Hi,   I have a dataset that each ID has multiple records. Within each group (ID), the variable A and B have only two values, missing and some other value.   data have; input ID A B; cards; 1   10   . 1    .    16 1    .    16 1    10   . 2    5     . 2    5     . 2    5     . 2    .      7   What I want to do is to replace the missing value with the non-missing value of the same variable within each group: 1   10  16 1   10  16 1   10  16 1   10  16 2    5     7 2    5     7 2    5     7 2    5     7   I really appreciate any help with this question.   Best regards, C ... View more