Hi SAS Pros,   I have a data set:   ID    Fiber   What_Fiber 1      1         1;2;3;4 2      1         1 3      1         3 4      0         999 5      0         999 6      1         1;2;3;4;8 7      1         1;3;5;7     What I want: ID    Fiber   Fiber_1  Fiber_2 Fiber_3  Fiber_4 Fiber_5  Fiber_missing 1      1         1             1            1           1          0               0 2      1         1             0            0           0          0               0 3      1         0             0            1           0          0               0 4      0         0             0            0           0          0               1 5      0         0             0            0           0          0               1 6      1         1             1            1           1          1               0 7      1         1             0            1           0          1               0   Thank you so much for any help!   Kind regards,   C   ... View more

Hi SAS Pros,   I am going to compare the difference between the responses of some variables and get the difference printed out.   There are a series variables titled fruit1 fruit2 fruit3 fruit4.   This is what I have: Fruit1 Fruit2 Fruit3 Fruit4 apple pear apple apples pear blueberry pears pears banana strawberry avocado Banana avocado grape blueberry avocado grape apple strawberry       grape       date     I want to compare fruit2 fruit3 and fruit4 against fruit1 and print out anyone that fruit1 doesn't have but emerges in fruit2, fruit3, and fruit4. There is no need to compare between fruit2 and fruit3 and etc, only compared with fruit1. Also, the comparison is case sensitive, which means Banana is different from banana.   Want: differences in fruit2 differences in fruit3 differences in fruit4 blueberry pears apples strawberry blueberry pears   strawberry Banana   date     Thank you in advance for any help!!!   Best regards,   C ... View more

Hi SAS experts,   I am having a data set with individuals having multiple office visits   This is what I have: ID        Office_visit_date        Total_visits 1          4/12/2012                    3 1          6/1/2012                      3 1          9/19/2013                    3 2          5/18/2011                    2 2          8/20/2012                    2 3          2/22/2011                    4 3          6/13/2012                    4 3          6/30/2012                    4 3          9/15/2013                    4   What I want is as this: ID        Office_visit_date        Total_visits      First_visit    subsequent_visit   second_visit 1          4/12/2012                    3                         1              0                             0 1          6/1/2012                      3                         0              1                             1 1          9/19/2013                    3                         0              1                             0 2          5/18/2011                    2                         1               0                            0 2          8/20/2012                    2                         0               1                           1 3          2/22/2011                    4                         1               0                            0 3          6/13/2012                    4                         0               1                            1 3          6/30/2012                    4                         0               1                            0 3          9/15/2013                    4                         0               1                            0 Specifically, First_visit, subsequent_visit, and second_visit are the three variables that I want to generate.   Thank you in advance for any help! Kind regards, ... View more

Hi SAS Experts,   I am having a data set like 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   So, I want to create some variables representing for only the information of first observation (which is the information for mothers) of every group (the variable here is family).   What I want is as follows:  New created variables are: whether mother have fiber every day and Mother's age. Basically, the values for these two variables are the values of mothers from each family and repeat as many times as the number of theirs kids participated in the study. So, in this way I can use paired t-test to compare these dependent variables, such as the mother's age and her kids ages or mother's physical activity hours and kids' physical activity hours (not listed here). For comparison of having fiber every day between mothers and their kids, it should use McNemars' test, right? Family ID female Whether Mother have fiber every day Has fiber every day Mother's age age Mother Kids 4 4 1 1 1 25 25 1 0 4 4.1 0 1 1 25 9 0 1 4 4.2 1 1 0 25 4 0 1 4 4.3 1 1 1 25 6 0 1 5 5 1 1 1 42 42 1 0 5 5.1 1 1 1 42 13 0 1 6 6 1 0 0 23 23 1 0 6 6.1 0 0 0 23 2 0 1 6 6.2 0 0 1 23 4 0 1 7 7 1 1 1 48 48 1 0 7 7.1 1 1 0 48 23 0 1 8 8 1 0 0 53 53 1 0 8 8.1 0 0 0 53 27 0 1 8 8.2 1 0 1 53 24 0 1 8 8.3 1 0 1 53 20 0 1 8 8.4 0 0 1 53 16 0 1   Thank you very much!   Kind regards,   C ... View more