Hello all,    I could use your help with some coding.    I have data that I have organized into a panel type dataset. There are multiple organizations in the dataset that are observed each year. I also have a variable in this dataset that has a lot of missing values. For this variable, if it is missing in a given year, I would like to fill in the current year's value with the previous year's value.   However, the previous year's value may also be missing. It may even be missing for several years back when the firm first entered the dataset (e.g., firm enters dataset in 2001, but does not have an observed value on said variable until 2007), in which case I would want the values for 2001-2006 to be changed from missing to zeros. Additionally, a value could appear on the variable when it first enters the dataset, but then be missing for two subsequent years, the value could appear again, and then be missing for next year, and so on. So the missingness is random. To sum up, I would like my variable to take on the value of the last year in which it had a value. if it does not have a value in any of the previous years, I would like it to take on a zero up until it has a value (if ever). I have created a small example below.    Firm ID   Year     Variable                  Transformed to --->        Firm ID   Year     Variable    1             2002        .                                                                    1             2002        0 1             2003        .                                                                    1             2003        0 1             2004        1                                                                   1             2004        1 1             2005        .                                                                    1             2005        1 2             2002        2                                                                   2             2002        2 2             2003        .                                                                    2             2003        2 2             2004        3                                                                   2             2004        3 2             2005        .                                                                    2             2005        3   3             1996        .                                                                    3             1996        0 3             1997        .                                                                    3             1997        0 3             1998        .                                                                    3             1998        0     If I could get some guidance with how to code this, I would really appreciate it! To be honest, I'm not sure where to start with this.    Thanks in advance.        ... View more

Hello all,    I want to data that follows teams across many years of data. I want to calculate both (a) when new members join the team and (b) when members leave the team. For example, if in the year 2007, 2 members are new to the data set that did not exist in the year 2006, I want to count those 2 members. Additionally, if in the year 2007, 1 member is no longer a part of the data set that did exist in the year 2006, I want to count that as well. I have two character variables that I can use to calculate this but I'm unsure of how to write the code, so I'm hoping you can help me.    My data is like so:    TeamID        Year            TeamMemberName(char var)      TeamMemberID(char var) 1                  2006            TimJones                                      11 1                  2006            JoeSmith                                       22 1                  2006            BobBell                                         33 1                  2007            TimJones                                      11 1                  2007            JoeSmith                                       22 1                  2007            JayWatt                                         44 1                  2007            JohnJay                                         55 1                  2008            TimJones                                      11 1                  2008            JoeSmith                                       22 1                  2008            JayWatt                                         44   (except I have the data for many teams)     I want:    TeamID   Year     NumberofNewMembers     NumberthatLeft 1             2007         2                                            1             1             2008         0                                            1         Could someone please advise with the code?   Thanks   ... View more

Hello all,    I'm hoping you can help me with some code to change observations to variables, I have data with a structure like so:    ID     Date   UniqueVal 1        D1         111 1        D2         222 1        D3         333 2        D1         111 2        D2         222 2        D3         333 3        D1         111 3        D2         222 3        D3         333     I want:    ID     D1                 D2                  D3 1     111                 222                 333 2     111                 222                 333 3     111                 222                 333       Hopefully that makes sense. Anyway, thank you in advance for your guidance.  ... View more

Hello all,    I'm looking for code so that I can aggregate a variable across observations by group in a cumulative fashion... See below for desired result:   Unitid       TimePeriod    Variable    DesiredVariable 1                    1                  1                      1 1                    2                  0                      1 1                    3                  0                      1 1                    4                 2                       3  1                    5                  0                      3 2                   1                 0                       0 2                   2                 4                        4 2                   3                  0                      4 2                   4                1                        5  2                   5                 1                       6     If someone could help me out, then you guidance would be greatly appreciated!   Thank you, Rich            ... View more

Hey guys,    Im trying to array some codes that I have that I need to later merge on. The codes are numeric and sometimes use characters to form the code as well (e.g., 111222, 111A11, 222333, 22B044, 22-B11).    The code I'm using is this:      data all.matches2; set all.matches1; array vars{30} match1-match30; obs = _n_; do i = 1 to 30; match = vars{i}; if not missing(match) then output all.matches2; end; drop i match1-match30; run;     However, I get this error message:      76 data all.matches2; 77 set all.matches1; 78 array vars{30} match1-match30; ERROR: All variables in array list must be the same type, i.e., all numeric or character. ERROR: All variables in array list must be the same type, i.e., all numeric or character. ERROR: All variables in array list must be the same type, i.e., all numeric or character. 79 obs = _n_; 80 do i = 1 to 30; 81 match = vars{i}; 82 if not missing(match) then output all.matches2; 83 end; 84 drop i match1-match30; 85 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set ALL.MATCHES2 may be incomplete. When this step was stopped there were 0 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds         What can I do in order to make my code work?    Thanks for your help.      ... View more

Hello everyone,    I'm trying to sum on character variables and I'm trying to think about the best way to approach this goal. Let me sketch the rough structure of my data.    ID       Country    1      United States  1      United States 1      France  1      Canada 2      South Africa 2      Japan  2      Japan  2      Japan 3      United States 3      Canada 3      Canada 3      Canada     I want the output to show me how many of each country appears for each ID, like so : ID   Country       numberofoccurence 1 United States    2 1 Canada            1  1 France             1 2 South Africa     1 2 Japan              3 3 United States  1  3 Canada           3        How can I accomplish this?    As always, thanks for your help.  ... View more