Hi All,    I'm trying to rank order transactions by multiple variables. I've tried using the proc rank function but keep running into the ERROR: Data set WORK.TABLE1 is not sorted in ascending sequence.   I have the table properly ordered in the below, but can't seem to get the ranking to work.    Table1 Transactions District_Manager_Name Sales_Associate_Name Month_Num Year_Date 12 John Smith Sally Smith 4 2019 11 John Smith John Roberts 4 2019 10 John Smith Andrew Jones 4 2019 9 John Smith Cam Barry 4 2019 20 John Smith Sally Smith 5 2019 19 John Smith John Roberts 5 2019 18 John Smith Andrew Jones 5 2019 17 John Smith Cam Barry 5 2019 12 Michael Brown Joanne Low 4 2019 11 Michael Brown Jimmy Lary 4 2019 10 Michael Brown Joe King 4 2019 9 Michael Brown Sherry Bowman 4 2019 20 Michael Brown Joanne Low 5 2019 19 Michael Brown Jimmy Lary 5 2019 18 Michael Brown Joe King 5 2019 17 Michael Brown Sherry Bowman 5 2019   Desired Output Rank  Transactions District_Manager_Name Sales_Associate_Name Month_Num Year_Date 1 12 John Smith Sally Smith 4 2019 2 11 John Smith John Roberts 4 2019 3 10 John Smith Andrew Jones 4 2019 4 9 John Smith Cam Barry 4 2019 1 20 John Smith Sally Smith 5 2019 2 19 John Smith John Roberts 5 2019 3 18 John Smith Andrew Jones 5 2019 4 17 John Smith Cam Barry 5 2019 1 12 Michael Brown Joanne Low 4 2019 2 11 Michael Brown Jimmy Lary 4 2019 3 10 Michael Brown Joe King 4 2019 4 9 Michael Brown Sherry Bowman 4 2019 1 20 Michael Brown Joanne Low 5 2019 2 19 Michael Brown Jimmy Lary 5 2019 3 18 Michael Brown Joe King 5 2019 4 17 Michael Brown Sherry Bowman 5 2019 ... View more

Hi all,    I'm trying to create a new table that does 2 things with the dataset.  If the account reaches a cumulative minimum deposit of $500 and In which day the account reached a cumulative minimum deposit of $500. I'm more comfortable with proc sql but can use data step.  Account Deposit_Dt Amount A12345 Day1 100 A12345 Day5 200 A12345 Day10 300 B12346 Day1 50 B12346 Day6 150 B12346 Day16 250 C12347 Day2 500 C12347 Day5 100 C12347 Day19 50 D12348 Day4 200 D12348 Day28 100 Thanks, ... View more