Hi all, I have a data set like this one:    var1   var 2         number      aa     x                 1      aa     y                 1       aa     z                 1      bb     t                  2      bb     y                 2      cc                        3      cc                        3      cc                        3 so, the column number is the column that I want to obtain. As you can see, it assigns a number for each of distinct values of var1. could you please help me???? thanks a lot ... View more

Hi everyone, I have a data set, which I want to divide in quin-tiles. I mean, I want to separate 5 equal populated groups based on the value of one of variables. Is there a direct proc for that kind of purpose? Thank you ... View more

Hi All; I have this kind of data set, in which I have multiple observations for each distinct name-date group. as follows:      Name     date          VAR      aaa          2000          1233      aaa          2000          1233      aaa          2000          1233      aaa          2001           3545      aaa          2001          3545      aaa          2001           3545      bbb          2000          1000      bbb           2000          1000      bbb           2001          2000 As it is apparent, the first three observations are the same. However I need to get just one for each name-date group in order to be able to do some statistical calculations with them. . I mean, I need  some thing like this: (In other words, I want the first observation of each group)       NAME    date         var          aaa     2000       1233          aaa     2001       3545          bbb      2000       1000           bbb     2001       2000 I am trying to write it in sql using select distinct. but I am not sure how to write this. Can some one please help me with it? thanks a lot! ... View more

    Hi All, I have a data set of different stocks as follow: permno   year         date           rel day    return          (WANT) a              1972        x-1                   -1     x1              (1+x1)*(1+x2)+(1+x3)           a             1972         x                     0     x2              (1+x1)*(1+x2)+(1+x3) a              1972         x+1                 1      x3              (1+x1)*(1+x2)+(1+x3) a              1972        y-1                  -1     y1               (1+ y1)+(1+y2)+(1+y3) a              1972        y                      0     y2               (1+ y1)+(1+y2)+(1+y3) a              1972        y+1                  1     y3                (1+ y1)+(1+y2)+(1+y3) b              1972        z-1                  -1      xx      b             1972           z                    0       xx b              1972         z+1                1        xx b              1973          s-1                -1       xx b              1973           s                   0      xx b              1973          s+1                1     xx So, what I want to do is to calculate the sum of returns for each permno for each of the windows(from relday=-1 to relday=+1). (that is the WANT variable!) For exmaple I want to calculate for a for 1972 for date x-1 to x+1 : Can anyone help me with that? Thanks a lot in advance. Shayan ... View more

Hi guys, I need to count the number of observations for "each firm" in "each year" to be able to ignore those years with less than (for example) 3 observations. my data set is something like this (and the count column is what I need!) year    permno        count 1               1                  3 1               1                 3 1               1                 3 2               1                  1 3               1                 1 1               2                 1 2               2                 4 2               2                 4     2               2                 4 2               2                 4 3               2                 1 4               2                 1 can any one help me to write this with SQL this, please? (and since I am a newbie in sas, would you please describe it a little ?) Thanks a lot ... View more