I created a calendar dataset with one record per day (because a table like that is useful in so many ways) and then I can join to it using start_date and cancel_date.
... View more
You should explain how 'updated_id' is derived, especially since there isn't any visible connection between a new_id of 1 and an updated_id of 2.
... View more
data foo;
x=1;
y=3;
if (x eq 1 and y eq 3) then
do;
a=2;
b=3;
c=7;
end;
else if (x eq 2 and y eq 4) then
do;
a=1;
b=0;
c=4;
end;
else
do;
a=4;
b=5;
c=9;
end;
run;
... View more
