DATA Step, Macro, Functions and more

Headskip in SAS ODS excel

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 145
Accepted Solution

Headskip in SAS ODS excel

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


Accepted Solutions
Solution
‎07-17-2017 11:07 AM
Super User
Posts: 9,681

Re: Headskip in SAS ODS excel

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;

View solution in original post


All Replies
Solution
‎07-17-2017 11:07 AM
Super User
Posts: 9,681

Re: Headskip in SAS ODS excel

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;
Frequent Contributor
Posts: 145

Re: Headskip in SAS ODS excel

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

 

 

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 115 views
  • 0 likes
  • 2 in conversation