topic Re: data logic in SAS Programming

data logic

Almoha — Thu, 08 Nov 2018 19:05:58 GMT

All,

I have the following data structure (see attachment)

Days is calculated as ENDT-STDT+1

and I should be able to create the following data structure i.e. expand the STDT , ENDT interval in to 7 records(# of days ) and populate values in quan variable as follows (10 , 0 , 10 .. upto ENDT)

Thanks in advance

Re: data logic

novinosrin — Thu, 08 Nov 2018 19:22:14 GMT

data have;
input sub stdt :date7.  endt :date7.  quan;
format stdt date7.  endt date7. ;
cards;
111 10feb18 16feb18 10
222 10feb18 15feb18 5
;

data want;
set have(rename=(quan=_q));
call missing(_iorc_);
do stdt=stdt to endt;
endt=stdt;
_iorc_+1;
quan=ifn(mod(_iorc_,2) ne 0, _q,0);
output;
end;
drop _:;
run;