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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.