Please share data as text. (why go to the trouble to type it into Excel and then upload a file when you can just post the SAS code???)
data have;
input NO $ MT_EA jour_mois $ IS_PROTOCOLE $ LP_ETAT_DOSS $ CD_RGA $;
cards;
A020 31413.16204 31/1 1112 VALID FR10
A020 31289.79011 28/2 1112 VALID FR10
A020 31396.92356 31/3 1112 VALID FR10
A020 31406.90669 30/4 1112 VALID FR10
A020 31413.5621 31/5 1112 VALID FR10
A020 31304.2403 30/6 1112 VALID FR10
A020 31390.58766 31/7 1112 VALID FR10
A020 31480.25608 31/8 1112 VALID FR10
A020 31516.72788 30/9 1112 VALID FR10
A020 32580.65359 31/10 1112 VALID FR10
A020 32620.42652 30/11 1112 VALID FR10
A020 33130.84571 31/12 1112 VALID FR10
A020 5000 31/1 1112 VALID FR20
A020 6000 28/2 1112 VALID FR20
A020 6000 31/3 1112 VALID FR20
A020 6000 30/4 1112 VALID FR20
A020 6000 31/5 1112 VALID FR20
A020 6000 30/6 1112 VALID FR20
A020 6000 31/7 1112 VALID FR20
A020 6000 31/8 1112 VALID FR20
A020 6000 30/9 1112 VALID FR20
A020 6000 31/10 1112 VALID FR20
A020 6000 30/11 1112 VALID FR20
A020 6000 31/12 1112 VALID FR20
;
From your output it looks like you just want to transpose ONE variable. But the PROC SUMMARY code you posted was trying to transpose TWO variables.
If you only want to transpose ONE variable then PROC TRANSPOSE will work fine.
proc transpose data=have out=want(drop=_name_) delim=_;
by no;
id cd_rga jour_mois ;
var mt_ea ;
run;
Result:
PS Make sure you have not accidentally set the VALIDVARNAME option to ANY or else those awful slashed in the JOUR_MOIS variable will get inserted into the generated variable names.
options validvarname=v7;
... View more
