BookmarkSubscribeRSS Feed
DME790
Pyrite | Level 9

Hi I'm a new user to SAS EG and I'm trying to export my proc summary out to specific worksheet in excel. I have been trying the export:

 

proc export data=work.CLKSuccessfulSummarybyDay

outfile='R:\NAT\SMARTCENT\SMCTRCHOP\GCFTELE\Telephony Performance\Successful_Data\CLK.xlsx'

dbms = xlsx

replace;

run;

 

but I come up with the following error:

 

55 proc export data=work.CLKSuccessfulSummarybyDay

2 The SAS System 08:21 Wednesday, March 23, 2016

56 outfile='R:\NAT\SMARTCENT\SMCTRCHOP\GCFTELE\Telephony Performance\Successful_Data\CLK.xlsx'

57 dbms = xlsx

58 replace;

59

60

61

62 run;

ERROR: Temporary file for XLSX file can not be created ->

/sas/config/dev/comp/Lev3/SASApp-CLK/R:\NAT\SMARTCENT\SMCTRCHOP\GCFTELE\Telephony Performance\Successful_Data\/CLK.$$1. Make sure

the path name is correct and that you have write permission.

 

I have attached the full code. Any help appreciated.

 

Windows 10

 

SAS EG 7.11 64 bit

 

 

Thanks in advance

 

1 REPLY 1
Reeza
Super User

You have a couple of things going on. 

The first is common, you have the output path specified as your local/network drive but your work is actually happening on a server. You need to have the file accessible to the server, either via a drive mapped from the server to your network drive. Or you need to move the Excel file to the server to append in the results and then retrieve it from there. It's probably easier to 

 

If you have SAS Add In for Microsoft Office you can use that to extract the data to the workbook you want. 

 

The second is you want to modify an existing Excel workbook - at one point XLSX engine did not support this. It does now, but it's definitely in the latest versions, so you need to provide what version of SAS you're on.

 

It looks like the latest version does allow this:

http://blogs.sas.com/content/sasdummy/2015/05/20/using-libname-xlsx-to-read-and-write-excel-files/

 

 

 

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2938 views
  • 0 likes
  • 2 in conversation