Help using Base SAS procedures

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

Reply
Occasional Contributor
Posts: 18

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

[ Edited ]

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

Super User
Posts: 17,868

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

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

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