Exporting SAS to Excel

From sasCommunity

sasCommunity Forum : sasCommunity - general site feedback : Exporting SAS to Excel

---

By Rlswick on Mon Nov 05, 2007 12:20 pm

I share my SAS with results with other users by exporting to Excel. Recently, I've started receiving the following error in my log when I try to export.

100 PROC EXPORT DATA= WORK.nodefer 101 OUTFILE= "h:\\mailingfiles\\Bechtel_DeferralSegmentation_0_11052007.xls" 102 DBMS=EXCEL REPLACE; 103 SHEET="not_deferring"; 104 RUN;

ERROR: Connect: � ERROR: Error in the LIBNAME statement. Connection Failed. See log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time):

     real time           0.31 seconds
     cpu time            0.14 seconds

I am using a template that I have been using for over a year without problem. I get the same result when I try to export to Excel using the File->Export Data wizard. I can still export a comma delimited file.

Any idea what may be causing this? Thanks.

Private Message | Personal Page | Quote

---

By Prholland on Tue Nov 13, 2007 12:37 pm

Can I ask for some more information?

1. What platform are you running this code on?
2. Has your installed version of SAS changed recently? There were some changes to SAS/ACCESS for PC Files in SAS 9, so you may have to change the DBMS=EXCEL parameter.

......Phil Holland

Private Message | Personal Page | Quote

---

By OwlComputerConsultancy on Thu Sep 25, 2008 4:03 am

I noticed that your file path has H:\\....\\....

I would suggest removing one of the "\\"s where ever two occur.

Private Message | Personal Page | Quote

---

By OwlComputerConsultancy on Thu Sep 25, 2008 4:06 am

After looking at my reply I see that the slashes are duplicated on this page. My response will not be useful to you

Private Message | Personal Page | Quote

---