Does EG have the capability of reading CSV files from local drive?
Yes! File->Import Data, then point at your CSV file.
Chris
thanks Chris. Is there an option to write using code?
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
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,
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
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.
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:
Chris
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.