Hello all.   I hve data such as Name              YEAR                Weight Jack                2000                     200 Jack                2001                    205 Jack                2002                    206 Jack                2003                     203 Jack                2004                     209 Jack                2005                     210 John                2000                     200 John               2001                     205 John               2002                     206 John                2003                     203 John               2004                     209 John                2005                     210   How to capture the previous 3 years standard deviation of WEIGHT for each NAME? If previous years only has observation less than 3, it can return 0. I know STD code, but I don't know how to capure the standard deviation for a certain range of time.   This is the data table I want   Name              YEAR                Weight         STD Jack                2000                     200             0 Jack                2001                    205              0 Jack                2002                    206              0 Jack                2003                     203             3.5 (This is a number I make up, but it should be the STD of WEIGHT from 2000 to 2003) Jack                2004                     209             3.4 (Again, this should be the STD of WEIGHT from 2001 to 2004)   Jack                2005                     210             5.2 (Again, this should be the STD of WEIGHT from 2002 to 2005) John                2000                     200 John               2001                     205 John               2002                     206 John                2003                     203 John               2004                     209 John                2005                     210   proc sql; create table want as select *, (select std(WEIGHT) from have where YEAR between a.YEAR-3 and a.YEAR and NAME=a.NAME) as std from have as a; quit; Above is the code I use. But the result shows even for the beginning year, it also has a small standard deviation. That looks weird to me. Because, if it only has one value, and it should have no variation then no standard deviation.   and sub query is also confusing me. Why I cannot just put the condition from year-3 to year using the GROUP BY? Thank you all!   ... View more

Hello all,   Hope you all well.   I have two libraries: 'SuperHero' and 'Height' In library 'SuperHero', it has 1000 datasets with different names, for example, the 1000 datasets name are Bumblebee, Starscream, Batman, Wonderwoman, ...etc   In library 'Height', it has only one dataset, having two variables, one is each dataset's name in 'SuperrHero', another variable is their height, such as Name                 Height Bumblebee           14.8 Starscream           22.5 Batman                 1.86 Wonderwoman      1.72 ....etc   What I would like to do is, add Height variable and value to each file in 'SuperHero' Logic is IF Name variable in 'Height' is the same with dataset's name in 'SuperHero', THEN add Name's corresponding Height to that dataset in 'SuperHero'.   So that, in 'SuperHero', each obs of each dataset has a new variable called Height.   For example, originally, open Bumblebee data in 'SuperHero', it is like this  Age                   Weight 23                          345 24                          349 25                          765   After what we do, open Bumblebee data in 'SuperHero', it will be like this Height             Age                  Weight 14.8                   23                          345 14.8                   24                          349 14.8                   25                          765   Does this need macro? Anyway, what code should I use?   Thank you and keep warm!   ... View more

Hello,   I have a table such as ID           Sales     Year     Sales_classification 1             12         2008              4567 1              11        2008               7890 1              13        2008               5678 1              14        2009               4567 1              15        2009               7890 1               16       2009               5678 2                8       2008               4567 2              1        2008               7890 2              3        2008               5678 2              4        2009               4567 2              5        2009               7890 2               6       2009               5678   Condition includes: IF With the same ID With the same YEAR Sales_classification first digit larger than 6   THEN sum the SALES meet all the conditions above   This may be done with or without CONDITION proc, there may be several ways and logic to do this. Would you please help me with it?   Thank you very much!     ... View more