Hi, the dataset is panel data.  ... View more

But the new variable is missing value. ... View more

Hi Cynthia,   thanks for your comment. 0 means that this event does not happen in a specific year and Missing value means that this event indeed happened in that year but I cannot tell which category it belongs to due to unavailable information.Does that make sense? Thanks. ... View more

Thank you so much Cynthia! ... View more

I used the Proc Report code offered by Cynthia and also Proc SQL code by Ksharp.    The dataset I have. ID = 4 is missing data. ID        Year           Indicator 1          1991             1 1          1992             0 1          1992             1 2          1993             2 3          1991             0 3          1991             1 4          1991             .   Indicator is a categorical variable. It has three categories (0,1,2). I would like to count the number of each categories for each year for each firm (Panel Data). The expected dataset is following below.   This is the expected dataset. I would like to keep the missing value as missing value rather than 0 ID           Year            No0          No1          No2 1             1991             0               1              0 1             1992             1               1              0  1             1993             0               0              0 2             1991             0               0              0  2             1992             0               0              0  2             1993             0               0              1 3             1991             1               1              0  3             1992             0               0              0  3             1993             0               0              0            4             1991              .                .               . ... View more

There are some missing values in my dataset. I would like to treat these missing value as dot in the dataset rather than treating them as 0. Can you tell me how to do that? Thanks. ... View more

I also found that after I use proc report to run the data, there are four variables _C3_ _C4_ _C5_ _C6_. what is _C6_? ... View more

Thanks. Another question is about missing value. Do missing values affect the count results? Is a missing value counted as 0 or shown as a dot? Thanks. ... View more

Thank you so much, novinosrin!!! ... View more

Thanks! ... View more

Hi PG,   another two questions:   1. I found that the rolling sum includes the last year when I use that code. For example, rolling sum for Year 1994= 1990+1991+1992+1993+1994.    what I want to is rolling sum for Year 1995 = 1990+1991+1992+1993+1994.   Is there any solution for this kind of rolling sum?    2. When I use the following code to remove FUZZ, I found that other value also changed. For example, some value was 1 originally. It changed to be 0 after I applied the following code. Is it the right code?     data a2; set a1; if rolling5<1 then rolling5 = 0; run;     Thanks in advance! ... View more