Proc Export defauts to bottom of page

Q1983 — Sun, 27 Aug 2017 22:34:09 GMT

The code below exports to a server location. When I open the spreadsheet it defaults to the bottom of the page. Is there a way to programmatically default to home or (cell A2)

PROC EXPORT OUTFILE="\\corp\server1\Folder1\Non_QM_&mToday..xlsb"

DATA= tbl1

DBMS= EXCELCS REPLACE;

SHEET='Data';

SERVER='GA016A744';

quit;

Re: Proc Export defauts to bottom of page

art297 — Sun, 27 Aug 2017 22:51:12 GMT

Do you need to use the xlsb format? Using dbms=xlsx and using an xlsx extenstion defaults at A1.

Art, CEO, AnalystFinder.com

topic Proc Export defauts to bottom of page in SAS Programming

Proc Export defauts to bottom of page

Re: Proc Export defauts to bottom of page