Hello Experts,   In my xlsx file I have this kind of data :   When I do the proc import, I have this result : Do you know please, how to import the xlsx file in correcte way please to have the correct appearance of amount with % ?   Thank you ! ... View more

Hello Experts,   I create the document with odsout obj(); In my footnote I have : footnote6 J=left font =Arial HEIGHT=7pt '^{style[leftmargin=.6in bottommargin=0.5in]FASV_&Code._v2022042501}'; The macro variable &Code. is resolved in the document, but in foot note I have this : How to appear the macrovariable in footnote ?   Thank you !   ... View more

Hello Experts,   Is it possible to make the ods word document with SAS 8.3 version ? My code is : ods noresults; ods escapechar="^"; footnote4 J=Right font =Arial HEIGHT=8pt '^{thispage}/^{lastpage}'; options orientation=landscape /*topmargin=1.5cm bottommargin=1.5cm*/ leftmargin=1.5 cm rightmargin=1.5cm nodate nonumber; ods word file="&Publications.\ANNEXE_FI_&DatePubli..docx"; proc report data=Resultats split='|' nowd style(report)=[ frame = hsides background = white bordercolor = CX1457D9 borderwidth =.1cm rules=rows just=left] style(header)=[background =white font_size = 8pt font_face = 'Arial' font_weight = bold color=black just = center bordercolor = white] style(column)=[font_size = 8 pt font_face = 'Arial' bordercolor=black color =black just = c]; columns ('Annexe fi' ( "Code ISIN"n "Nom support"n "Société de gestion"n)) ('' ("Performance brute de l'actif N1"n )) ('' ("Frais de gestion de l'actif"n )) ('' ("Performance nette de l'UC"n )) ('' ("Frais de gestion du contrat"n )) ('' ("Performance finale"n )) ( ("Taux de rétrocessions de commiss"n )) ; define "Code ISIN"n / display "Code ISIN" style(header)=[background =CX1457D9 font_size = 8pt font_face = 'Arial' font_weight = medium color=white borderrightcolor =CX1457D9 borderleftcolor =CX1457D9 borderleftwidth=0.6pt just = c]style(column)=[ borderleftcolor=CX1457D9 just = l font_size = 7pt cellwidth=2.5 cm borderleftwidth=0.6pt]; define "Nom support"n / display "Libellé" style(header)=[background =CX1457D9 font_size = 8pt font_face = 'Arial' font_weight = medium color=white just = c borderleftcolor =CX1457D9 borderleftwidth=0.6pt] style(column)=[ borderleftcolor=CX1457D9 just = l font_size = 7pt cellwidth=5 cm borderleftwidth=0.6pt]; define "Société de gestion"n / display "Société de gestion" style(header)=[background =CX1457D9 font_size = 8pt font_face = 'Arial' font_weight = medium color=white just = c borderleftcolor =CX1457D9 borderleftwidth=0.6pt] style(column)=[ borderleftcolor=CX1457D9 just = l font_size = 7pt cellwidth=5 cm borderleftwidth=0.6pt]; define "Performance brute de l'actif N1"n / display "Performance brute|de l'actif N1|(A)" style(header)=[background =CX1457D9 font_size = 8pt font_face = 'Arial' font_weight = medium color=white just = c borderleftcolor =CX1457D9 borderleftwidth=0.6pt] style(column)=[ borderleftcolor=CX1457D9 just = r font_size = 7pt cellwidth=2 cm borderleftwidth=0.6pt]; define "Frais de gestion de l'actif"n / display "Frais de gestion|de l'actif|(B)" style(header)=[background =CX1457D9 font_size = 8pt font_face = 'Arial' font_weight = medium color=white just = c borderleftcolor =CX1457D9 borderleftwidth=0.6pt] style(column)=[ borderleftcolor=CX1457D9 just = r font_size = 7pt cellwidth=2 cm borderleftwidth=0.6pt]; define "Performance nette de l'UC"n / display "Performance nette|de l'unité de compte N-1|(A-B)" style(header)=[background =CX1457D9 font_size = 8pt font_face = 'Arial' font_weight = medium color=white just = c borderleftcolor =CX1457D9 borderleftwidth=0.6pt] style(column)=[ borderleftcolor=CX1457D9 just = r font_size = 7pt cellwidth=2 cm borderleftwidth=0.6pt]; define "Frais de gestion du contrat"n / display "Frais de gestion|du contrat**|(C)" style(header)=[background =CX1457D9 font_size = 8pt font_face = 'Arial' font_weight = medium color=white just = c borderleftcolor =CX1457D9 borderleftwidth=0.6pt] style(column)=[ borderleftcolor=CX1457D9 just = r font_size = 7pt cellwidth=2 cm borderleftwidth=0.6pt]; define "Performance finale"n / display "Performance|finale|(A-B-C)" style(header)=[background =CX1457D9 font_size = 8pt font_face = 'Arial' font_weight = medium color=white borderleftcolor =CX1457D9 just = c borderleftwidth=0.6pt] style(column)=[ borderleftcolor=CX1457D9 just = r font_size = 7pt cellwidth=2 cm borderleftwidth=0.6pt]; define "Taux de rétrocessions de commiss"n / display "Taux de rétrocessions|de commissions" style(header)=[background =CX1457D9 font_size = 8pt font_face = 'Arial' font_weight = medium color=white borderrightcolor =CX1457D9 just = c borderrightwidth=0.6pt just = c borderleftcolor =CX1457D9] style(column)=[ borderleftcolor=CX1457D9 borderrightcolor=CX1457D9 just = r borderrightwidth=0.6pt borderleftwidth=0.6pt font_size = 7pt cellwidth=2.2 cm]; run; ods word close; The data is joined.  I have no error but I can't open the file :     Thank you for the help !     ... View more