I'm joining table a with table b using a left join and I want the resultant table to be in the same order that table a was in. However the order seems to be changing to the ascending order of the variable that I used to join on. How can I prevent that from happening? ... View more

Suppose I have the following dataset :   a   b   c 1   1   1 1   2   3 1   3   2 1   4   2 2   4   1 2   3   3   Now if I consider the a=1 group, the last record has c=2. I want to pull the record where c=2 appears in the a=1 group for the first time i.e. 1 3 2. Similarly for the a=2 group, the last record has c=3. Since that is the first time it appears in this group that would be the row to display in that group.   So the output should be  a   b   c 1   3   2 2   3   3   Can someone please help me out with this? I would really appreciate it. ... View more

I have a dataset (have) with columns named as follows: time_period, vol_-1, vol_0, vol_1, vol_1000. I want to create a column that calculates the sum of these values: data want; set have; total_vol = sum(vol_-1, vol_0, vol_1, vol_1000); run; However, since vol_-1 has a special character in it, I am getting an error. How can I get around this problem? ... View more

I have a dataset as follows: data have; input ID ID1 Mark1; datalines; 1 1 . 1 1 76 1 1 67 2 2 . 2 2 32 2 2 45 run; I would like to group by ID and ID1 and extract the first and last non-missing values of mark for each group so that the resultant dataset looks like this: ID   ID1   Mark1First   Mark1Last 1    1       76                  67 2    2       32                  45 ... View more