topic Re: Error while executing ob.formta_cell in SAS Programming

Error while executing ob.formta_cell

SASdevAnneMarie — Tue, 15 Mar 2022 15:13:19 GMT

Hello Experts,

My code is :

   obj.table_start(overrides: " rules=none frame=void cellpadding=0 cellspacing=0 ");

            obj.row_start();    
            obj.format_cell(data: " Montant  : ", overrides: "just=left color=black font_size=13pt font_weight=normal cellwidth=5cm");
	
            obj.row_end();
            obj.table_end();

I have this error :

79: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 79-322: Expecting a (.
76: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 76-322: Syntax error, statement will be ignored.
NOTE: Error occurred in: just=left color=black font_size=13pt font_weight=normal
NOTE: DATA statement used (Total process time):
real time 0.32 seconds
cpu time 0.31 seconds

But my report is Ok :

I can't find where a (. is missing.

Thank you for your help.

Re: Error while executing ob.formta_cell

FreelanceReinh — Tue, 15 Mar 2022 15:20:27 GMT

Hello @SASdevAnneMarie,

I think the problem is simply that NORMAL is not a valid value of the FONT_WEIGHT style attribute. It is a valid value of the FONT_WIDTH attribute. The "normal" FONT_WEIGHT attribute is called MEDIUM. I didn't know this, but found those details in the documentation Style Attributes Detailed Information.

Re: Error while executing ob.formta_cell

SASdevAnneMarie — Tue, 15 Mar 2022 15:42:32 GMT

Thank you, FreelanceReinhard, that works