topic Re: export to a specific row/cell in Microsoft Integration with SAS

export to a specific row/cell

mick_g — Thu, 26 May 2011 17:49:38 GMT

can you export data to an excel sheet row or cell something like below

LIBNAME SDF "&sasdir";
PROC EXPORT DATA=SDF.ORDERS
FILE='c:\temp\demo.xlsb'
DBMS=EXCEL REPLACE;
SHEET='Orders';
Row = 10;
column =0;
RUN;

Re: export to a specific row/cell

Cynthia_sas — Thu, 26 May 2011 19:41:41 GMT

Hi:
I believe this paper shows how to export to a "named range" using the LIBNAME engine:
http://www2.sas.com/proceedings/sugi31/024-31.pdf

cynthia

Re: export to a specific row/cell

AshokSas — Mon, 29 Jun 2015 11:56:31 GMT

Hi Cynthia,

can you please give an example with creating a dummy sas dataset which should be exported to excel to particular mentioned row and column numbers under UNIX environment.

Ods tagsets excelxp is not working with start_at option. please help me out this is critical requirement for report creation.

Thanks,

Ashok