- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 07-30-2024 08:40 AM
(543 views)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
What version of SAS is running on ACXIOM?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
SAS 9.4
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I fixed the issue. I tried proc export out of the remote statements and it worked. thank you.