Help using Base SAS procedures

creating dummy data point

Reply
Frequent Contributor
Posts: 128

creating dummy data point

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?

http://i52.tinypic.com/2ivdxqu.jpg


IMG064.jpg
PROC Star
Posts: 7,360

creating dummy data point

Can you use the approach described in the article at:

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

Respected Advisor
Posts: 3,777

creating dummy data point

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;

Frequent Contributor
Posts: 128

creating dummy data point

Thanks, Art's link works.

Ask a Question
Discussion stats
  • 3 replies
  • 145 views
  • 0 likes
  • 3 in conversation