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?
Can you use the approach described in the article at:
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;
Thanks, Art's link works.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.