SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

export to a specific row/cell

Reply
Contributor
Posts: 37

export to a specific row/cell

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;
SAS Super FREQ
Posts: 8,719

Re: export to a specific row/cell

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
New Contributor
Posts: 2

Re: export to a specific row/cell


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

Ask a Question
Discussion stats
  • 2 replies
  • 4533 views
  • 0 likes
  • 3 in conversation