I am trying to write some code that would go by group and row by row and determine if at each row if the current value is the lowest in the group. If so it would keep that value until it either reaches a lower value or gets to the next group. I have tried various retain and lags with if statements but I can't seem to come to the correct way of doing this. Any help is greatly appreciated.   An example of data is below where running_min is the outcome I am looking for: group amount running_min a 10 10 a 9 9 a 9 9 a 8 8 a 7 7 a 6 6 a 5 5 a 9 5 a 10 5 b 100 100 b 20 20 b 35 20 b 45 20 b 10 10 b 50 10   Below is the test data I am working with /* Code for test data */ data test; input group $ amount; cards; a 10 a 9 a 9 a 8 a 7 a 6 a 5 a 9 a 10 b 100 b 20 b 35 b 45 b 10 b 50 ; run; ... View more

I have been loading SAS datasets to tables in Teradata using fastload (an example of code is below) and yesterday I tried to load a table but it gave me an error that I ran out of space. I deleted a big table and tried again and I keep getting an error that says:   "ERROR: Fastload failed the end loading statement: Operation not allowed: [Table Name] is being Loaded."   Where I put [Table Name] it is a table name that isn't exactly the table I am trying to load. Let's say my table name is ThisIsMyTableName, in the error message it is saying ThisIsMyTableNa_SE2_1831116450 is being loaded.   I am guessing when I tried to load the data the first time it created some temporary tables and now it is stuck trying to load those? Any ideas on how I can fix this issue and load the data?  Below is an example of the datastep code I am using to load the data:   data MyDB.ThisIsMyTableName (FASTLOAD=YES TPT=YES DBCOMMIT=0); set work.ThisIsMyTableName; run; ... View more

Is there anyway to run a Holt-Winters Damped method in SAS?  I was using this forecasting methodology in R and it was rather simple but I can't find a way to do it in SAS.  Am I just missing something in the PROC ESM documentation or is it in another proc that I am not aware of? ... View more