SAS EG 5.1 multistep export for Excel 2010

EIrvin — Tue, 22 Mar 2016 19:13:52 GMT

I have been trying to wrap my mind around why I can't get a proc export to work, and need someone to look over it to see where my error is. I followed a guideline that I have for another export, that is working wonderfully!!

The one that works:

proc export data= sasuser.WORK_QUERY_FOR_BANKCARD_0000

outfile= "G:\FolderName\foldername\SAS Reports\Report name\NO_XREF &now3..xlsx"

DBMS= Excel2010 label ;

run;

The mean one:

proc export data= sasuser.work_query_for_ret_scra_accts;

outfile= "G:\Folder Name\Report Deliverables\RET SCRA Accts &reptmo..xlsx"

DBMS= Excel2010 label ;

run;

This is what the log has for the error:

16 GOPTIONS ACCESSIBLE;

17 %let reptmo=%sysfunc(intnx(month,%sysfunc(today()),-1),AFRDFMY7.);

19 %put what is 1 &reptgmo;

what is 1 Feb2016

21 proc export data= sasuser.work_query_for_ret_scra_accts;

ERROR: FILE= or TABLE= is required and must be specified.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE EXPORT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

I have to export out to my SASUSER first before writing the program that exports the report into Excel 2010 onto a shared drive ... what have I done wrong here?

I ultimately want to play with the scheduler ... another beast I am scared to play with, so that I can "set it and forget it" or at least not worry about it not getting run on a day off!

Any suggestions would be much appreciated!

Thanks in advance.

Re: SAS EG 5.1 multistep export for Excel 2010

ballardw — Tue, 22 Mar 2016 19:13:05 GMT

Is the ; at the end of this line actually there or an artifact of posting to this board?

proc export data= sasuser.work_query_for_ret_scra_accts;

If it is in the code then remove it. Compare it to the one that works and note that the first line does not have ; at the end.

Re: SAS EG 5.1 multistep export for Excel 2010

EIrvin — Tue, 22 Mar 2016 19:15:25 GMT

Thanks Ballardw, sometimes it's the little things that you just look over!

topic SAS EG 5.1 multistep export for Excel 2010 in SAS Enterprise Guide

SAS EG 5.1 multistep export for Excel 2010

Re: SAS EG 5.1 multistep export for Excel 2010

Re: SAS EG 5.1 multistep export for Excel 2010