topic creating dummy data point in SAS Procedures

creating dummy data point

Ken_oy — Tue, 19 Jul 2011 15:37:32 GMT

Trying to create dummy data points for my project. Dots of time 1, 3, 4, 5 are real datapoints, I want to create dummy datapoints for every .5 hour if there is no real datapoint existed (e.g, 0 to 5 by 0.5) .

Question: How to create dummy datapoints as showed in the following curves by using SAS?

creating dummy data point

art297 — Tue, 19 Jul 2011 15:46:56 GMT

Can you use the approach described in the article at:

http://www.ats.ucla.edu/stat/sas/code/fillin_missing.htm

creating dummy data point

data_null__ — Tue, 19 Jul 2011 16:23:34 GMT

This bit of code can be used to fill in the missing obs for time.

I don't understand how to derive values for H. At first I thought it was LOCF but your second graph does not seem to be simple LOCF. Perhaps the link that Art provided is the answer.

data have;

input time h @;

cards;

1 1

3 3

4 2

5 1

;;;;

run;

data time;

if 0 then set have(keep=time);

do time = 0 to 5 by .5;

output;

end;

stop;

run;

proc summary data=have nway classdata=time;

class time;

output out=have idgroup(out(h)=);

run;

proc print;

run;

creating dummy data point

Ken_oy — Tue, 19 Jul 2011 16:29:41 GMT

Thanks, Art's link works.