Hi @mpordon    I think your Sybase interfaces file is pointing to an incorrect server (or there is some other setup problem). There may be missing environment variables. You can try connecting with isql and it will probably give you the same error message.    Here is a snippet from an interfaces file: MYSERVER master tcp ether myserver 5000 query tcp ether myserver 5000 Connecting with isql is a good test because it takes SAS out of the picture.   Link to the SAP doc describing isql   Make sure the environment variables are correct.   SAS 9.4 Configuration Guide for Linux Hope this helps, Jeff ... View more

You want a size 5 window centered on the current observation.   PROC EXPAND is the way to go, assuming you have the sas/ets product. But if you don't, then this program will do:   data have; input week sales promo; cards; 1 792 0 2 271 0 3 490 0 4 1095 0 5 1439 0 6 597 0 7 588 0 8 7078 0 9 612 0 10 555 0 run; data want (drop=leading_value); merge have have (firstobs=3 keep=sales rename=(sales=leading_value)); smoothed_average=ifn(_n_>=3,mean(lag2(sales),lag(sales),sales,lag(leading_value),leading_value),.); if leading_value=. then smoothed_average=.; run;   This program assumes there are no missing values for sales, which  means "if leading_value=. then smoothed_average=.;" statement will prevent unwanted averages at the end of the data set. ... View more

If you are trying to accomplish this in a data step you can simply use a base table that has a record for every state you may have information for. Then simply merge your pop dataset to the base dataset and set null values to 0.     *Your base table of states; proc sql noprint; Create Table StateAbbrevs As Select distinct STATECODE As State From SASHelp.ZipCode; quit; data want; merge StateAbbrevs pop; by State; Loans = coalesce(Loans,0); Amt = coalesce(Amt,0); run; ... View more

Assuming I understand the logic for your last two rows correctly the code below should do what you need.   data want(drop=DIM2_Start); set have; by DIM2 notsorted DIM1 notsorted; retain Amount_Cumulative Counts_Cumulative TXN_Counts DIM2_Start; if First.DIM2 then do; Amount_Cumulative = 0; Counts_Cumulative = 0; TXN_Counts = 0; DIM2_Start = _N_; *Used to track the observation number within each DIM2 value; end; else if First.DIM1 then do; Counts_Cumulative = _N_ - DIM2_Start; TXN_Counts + 1; end; output; Amount_cumulative + amount; run; ... View more