Hello Experts,
I would like to transpose my data and have the name of my variable in colum like this :
My data :
My data wanted :
The idea of my code is :
proc sql noprint;
select max(count) into :ngroups
from (select NO,count(*) as count from FINALE2 group by NO)
;
quit;
proc summary data=FINALE2 ;
by NO;
output out=want idgroup(out[&ngroups] (jour_mois CODE)=);
run;
But I don't have the right result, I think I need to use the proc transpose.
Could you help me please ?
I joinde the data.
... View more