Hi, I have changed the dateset into montly frequency. I want to full the missing value into zero. For example, for ID=14593, I like to obtatin the zero value from 2002M06 to 2018M05. for ID=21020, I like to obtain the zero value from 2002M06 to 2015M04. I know I should use proc timesiries. But, I can not figure out the problem. Here is my code. proc timeseries data=return out =return1; by ID day; id month; interval=month align=end format=MONTH. start="2002M06"Y end="Endday"M setmissing=0; var RET; run; ID day Price enday 14593 20160429 -0.00213 20180503 14593 20160531 -0.00116 20180503 14593 20160606 0.001148 20180503 21020 20140226 0.088704 20150412 21020 20140331 -0.03789 20150412 21020 20140430 0.111164 20150412
... View more