sasHi I have a question on SAS that I hope you may be able to help. Suppose that I have two SAS files called thismonth and lastmonth. They have the same fields except one of the fields. Here is a snippet of the dataset Thismonth: Contract Number Status Price Code 43211100 300 CA 19180907 500 IF 43121999 1200 CA 54331762 700 IF 54331762 700 IF Lastmonth: Contract Number Status Price Code 17190444 N 600 CA 43211000 I 300 CA 19180907 I 500 IF 54331762 R 700 IF 54331762 R 700 IF So what I need to do is to index the data by both contract number and code first. Then I want to do a lookup on lastmonth. For example. if last month's status is "N" then thismonth's status will be "I". And if last month's status is "R" then this month's status is "N". I'm not sure how indexing works in SAS and would appreciate any help. The real datasets have over 400000 rows in each of the dataset, so I think I have to use indexing in order for this lookup to go faster. Thanks. ... View more

Hi, I have a question on condensing data sets. For example, how do I change this dataset: ID Deposit 1 100 1 150 2 50 2 50 2 50 3 75 Into this: ID Deposit 1 250 2 150 3 75 I am sorting the dataset by ID and I know I might have to use the first. and last. functions, but I'm new to SAS and I can't come up with a solution. Any help would be appreciated. ... View more