topic Re: all dates between range in SAS Programming

all dates between range

sam369 — Tue, 16 Feb 2016 02:19:39 GMT

Hi All,

I want to create variable with all the dates between the dates ranges.

for example

have:

id orddt recdt

100 1/5/15 2/3/15

100 1/17/15 3/6/15

......

....

101 ...............

101 ......

want;

1d orddt1 recdt1 dt1 dt2 orddt2 recdt2

100 1/5/15 2/3/15 1/5/15(first orddt)

100 1/5/15 2/3/15 1/6/15

100 1/5/15 2/3/15 1/7/15

100 1/5/15 2/3/15 1/8/15

...................

......................

100 1/5/15 2/3/15 1/17/15 1/17/15( 2nd orddt) 1/17/15 3/6/15

100 1/5/15 2/3/15 1/18/15(upto first recdt) 1/18/15 1/17/15 3/6/15

........................

....................

100 1/5/15 2/3/15 2/2/15

100 1/5/15 2/3/15 2/3/15

100 2/4/15 1/17/15 3/6/15

100 2/5/15 1/17/15 3/6/15

............................

..............................

100 3/6/15(2nd recdt) 1/17/15 3/6/15

my code:

data want;

set have;

by id;

array d[&max] dt1-dt&max.;

do i=1 to &max;

do dt=orddt to recdt;

d[i]=dt;

output;

end;

format dt-dt&max. date9.;

run;

i am missing some thing in my code.

Thanks

Sam

Re: all dates between range

Reeza — Tue, 16 Feb 2016 01:33:09 GMT

Whats the logic behind date2 variable?

Re: all dates between range

sam369 — Tue, 16 Feb 2016 01:37:45 GMT

Same , orddt to recdt

Thanks

Sam

Re: all dates between range

Reeza — Tue, 16 Feb 2016 01:58:38 GMT

That format doesn't make sense to me, in terms of future usage.

The number of overlaps/max could get unwieldy quickly.

Consider using a multistep process

1. Loop from ord to rec date and ouput one record per day per order.
2. Sort by ID, Date
3. Transpose via proc transpose. You may need to add an order var - not sure about this step.

Re: all dates between range

sam369 — Tue, 16 Feb 2016 13:56:28 GMT

Thanks Reeza!!! . I tried the way you suggested, but doesnt work!!! i created a order variable!! still not able to get what i want

Any suggestion will be helpful

Thanks

Sam

Re: all dates between range

Reeza — Tue, 16 Feb 2016 15:28:09 GMT

Post your code and define doesn't work.