Does EG have the capability of reading CSV files from local drive?

[HashimBasheer]

Does EG have the capability of reading CSV files from local drive?

[ChrisHemedinger]

Yes!  File->Import Data, then point at your CSV file.

Chris

[HashimBasheer]

thanks Chris. Is there an option to write using code?

[ChrisHemedinger]

Ah, no.  At least, not unless your SAS session can access the files on your desktop.  You would need to be able to create a FILENAME statement that pointed to your local file.  If your SAS session is a remote machine, that can present a challenge.

Chris

[Doc_Duke]

As Chris says, it can present a challenge.  And the sort of challenge depends, in part, on the host system and local policies.

For instance,

1. if the host is Unix, the local admins can set up a tool called 'samba' to be able to link to you c:drive.
2. If the host is Windows, you might be able to use UNC naming for the linkage.
3. If the host is a mainframe, about your only option may be FTP.
4. You can use FTP from the others too.
5. If you have SAS on your workstation and on a server, you could use SAS/Connect (I think, I've never tried that one).

However, all of them require the assistance and/or 'blessing' of the local admins.  For instance, I can do 1 and 2, but not 4 (local policy forbids FTP hosting from a workstation).

Doc Muhlbaier

Duke

[steve_citi]

For years I was able to use the "SAS PC File Server" which is a small utility you can load via CD onto your machine which makes it look like a server.  Once that is done, you can performa PROC EXPORT/IMPORRT (with some small adjustments needed) to any drive know to your desktop, even if they are remote windows servers.  As long as they have been defined as a drive letter (i.e. G:\) they are accessible.  It is a phonomenally easy way to perform this task.

Sadly, i lost this functionality when we moved to sas 9.2, since I could not find a SAS 9.2 version of the File Server.

[ChrisHemedinger]

PC Files Server is alive and well, and serves an essential role for bridging 32-bit data providers with 64-bit SAS:

Blog post here:

How do I export from SAS to Excel files: Let me count the ways - The SAS Dummy

Doc here:

http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n0x9m8qzgy67xqn12c...

Chris