Copying Excel & CSV files with more than 66K rows

[Ksharp]

If you have SAS9.4 , also check function FCOPY() .

[WilBeach]

Would FCOPY() resolve the "Access Denied" issue?

[Ksharp]

NO. That OS Admin 's thing .

[WilBeach]

I am set up as an Administrator by I don't know what to change. We are a small company where the IT Tech did the install and we are on our own after that.

[ArthurWilliams]

Look in the SASV9*.cfg files for -noxwait and -noxcmd or sas*.bat files (in Windows) and sas*.sh (on Linux or Unix).  if the -noxcmd is changed to -xcmd then the system will allow system command.

[ArthurWilliams]

If your SAS Enterprise Guide session is connected to the local host (PC SAS) you would have permissions to use system command. With server installations of SAS system commands are usually disabled for the users.

You may want to look at this blog as an alternative <http://blogs.sas.com/content/sasdummy/2013/09/17/copy-file-macro/>

[jakarman]

1/ The x cmd usage will return a message that a command had been fired to the OS. It tells nothing about the correctness of the command execution. The pipe command will give more info.   
2/ Running that on a local SAS system there is no xcmd blocking setting as it is your machine on your credentials.  On a server there is commonly that xcmd being blocked as it not your machine and the IT guy. that one not there, is dictating what you can do. That is the default sas configuration setting.  (scripted - metadata).

3/ running local with drive letters is completely different to running on server (other machine other context) all namings will be different whn they are possible.

Do you have all tree of these to overcome?