Hello, I am extracting data from a table like this one below and having difficulties with first.[variable] , last.[variable] processing. I need to get first and last observations for each ID&Date together. For instance, for ID=100 I should receive obs 1, 3 as 'first' and obs 2, 6 as 'last'. For ID=101 it should be obs 7, 9 as 'first' and 8, 10 as 'last'. Instead my program reads only the ID variable and returns obs 1 as 'first' and obs 6 as 'last' for ID=100, then obs 7 as 'first' and obs 10 as 'last' for ID=101. Example of my code for 'last': data get_last; set master_table; by ID Date; if last.ID and last.Date then output; run; What am I doing wrong? How to get my first and last observations based on two criteria together? Thank you. obs ID Date Transaction Code Amount 1 100 14-Jul-09 1 345 2 100 14-Jul-09 2 234 3 100 16-Jul-09 1 76 4 100 16-Jul-09 2 234 5 100 16-Jul-09 2 278 6 100 16-Jul-09 2 45 7 101 20-Jul-09 1 7 8 101 20-Jul-09 2 896 9 101 25-Jul-09 1 45 10 101 25-Jul-09 2 23
... View more