Hello,   I have 3 key figures and I would like to print with a specifiq format. each figure has an old label (measure_label_from)  and a new label (measure_label_to). what I try to do is to translate the label of the figure by using a format. It works for 2nd and the 3rd figure but NOT for the first. I don't know why. thanks in adance for your help Nasser   Data T_indicateurs ; infile datalines dsd; input figures ~ $50. amount ; datalines ; 'Mont DDT sans cumul M0' , 9999 'Mont LRA sans cumul M0' , 1234 'Taux DDT ECR sans cumul M0' , 0.65 run ; Data T_indicateurs ; Set T_indicateurs ; figures = compress(figures,"'") ; Run ; Data T_indic_transco ; infile datalines dsd; input measure_label_from ~ $50. measure_label_to ~ $50. ; datalines ; 'Mont DDT sans cumul M0' , 'ENTREE MENS DDT&SU' 'Mont LRA sans cumul M0' , 'ENTREE MENS EN RA' 'Taux DDT ECR sans cumul M0' , 'TX DE SORTIE DDT&SU / Encours' run ; Data T_indic_transco_format (Drop = measure_label_from measure_label_to) ; Set T_indic_transco ; Retain FMTNAME '$f_measure_label' ; START = Compress(measure_label_from,"'") ; LABEL = Compress(measure_label_to,"'") ; Run ; Proc format CNTLIN = T_indic_transco_format ; run; proc print data=T_indicateurs ; format figures $f_measure_label. ; run ; please, run this code and you will notice that only the first row is not translated     ... View more

Hello,   by launching this proc report, the column AXE_PRODUIT is repeated as intended but it does not work for column generation and I don't know why. thanks a lot in advance for your help. regard, Nasser PROC REPORT DATA = work.T7_MEASURES_M0 (where=(INDEX(Measure,'sans cumul'))) nowd ; column AXE_PRODUIT GENERATION measure periode_month_M0 , value ; define AXE_PRODUIT / group 'Produit' ; COMPUTE AXE_PRODUIT ; IF AXE_PRODUIT NE '' then hold_axe_produit = AXE_PRODUIT ; IF AXE_PRODUIT EQ '' then AXE_PRODUIT = hold_axe_produit ; ENDCOMP ; define GENERATION / group 'Génération' ; COMPUTE GENERATION ; IF GENERATION NE '' then hold_GENERATION = GENERATION ; IF GENERATION EQ '' then GENERATION = hold_GENERATION ; ENDCOMP ; define measure / group 'Indicateur' ; define periode_month_M0 / across '' ; define value / '' ; compute value ; if INDEX(measure,'Mont') then do ; call define(_COL_,'FORMAT','12.2') ; end; else call define(_COL_,'FORMAT','percent12.9') ; endcomp ; RUN ; ... View more

hello, This is the data set "have".   data have ; informat year_month yymmn6.; format year_month date9.; input year_month monthNum amount ; datalines; 201511 11 110 201512 12 112 201601 1 101 201602 2 102 201603 3 103 201604 4 104 201605 5 105 201606 6 106 201607 7 107 201608 8 108 201609 9 109 201610 10 110 201611 11 111 201612 12 112 201701 1 101 ; run ;     And what I would like is to cumulate the amount like this  : --> for month n° 1, cumulate the last 2 month --> for month n° 2, cumulate the last 3 month --> for month n° 3, cumulate the last 4 month ... ... --> for month n° 12, cumulate the last 13 month ... View more