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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.