topic Re: Multi title in 1row with ods excel and proc odstext in SAS Programming

Multi title in 1row with ods excel and proc odstext

t_ar_taat — Tue, 12 Apr 2022 07:49:45 GMT

Hi,
I want to make more than 1 title (multi title / multi cell) in 1 row with ods excel.
What I want is

only 1 title like this is

ods excel file= "D:\test.xlsx" ;

proc odstext;
  p "A";
run;  
proc print data=sashelp.heart(obs=5);
 var Status;
run;
ods excel close;

For get what I want, I change odstext to

proc odstext;
  p "A" "B" "C";
run;

but it failed like this

667 proc odstext;
668 p "A" "B" "C";
___
22
76
ERROR: Syntax error while parsing WHERE clause.
ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,
CONTAINS, EQ, GE, GT, IN, IS, LE, LIKE, LT, NE, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
669 run;

I'm happy if someone help me.

Re: Multi title in 1row with ods excel and proc odstext

JosvanderVelden — Tue, 12 Apr 2022 09:24:48 GMT

Have you tried the suggestion from Reeza in this post https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Single-Sheet-with-By-Groups/td-p/321793.

Re: Multi title in 1row with ods excel and proc odstext

t_ar_taat — Tue, 12 Apr 2022 09:44:29 GMT

Thank you, but your comment might be for my another question.[ Sheet_Interval='none' ]

https://communities.sas.com/t5/SAS-Programming/ODS-EXCEL-1-sheet-with-multi-proc-step-no-dividng-separating/m-p/807314

Re: Multi title in 1row with ods excel and proc odstext

t_ar_taat — Wed, 13 Apr 2022 01:14:14 GMT

I found a way for this with "declare odsout".
https://www.lexjansen.com/phuse/2014/cs/CS01_ppt.pdf

ods excel file= "D:\test.xlsx" ;

data _null_;
 declare odsout o();
 o.table_start();
 o.row_start();
 o.format_cell(text: 'text 1');
 o.format_cell(text: 'text 2');
 o.row_end();
 o.row_start();
 o.format_cell(text: 'text 3');
 o.format_cell(text: 'text 4');
 o.row_end();
 o.table_end();
 o.delete();
run;

proc print data=sashelp.heart(obs=5);
 var Status;
run;
ods excel close;