topic Re: ODS Excel control row after embedding image using proc gslide in ODS and Base Reporting

ODS Excel control row after embedding image using proc gslide

SuryaKiran — Fri, 07 Sep 2018 20:37:09 GMT

Hi,

ODS Excel is becoming more commonly used destination for generating native XLSX file. Although there are some bugs, SAS team is working to improve its advantages. I was able to successfully embed image into a sheet before my report. But I was not able to control the space between my image and report. absolute_row_height is applied after the image and not from starting row.

proc template; 
define style styles.background_logo;
parent=styles.Excel;
style header/ 
	fontsize=11pt
	backgroundcolor=cornflowerblue;
end;
run;

title;
footnote;
ods _all_ close;
goptions device=actximg;
ods excel file=xl_out;
ods excel options (	sheet_interval='none' 
					sheet_name="Cover Sheet" 
					start_at="2,2" 
) style=background_logo;

goptions iback="/usr/asmile.jpg"  vsize=2in hsize=2in;	;
proc gslide border;
run;
proc print data=sashelp.class;
run;
ods excel close;

I also tried couple of other options mentioned here Tips for Using the ODS Excel Destination, but this servers me well for my report except that space between.

Using SAS 9.4 M4

Re: ODS Excel control row after embedding image using proc gslide

SuryaKiran — Mon, 10 Sep 2018 14:38:16 GMT

@Cynthia_sas, I know your good at these, any help is appreciated.

Re: ODS Excel control row after embedding image using proc gslide

Cynthia_sas — Mon, 10 Sep 2018 17:58:48 GMT

Hi: I'm not sure the GSLIDE approach will give you the control you want. Take a look at this paper https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf at the approach that starts on page 3. There is a macro program that the paper author is using that allows you to post-process the XLSX file and insert images into specific locations. That might give you the type of control you're looking for. Otherwise, I'd recommend opening a track with Tech Support.

Cynthia

Re: ODS Excel control row after embedding image using proc gslide

SuryaKiran — Mon, 10 Sep 2018 18:44:36 GMT

Thanks, Unfortunately that approach will not work for me since I'm on Linux operating system and can't run x-commands or VB Script. I will open track with SAS Tech support and see what I come up with.

Re: ODS Excel control row after embedding image using proc gslide

SuryaKiran — Mon, 24 Sep 2018 20:20:25 GMT

I opened track with SAS Technical Support and got response on this. Unfortunately this did not have solution for the current versions of SAS and hope it will be fixed in future releases.