Export multiple SAS datasets into sheets in one excel file (in SAS University Edition)

[biringstad]

I am trying to export multiple sas datasets (gbotall, vabotall, vxrall) into one sheet each in one xlsx file (wiodvatrd), but I receive the error:

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

I am using the SAS University Edition. So far I have tried with different codes, and below is one of them and parts its log. Do anyone see what I am doing wrong?

Code:

PROC EXPORT DATA= myfolder.GBOTall DBMS=xlsx replace;

sheet= "gbotall";
OUTFILE= "/folders/myfolders/WIODVATRD.xlsx";
RUN;

PROC EXPORT DATA= myfolder.VABOTall DBMS=xlsx replace;
sheet= "vabotall";
OUTFILE= "/folders/myfolders/WIODVATRD.xlsx";
RUN;

PROC EXPORT DATA= myfolder.vxrall dbms=xlsx replace;
sheet= "vxrall";
OUTFILE= "/folders/myfolders/WIODVATRD.xlsx";
RUN;

Log:

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 55        
 56         PROC EXPORT DATA= myfolder.GBOTall DBMS=xlsx replace;
 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
      
 57         sheet= "gbotall";
 58         OUTFILE= "/folders/myfolders/WIODVATRD.xlsx";
 59         RUN;
 60 

Best regards,

Birgitte

[Reeza]

Outfile belongs on the proc export statement. You have it as its own right now.