Hi, I am new to the hash code and I have a data step that I want to convert to hash code to decrease run time ( i have millions of rows). I would appreciate any help to covert same code to hash code.   Here is the logic of my datastep:  I am creating a new variable "tag" which can 1 or 0. If it is my first.ID and value of status is not 8 then 0 else 1 until it hits 1 again. So basically I am retaining the tag value until I hit any other value other than 8.   Example:   data try; input id status; datalines; 1 8 1 .  1 1 1 . 2 8 2 . 2 . 2 . 3 1 3 . 3 8 3 . 4 . 4 . 4 . 5 . 5 . 5 8 5 . ; run;   data try1 ; set try; by id; retain tag 0; if first.id then tag=0; if status=8 then tag=1; if status=1 then tag=0; run;       Output:  id status tag 1 8 1 1 . 1 1 1 0 1 . 0 2 8 1 2 . 1 2 . 1 2 . 1 3 1 0 3 . 0 3 8 1 3 . 1 4 . 0 4 . 0 4 . 0 5 . 0 5 . 0 5 8 1 5 . 1   ... View more

I am trying to introduce AR1 term into my models (lag of dependent variable). It is easy to do for the for the historic period which is lag(y). But I am wondering how to create it for the forecast period (it would actually be the lag of the prediction).  Is ther any SAS procedure or autoreg can do this??  My data looks like:   Date                                    Y                            lag(y)                    X1           X2 …                                          .006                      ….                        12           7 Q1 2016                              .005                      .006                      1             3              Q2 2016                              .004                      .005                      11           7 Q3 2016                              .003                      .004                      8             7 Q4 2016                              .004                      .003                      10           6 Q1 2017                              .                             .004                      12           5 Q2 2017                              .                             .                             11           4 Q3 2017                              .                             .                             10           3 Q4 2017                              .                             .                             11           4 ….   How do I populate lag(Y) for qtr’s Q2 2017 & beyond so that I can use it in regression??   Thanks in advance. ... View more

Is there a way in SAS regression procedures to cap lower bound of predicted values. I would like to know if there is a way or option that can be used to adjust that in the procedure itself.   I have a scenario in which predicted negative values would practically never happen and I want to adjust that in regression itself.   Please let me know if anyone knows a way to handle that. ... View more

Hi,   I am trying to subset oracle dataset on date variable which is numeric and has sas format datetime27.6. for eg. it looks like: 01JAN1960:13:01:01.000000 attached is what i have my code currently..   I am getting error with following query. Please advice correct way of using datetime subset.   Thanks in advance. ... View more