Hi SAS Experts,   I am having a project to mange a dataset with affiliated subjects, which means there is a lady who is a mother from one family (subject=1) and her daughter (subject=1.1) and her son (subject=1.2) etc.   I need to create some variables describing every mother-kid situation, such as whether they are all female, whether they all have fiber everyday, and what is the absolute difference of age.   The dataset I have is this:   family ID female Has fiber every day age Mother Kids 4 4 1 1 25 1 0 4 4.1 0 1 29 0 1 4 4.2 1 0 34 0 1 4 4.3 1 1 45 0 1 5 5 1 1 42 1 0 5 5.1 1 1 53 0 1 6 6 1 0 23 1 0 6 6.1 0 0 29 0 1 6 6.2 0 1 36 0 1 7 7 1 1 48 1 0 7 7.1 1 0 23 0 1 8 8 1 0 53 1 0 8 8.1 0 0 54 0 1 8 8.2 1 1 37 0 1 8 8.3 1 1 41 0 1 8 8.4 0 1 26 0 1 I need to calculate: (I highlight the want part in yellow) 1. Both the mother and her daughter or son have fiber everyday: yes or no 2. Both they are female, which mean both mother and her daughter participated in the study: yes or no 3. Count of both have fiber by mother: for example family 4 has 2  4. Count of both are female by mother: for example family 8 has 2 5. Total count of both have fiber in the study: there are 3 mother-kid cases having fiber everyday 6. Total count of both female in the study: it is 6 7. Absolute difference of age between the mother and her daughter or son 8. Number of kids participated in the study by mother 9. Mean of absolute difference of age across all mother-kid cases   The calculation shouldn't be very difficult, but the display of the current dataset stop me from doing those calculation. Can SAS do some calculation by family number?   This is very challenging for me to use SAS.   Thank you very much for any help!   with regards,   ... View more

Hi,   I am having an array of variables day1-day10 (10 variables) including character values there, such as a1, b32, c56, d9876, e298, and f402. I want to create a new variable---important_day. Only when day1 (or day2, day3, or...day10)=f402 then important_day=Yes, when day1 (or day2, day3, or...day10) is anyone else then important_day=No.   Please advice how to use character variables in if then statement in an array in SAS.   Thank you in advance!   with regards, ... View more

Hi SAS Pros,   I want to create a new variable---Apple_Count_by_Name. For example, each day the teach gives students a different type of fruit. If a student receives an apple, then it is a Yes=1, if not, then is No=0. I need to know how many apples a student has from 1/2 to 1/9. Please ignore the absence dates for some students.   What I have" Name Date Fruit Is_it_an_apple Tom 2-Jan apple 1 Tom 3-Jan apple 1 Tom 4-Jan orange 0 Tom 5-Jan pear 0 Tom 6-Jan peach 0 Tom 7-Jan blueberry 0 Tom 8-Jan blueberry 0 Tom 9-Jan apple 1 Mike 2-Jan orange 0 Mike 3-Jan pear 0 Mike 4-Jan apple 1 Mike 5-Jan apple 1 Mike 6-Jan blueberry 0 Megan 2-Jan apple 1 Megan 3-Jan orange 0 Megan 4-Jan pear 0 Lily 2-Jan apple 1 Lily 3-Jan apple 1 Lily 4-Jan blueberry 0 Lily 5-Jan apple 1 Lily 6-Jan orange 0 Lily 7-Jan pear 0   What I want Name Date Fruit Is_it_an_apple Apple_Count_by_Name Tom 2-Jan apple 1 3 Tom 3-Jan apple 1 3 Tom 4-Jan orange 0 3 Tom 5-Jan pear 0 3 Tom 6-Jan peach 0 3 Tom 7-Jan blueberry 0 3 Tom 8-Jan blueberry 0 3 Tom 9-Jan apple 1 3 Mike 2-Jan orange 0 2 Mike 3-Jan pear 0 2 Mike 4-Jan apple 1 2 Mike 5-Jan apple 1 2 Mike 6-Jan blueberry 0 2 Megan 2-Jan apple 1 1 Megan 3-Jan orange 0 1 Megan 4-Jan pear 0 1 Lily 2-Jan apple 1 3 Lily 3-Jan apple 1 3 Lily 4-Jan blueberry 0 3 Lily 5-Jan apple 1 3 Lily 6-Jan orange 0 3 Lily 7-Jan pear 0 3   Thank you in advance for any help with this question!   All the best, ... View more