About SASdevAnneMarie

SASdevAnneMarie · ‎08-05-2020

Hello experts, I added the code. I can't understand why %sysfunc(quote(%superq(&PROFILE_OBJECTIVES.))) doesn't works and I get the warning: WARNING: Apparent invocation of macro DU not resolved. Thank you!

SASdevAnneMarie · ‎08-05-2020

proc import datafile="XXXXXXX\Exemple.xlsx" out=RESULTAT replace dbms=xlsx; getnames=yes; run; %macro publi; DATA _null_; SET RESULTAT end=eof; IF eof THEN DO; CALL SYMPUT('nombre',put(_N_,8.)); END; run; %do i=1 %to &nombre.; /*****************************************************/ /*****Narratifs rélatids aus données calculées *******/ /*****************************************************/ data _NULL_; set RESULTAT (obs=&i); call symputx('PROFILE',PROFILE_NAME); call symputx('PROFILE_OBJECTIVES',PROFILE_OBJECTIVES); run; OPTION NODATE NONUMBER; OPTIONS PAPERSIZE=LETTER; OPTIONS TOPMARGIN=0 in BOTTOMMARGIN=0 in LEFTMARGIN=0 in RIGHTMARGIN=0 in; ODS NORESULTS; ODS PDF FILE = "XXXXXXXX\Doc_&i..pdf" dpi=1800; ODS ESCAPECHAR = "^"; data _NULL_; 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: %sysfunc(quote(%superq(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; %end; %mend; %publi;

SASdevAnneMarie · ‎08-04-2020

Hello, thank you! %qsysfunc need a put, beacause I get the error: ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, arrayname, (, +, -, INPUT, NOT, PUT, ^, _NEW_, ~. I can't write a put, beacause I have an ods object code: obj.row_start(); obj.format_cell(data: "OBJECTIFS :" , overrides: "font_face=Calibri just=left font_weight=bold color=cx338AFF font_size=10pt width=2.6 cm"); obj.format_cell(data: %sysfunc(quote(%superq(PROFILE))) , overrides: "font_face=Calibri just=left color=black font_size=10pt "); obj.row_end();

SASdevAnneMarie · ‎08-04-2020

Hello Kurt, Thank you for your answer! I didn't understand , %sysfunc(quote(%superq(PROFILE_NAME))) worked in my code for another problem. I can't use %sysfunc?

SASdevAnneMarie · ‎08-04-2020

Thank you!

SASdevAnneMarie · ‎08-04-2020

Thank you! I still have the same warning, my code is: obj.row_start(); obj.format_cell(data: "OBJECTIFS :" , overrides: "font_face=Calibri just=left font_weight=bold color=cx338AFF font_size=10pt width=2.6 cm"); obj.format_cell(data: %sysfunc(quote(%superq(PROFILE))) , overrides: "font_face=Calibri just=left color=black font_size=10pt "); obj.row_end();

SASdevAnneMarie · ‎08-04-2020

I still have the same warning, my code is: obj.row_start(); obj.format_cell(data: "OBJECTIFS :" , overrides: "font_face=Calibri just=left font_weight=bold color=cx338AFF font_size=10pt width=2.6 cm"); obj.format_cell(data: %sysfunc(quote(%superq(PROFILE))) , overrides: "font_face=Calibri just=left color=black font_size=10pt "); obj.row_end();

SASdevAnneMarie · ‎08-04-2020

Hello, I'm trying to resolve the macrovariable &PROFILE that has a text: "ne devra représenter plus de 20 %du profil de gestion". I get the Warning message: WARNING: Apparent invocation of macro DU not resolved. Do you know please how to avoid this message? Thank you very much! Best regards, Marie

SASdevAnneMarie · ‎08-01-2020

Hello experts, I would like to write the hyperlink after the text like: Information: hyperlink But, when I run the code (see below), the result is: Information (a lot of spaces) hyperlink I can't find how to write the text and the adresse in the same line. Thank you for your help! OPTION NODATE NONUMBER; OPTIONS PAPERSIZE=A4; OPTIONS TOPMARGIN=0.5 in BOTTOMMARGIN=0.5 in LEFTMARGIN=0.5 in RIGHTMARGIN=0.5 in; ODS NORESULTS; ODS PDF FILE = "XXXXXX\TEST.pdf" dpi=1800; data _NULL_; set SASHELP.CLASS(obs=1); declare odsout obj(); obj.format_text( data: "Information:", overrides: " just=left color=green font_weight=bold font_size=8pt "); obj.href(data: "Adresse", url: 'https://www.test.fr/', inline_attr:'color=blue'); Run; ODS PDF CLOSE; Best regards, Marie

SASdevAnneMarie · ‎07-31-2020

Hello Chris, Thank you! I get the same warnings while the executing, but I get the pdf file.

SASdevAnneMarie · ‎07-31-2020

Thank you very much! I understood the problem:) Best regards, Marie

SASdevAnneMarie · ‎07-31-2020

OPTION NODATE NONUMBER; OPTIONS PAPERSIZE=A4; OPTIONS TOPMARGIN=0.5 in BOTTOMMARGIN=0.5 in LEFTMARGIN=0.5 in RIGHTMARGIN=0.5 in; ODS NORESULTS; ODS PDF FILE = "XXXXXX\TEST.pdf" dpi=1800; data _NULL_; set SASHELP.CLASS(obs=1); declare odsout obj(); obj.layout_absolute(columns:1 ); obj.line(style_attr: "bordercolor=green", size:'0.8mm'); obj.region(width: "3.5 in",x:"3.5 in",height:"1.2 in",y:"0.2 in" ,style_attr: "bordercolor=cx338AFF"); obj.format_text( data: "Information", overrides: " just=left color=green font_weight=bold font_size=24pt "); obj.region(width: "7.3 in" ,height:"8 in",y:"1.4 in", style_attr: ""); obj.line(style_attr: "bordercolor=green ", size:'0.8mm'); obj.table_start(name: "table1", label: "Notre Première Table", overrides: "width=7.3 in frame=void rules=none" ); obj.row_start(); obj.format_cell(data: "OBJECTIF" , column_span: 2 , overrides: "just=left vjust=middle backgroundcolor=green color=white font_face='Calibri' font_weight=bold font_size=13pt"); obj.row_end(); obj.table_end(); obj.layout_end(); Run; ODS PDF CLOSE; Hello Chris, Thank you for a nice suggestion (I did not notice the "insert SAS code" icon 🙂 Yes, I can use SASHELP.CLASS for this programme. Thank you very much!

SASdevAnneMarie · ‎07-30-2020

Hello experts, I can’t understand why the line and table don’t have the same width (the document is attached). My papersiez iz A: 8.3 x 11.7 inch So, I chosen OPTIONS TOPMARGIN=0.5 in BOTTOMMARGIN=0.5 in LEFTMARGIN=0.5 in RIGHTMARGIN=0.5 in; In obj.region(width: "7.3 in"), I chosen 7.3 (8.3-(0.5+0.5))=7.3 In I have also 7.3: "table1",label: "Notre Première Table", overrides: "width=7.3 My code is: OPTION NODATE NONUMBER; OPTIONS PAPERSIZE=A4; OPTIONS TOPMARGIN=0.5 in BOTTOMMARGIN=0.5 in LEFTMARGIN=0.5 in RIGHTMARGIN=0.5 in; ODS NORESULTS; ODS PDF FILE = "\\XXXXXX\TEST.pdf" dpi=1800; data _NULL_; set RESULTAT_PRFL_FINAL_PP_XL2(obs=1); declare odsout obj(); obj.layout_absolute(columns:1 ); obj.line(style_attr: "bordercolor=green", size:'0.8mm'); obj.region(width: "3.5 in",x:"3.5 in",height:"1.2 in",y:"0.2 in" ,style_attr: "bordercolor=cx338AFF"); obj.format_text( data: "Information", overrides: " just=left color=green font_weight=bold font_size=24pt "); obj.region(width: "7.3 in" ,height:"8 in",y:"1.4 in", style_attr: ""); obj.line(style_attr: "bordercolor=green ", size:'0.8mm'); obj.table_start(name: "table1", label: "Notre Première Table", overrides: "width=7.3 in frame=void rules=none" ); obj.row_start(); obj.format_cell(data: "OBJECTIF" , column_span: 2 , overrides: "just=left vjust=middle backgroundcolor=green color=white font_face='Calibri' font_weight=bold font_size=13pt"); obj.row_end(); obj.table_end(); obj.layout_end(); Run; ODS PDF CLOSE; Thank you very much!

SASdevAnneMarie · ‎07-29-2020

Thank you very much! Does it work if I test &l.^=. (case of non-empty value)?

SASdevAnneMarie · ‎07-29-2020

Hello experts, I'm struggling to get a value from the macro variable with %eval function: %macro test2; data test; k=1; l=.; call symputx('k',k); call symputx('l',l); run; %if %eval(&l.)=. %then %do; %put "TEST MACRO"; %end; %mend; %test2; The error is: ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: . ERROR: The macro TEST2 will stop executing. In fact, I would like to execute the code conditionally (in the case of empty value of numeric macro variable). Thank you very much for your help! Best regards, Marie

Online Status	Offline
Date Last Visited	Sunday

Re: Quarter from date

Quarter from date

Re: proc sql list

proc sql list

Calculating age

Re: Formatting a macro variable

Re: Formatting a macro variable

Formatting a macro variable

Re: Copy the file

Copy the file

Re: Quarter from date

Re: proc sql list

Re: proc sql list

Re: Calculating age

Re: Calculating age

Re: Spaces in prxmatch function

Re: Getting the month name

Re: Spaces in proc odstext

Creating the macro variables with incrementing suffix

Re: Odsout obj() : font Arial

Re: Sign % in text of macro variable

Re: Sign % in text of macro variable

Re: Sign % in text of macro variable

Re: Sign % in text of macro variable

Re: Sign % in text of macro variable

Re: Sign % in text of macro variable

Re: Sign % in text of macro variable

Sign % in text of macro variable

ODS Object hyperlink

Re: SAS ODS table width

Re: Getting the value of a macro variable

Re: SAS ODS table width

SAS ODS table width

Re: Getting the value of a macro variable

Getting the value of a macro variable

SAS Analytics Explorers