BookmarkSubscribeRSS Feed
GenDemo
Quartz | Level 8

We used to have desktop licenses for SAS/PC, and recently moved to a server solution (also PC). And its giving us endless grief. Desktop setups are just so much simpler to work with. We can't import/export files to/from network drives, even with the network drives mapped.
After a while we figured out that we can import, if you use the import step in EG, but not have any code accociated with it. Similarly we can export excel files to the network, but we can't export SAS data files (.sas7bdat) files to the network wit this method. It keeps on giving the error "Unable to export to xxxxxx.sas7bdat. Please ensure the target file is not already open within your project. If so, please close the file and try again."

 

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Not sure entirely what the question is here?  Obviously your missing some key part on your network infrastructure, be that permissions settings, access.  I assume your network is not Windows driven if you can't import/export Office files - if so then you need PCFiles server installed, and use that to read/write as Office is only available on Windows - another is a very long list of reasons not to use Office software of file formats!!  As for what your issues are specifically, not much we can do here, this is a SAS Q&A board, not a system analysis contract work board.  Consult with your IT group, and liase with your SAS representative, they should be able to do a full analysis of what is installed, what you need permissions to, and what drivers need to be present - if anything this should have been done way back in concept stage before anything was installed.

 

To note, network based working has many advantages over desktop based work.

Kurt_Bremser
Super User

Windows has many "features" in its security setup that make use of shares quite difficult; there have been many posts on this problem here.

Have your IT people check that the userid's in question have their permissions to use a network share correctly propagated to the server.

 

Bottom line: it's not a SAS problem, it's a Windows problem. And do not use the crappy Excel file format for data export. Use csv. It's done with a simple data step, and the resulting file can be viewed with any text editor.

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
  • 2 replies
  • 686 views
  • 0 likes
  • 3 in conversation