Yeah. HaiKuo have already give you answer. Here is my version: data have;
infile cards truncover;
input (start_date end_date) (:ddmmyy10.) (type category) (:$);
format start_date end_date ddmmyy10.;
cards;
1/1/2011 5/1/2011 A 1945
16/1/2011 30/1/2011 B 1945
2/2/2011 3/2/2011 c 1945
4/2/2011 5/2/2011 A 1945
16/1/2011 30/1/2011 B 1945
17/1/2011 25/1/2011 B 1945
;
run;
proc sql noprint;
select distinct cats('type',type,'=(type="',type,'") ;') into :type separated by ' ' from have;
quit;
data want;
set have;
do date = start_date to end_date;
&type
output;
end;
format date ddmmyy10.;
run;
Ksharp
... View more