topic Does EG have the capability of reading CSV files from local drive? in SAS Enterprise Guide

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

HashimBasheer — Thu, 27 Sep 2012 12:52:33 GMT

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

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

ChrisHemedinger — Thu, 27 Sep 2012 13:23:20 GMT

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

Chris

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

HashimBasheer — Thu, 27 Sep 2012 13:38:02 GMT

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

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

ChrisHemedinger — Thu, 27 Sep 2012 13:42:02 GMT

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

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

Doc_Duke — Thu, 27 Sep 2012 14:15:01 GMT

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,

if the host is Unix, the local admins can set up a tool called 'samba' to be able to link to you c:drive.
If the host is Windows, you might be able to use UNC naming for the linkage.
If the host is a mainframe, about your only option may be FTP.
You can use FTP from the others too.
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

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

steve_citi — Thu, 27 Sep 2012 15:29:50 GMT

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.

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

ChrisHemedinger — Thu, 27 Sep 2012 15:39:42 GMT

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#n0x9m8qzgy67xqn12cs2tq3dvpa3.htm

Chris