topic Re: Headskip in SAS ODS excel in SAS Programming

Headskip in SAS ODS excel

rakeshvvv — Mon, 17 Jul 2017 13:29:46 GMT

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

Re: Headskip in SAS ODS excel

Ksharp — Mon, 17 Jul 2017 13:46:43 GMT

Here are two options.

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


proc report data=sashelp.class nowd;

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

Re: Headskip in SAS ODS excel

rakeshvvv — Mon, 17 Jul 2017 14:06:20 GMT

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