I need exponential smoothed data for a time series. But the output from PROC ESM or PROC FORECAST is forecasted data, I need the observed data after exponential smoothing. How to do that? ... View more

I have a dataset like this: Month  Key 1          x 1          y 1          z       2          y 2          z 3          x 3          y I want a dataset like this: Month  Key   Last_occured_before_month 1          x       0     1          y       0  1          z       0 2          y       0 2          z       0   3          x       1   3          y       0 where the in each month, it will look for last occuring value of that key and wherever that month is found it will keep the differenced value. ... View more

I have a dataset like this: Week   Key  Product  Value 1         AB     TRN       2.4 1         AB     LJL        4.5 1         CD     LJL        3.4 2         AB     HTF       4.5 Now if say in 52 weeks, i have 100 keys. I want to look for those 100 keys in every week, and if its missing, I want to copy the all the last known data for that key to the missing week. Here is a working solution where it retains the key, product combination: But my situation is modified a little bit, I want to retain the combinations only if key is missing in a particular week, and not when key-product combination. ... View more