@ArseneWenger  My humble suggestion is to proceed with @ballardw simple yet neat approach with one pass and done and that is pretty much what all of us would. But here you go, just for your needs, have fun.- Nonetheless, I would never do this for my work   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 want;     if _N_ = 1 then do;       declare hash h(dataset: 'try', ordered: 'yes',multidata:'yes');       declare hiter iter('h');       h.defineKey('id');       h.defineData('id','status');       h.defineDone();       call missing(id, status);    end;    rc = iter.first();    do while (rc = 0);    if lag(id) ne id then tag=0;    if status=8 then tag=1;    else if status=1 then tag=0;      output;       rc = iter.next();    end;    drop rc; run;   ... View more

If you are fitting ARIMA(0,1,0) , you do not need lagged dependent variable as input variable, PROC ARIMA will do that for you, input variables is for other variables like X1 , X2 rather than autoregression variable. ... View more

IMHO, there is a big difference between adjusting confidence limits (which are probably based derived from an asymptotic normal theory) and adjusting predicted values. If you adjust the predicted values, the model is no longer linear; it becomes piecewise linear (or worse?)   If you don't want to move to a generalized linear model, at least consider whether you can use the NOINT option or RESTRICT statement to restrict the intercept term.    Good luck! ... View more

Your macro variable &my_date must resolve to something like: '11JAN2017:12:34:57'   Looking at picture you've posted, I believe you're missing the single quotes around the date string and the column between yyyy and HH24.   Oh... and reading your initial post again, I also come to realize that you're applying a SAS DateTime format on a SAS Date value. That's why you end up with a year of 1960.   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     On the SAS side: Use format DATE9.  This will give you a string like 11JAN2017   On the Oracle side use something like: where trunc(e.timestamp,'DATE') > to_date(&my_date,'ddmonyyyy')   ....don't forget to wrap the single quotes around the date string value!   https://docs.oracle.com/cd/E29805_01/server.230/es_eql/src/cdfp_analytics_lang_trunc.html   And last but not least: When using SQL pass-through then I'd always first use a native database client to develop the code (i.e. SQL Developer). Only when the code works copy paste it into a SAS pass-through block and add your customizations like SAS macro variables.     ... View more