SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
User_2024
Obsidian | Level 7

Hello, 

I am reading yesterday's output file from the output folder. The file is in excel .xlsx format, as next step, I am comparing today's results, removing duplicates and exporting to the same folder with today's date. My import works fine, I am able to execute the comparison but when trying to download and export data, I encounter the DBMS type XLSX not valid for export. I faced this error before and I solved it but I couldn't figure out now. Suggestions appreciated!

p.s- I tried upper and lower cases too.

rsubmit;
proc export 
data=final_result2
OUTFILE = "myfolder\output\test2_&today..xlsx"
DBMS = xlsx REPLACE;
sheet="list" ;
run;
endrsubmit;
202  proc export
203  data=final_result2
204  OUTFILE = "myfolder\output\test2_&today..xlsx"
205  DBMS = xlsx REPLACE;
ERROR: DBMS type XLSX not valid for export.
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

206  sheet="list";
207  run;
NOTE: Remote submit to ACXIOM complete.
3 REPLIES 3

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 544 views
  • 0 likes
  • 2 in conversation