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
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;
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;
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.