topic Date spine for cumulative counts in SAS Programming

Date spine for cumulative counts

awmk — Fri, 27 Mar 2015 02:05:07 GMT

hello,

my aim is avg cumulative daily counts of cow births over 5 years. I know how, but my problem is that I want to graph these counts over time and my data set only contains records of cow births/ dates, not all possible dates in the time period. Eg no birth on 2 jan in any of those 5 years =no record for 2 jan. I need a date spine. Is there any way to include all possible dates in a year without typing them all?

THanks

Re: Date spine for cumulative counts

Jagadishkatam — Fri, 27 Mar 2015 03:15:04 GMT

Could you please provide a sample data and the expected output

Thanks,

Jag

Re: Date spine for cumulative counts

ballardw — Fri, 27 Mar 2015 15:29:04 GMT

To create dates is easy:

data dates2012;

do date='01Jan2012'd to '31DEC2012'd by 1;

output;

end;

run;

What type of graph are you attempting to create? Generally any time axis for an entire year would have too many entries for readability. Scatter plots don't care much about missing x axis values and you can generally use a "from date to date by interval" type of description. Series plots may or may not have breaks depending on the procedure and what you want things to look like.

Having done some similar types of cumulative to day of year, you might find looking at Julian Dates are also helpful.