hi Paige! Sorry for everyhting, I accepted your first post cause I did add a mean function and it worked. /*1, tranposer pour avoir une seule ligne par lactation*/
proc sort data=qulac;
by no_ferme cow lac;
run;
proc transpose data=qulac out=qulact prefix=LS_;
var SCC_linear_score;
by no_ferme cow lac;
run;
/*2 calculer une moyenne par lactation*/
data qulact;
set qulact;
lsmean=mean(ls_1, ls_2, ls_3, ls_4, ls_5, ls_6, ls_7, ls_8, ls_9, ls_10, ls_11, ls_12, ls_13);
run; So you have answered my question, thanks again. I was writing a part of my "first" code because I tought that is what you have asked, but obviously it is not... I'm not really familiar with the use of macros and my data are sensitive, but in the future i will try my best to meet your demands. Best regards, Annie
... View more