Could someone tell me why this large decrease occurs after Transposing
the data 'tt' ?
NOTE: There were 5820343 observations read from the data set WORK.TT.
NOTE: The data set WORK.TT_OUT has 5431185 observations and 16
proc sql noprint;
create table tt as
select code_number, id, count(*) as count
from local.mydata where id not in('') and code_number not
group by code_number, id ;
proc transpose data = tt out = tt_out;