07-17-2017 09:29 AM
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";
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
07-17-2017 10:06 AM
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.
Need further help from the community? Please ask a new question.