Hello Tom,
Thank you, it works for the names, I don't have anymore the warning message.
I'm trying the suggested code with data _NULL_; set RESULTAT (firstobs=&i obs=&i); , but it doesn't work:
Could you re-explain please how I can "skip making the macro variables and use the actual dataset variables by reading in the observation you want in the data step that is making the object calls." 🙂
Thank you very much!
Best regards,
Marie
proc import
datafile="XXX\Exemple.xlsx"
out=RESULTAT
replace dbms=xlsx;
getnames=yes;
run;
%macro publi;
/*****************************************************/
/*****Narratifs rélatids aus données calculées *******/
/*****************************************************/
OPTION NODATE NONUMBER;
OPTIONS PAPERSIZE=LETTER;
OPTIONS TOPMARGIN=0 in BOTTOMMARGIN=0 in LEFTMARGIN=0 in RIGHTMARGIN=0 in;
ODS NORESULTS;
ODS PDF FILE = "XXX\Doc_&i..pdf" dpi=1800;
ODS ESCAPECHAR = "^";
data _NULL_;
set RESULTAT (firstobs=&i obs=&i);
declare odsout obj();
obj.layout_absolute(overrides :"borderwidth=0");
obj.line(style_attr: "bordercolor=blue", size:'0.8mm');
obj.table_start(name:
"table1",
label: "Notre Première Table",
overrides: "width=19 cm frame=void rules=none" );
obj.row_start();
obj.format_cell(data:
"NOM:" ,
overrides: "font_face=Calibri just=left font_weight=bold color=blue font_size=10pt");
obj.format_cell(data:
quote(PROFILE) ,
overrides: "just=left font_face=Calibri color=black font_size=10pt");
obj.row_end();
obj.row_start();
obj.format_cell(data:
"OBJECTIFS :" , overrides: "font_face=Calibri just=left font_weight=bold color=blue font_size=10pt width=2.5 cm");
obj.format_cell(data:
PROFILE_OBJECTIVES ,overrides: "font_face=Calibri just=left color=black font_size=10pt width=15 cm");
obj.row_end();
obj.table_end();
obj.layout_end();
Run;
ODS PDF CLOSE;
%mend;
%publi;
... View more
