Headskip in SAS ODS excel

[rakeshvvv]

Dear All,

I am using SAS ods to generate an excel file using below code.

ODS EXCEL file="&output_path\contents_memlabel.xls" options(sheet_name="Contents_Memlabel" embedded_titles="yes");

PROC REPORT DATA=CONT_LABEL NOWINDOWS;
TITLE "Dataset Name - Dataset Label - Number of observations - File size";
RUN;

In the output i am getting an empty row in excel after the tile. Can someone help me out with removal empty row after the title.

I would need a HEADSKIP alternative ODS EXCEL.

Thanks in Advance
Rakesh

[Ksharp · Accepted solution]

Here are two options.

1)

ods text='xxxx';
proc report data=sashelp.class nowd;
run;

2)

proc report data=sashelp.class nowd;

compute before _page_;
 line 'xxxx';
endcomp;
run;

[rakeshvvv]

Thanks Sir for the quick reply.... I am using the below option and I am getting additional line after the title. I would not need an extra line after the title and I would need need dataser variables immediately after the title.

Thanks

Rakesh