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
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.