DATA Step, Macro, Functions and more

Proc Export defauts to bottom of page

Reply
Regular Contributor
Posts: 178

Proc Export defauts to bottom of page

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;

 

 

PROC Star
Posts: 8,146

Re: Proc Export defauts to bottom of page

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

 

Art, CEO, AnalystFinder.com

 

Ask a Question
Discussion stats
  • 1 reply
  • 111 views
  • 0 likes
  • 2 in conversation