Hello, I have data that is at a quarterly frequency and I would like to convert it into a monthly frequency, filling in the gaps simply by repeating the observed quarterly value over three months. I thought proc expand could do the trick, but I can not find options that fit what I am trying to do. Any suggestions would be greatly appreciated. HAVE ID Year Quarter XYZ 1 2005 1 100 1 2005 2 175 1 2005 3 216 1 2005 4 257 1 2006 1 304 1 2006 2 345 1 2006 3 347 1 2006 4 456 2 2005 1 235 2 2005 2 210 2 2005 3 277 2 2005 4 400 WANT ID YEAR QUARTER MONTH XYZ 1 2005 1 1 100 1 2005 1 2 100 1 2005 1 3 100 1 2005 2 4 175 1 2005 2 5 175 1 2005 2 6 175 1 2005 3 7 216 1 2005 3 8 216 1 2005 3 9 216 1 2005 4 10 257 1 2005 4 11 257 1 2005 4 12 257 1 2006 1 1 304 1 2006 1 2 304 1 2006 1 3 304 1 2006 2 4 345
... View more