TestMagic

keyreal · 05-18-2008, 09:53 PM

Hello, all!
I have a data set which is supposed to be on a weekly basis. However, not all "weeks" are 7 days long. My goal is to create a new data set from the existing one which has 7-days long week periods (interpolate?) using EXPAND PROC in SAS. I have found some info explaining interpolating irregular observations. It is an example of a sample taken at irregular dates. Does anyone know how to do it with time-frames instead of only time-points? Thanks in advance!

jbs02002 · 05-19-2008, 03:08 AM

You could just use nested do-loops with the "output" statement in a data step to create all the hypothetical 7-day weeks you need, then merge your actual data onto the hypothetical, leaving you with blanks on days when nothing happened.

05-18-2008, 09:53 PM	#1 (permalink)
keyreal Trying to make mom and pop proud Join Date: Dec 2006 Location: chicago Posts: 12	SAS help! Hello, all! I have a data set which is supposed to be on a weekly basis. However, not all "weeks" are 7 days long. My goal is to create a new data set from the existing one which has 7-days long week periods (interpolate?) using EXPAND PROC in SAS. I have found some info explaining interpolating irregular observations. It is an example of a sample taken at irregular dates. Does anyone know how to do it with time-frames instead of only time-points? Thanks in advance!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

05-19-2008, 03:08 AM	#2 (permalink)
jbs02002 Within my grasp! Join Date: Apr 2007 Posts: 171	You could just use nested do-loops with the "output" statement in a data step to create all the hypothetical 7-day weeks you need, then merge your actual data onto the hypothetical, leaving you with blanks on days when nothing happened.

TestMagic

Free GMAT, GRE, SAT Test, TOEFL practice tests