Hi   I have following data   Customer     group                  money 1                  Group1                100 1                  Group2                200 2                  Group2                100  2                  Group3                250 2                  Group4                275    I need to create two new variables   the first one looking at  group variable taking the first 1 group once sorted  applied to records by Customer number   Customer     group                  money    new variable 1 1                  Group1                100               Group1 1                  Group2                200               Group1 2                  Group2                100               Group2 2                  Group3                250               Group2   2                  Group4                275               Group2   The second one is again to look at the groups but take the group based on the last money field once sorted     Customer     group                  money    new variable 1    New Varible2 1                  Group1                100               Group1         Group 2      1                  Group2                200               Group1         Group 2   2                  Group2                100               Group2         Group4 2                  Group3                250               Group2         Group4 2                  Group4                275               Group2         Group4     I have tried using Proc Sort then using first function but I am not sure how it works?   Any help would be greatly received.   Thanks   Simon ... View more

I have a stacked bar chart with the following elements  Product A Volume in, Product A Volume Out, Product B Volume in, Product B Volume out  by month.    I also have a variable which is the net position of these varaibles that i would like to add into the chart as a line?   Using SAS V.A  9.3  ... View more