topic csv file converted to txt file and name changed when emailed in SAS Enterprise Guide

csv file converted to txt file and name changed when emailed

Chuy — Wed, 22 Feb 2012 21:46:05 GMT

Hi all,

EG 4.305 on Windows XP, server is Linux 64.

I have a Process Flow that uses a SAS data set, SASHELP.CLASSFIT, then exports as a Step In Project as a csv file,

CLASSFIT.csv, which is written to a directory on the Linux server. I then right click the csv file and use Sent To . .. E-mail Recipient as a

Step In Project... When email is recieved the file name and extension are changed. The name is changed to some

cryptic long name and the file extension is now txt.

Is this the intended behavior or is this an issue ?

thanks.

csv file converted to txt file and name changed when emailed

art297 — Wed, 22 Feb 2012 23:34:36 GMT

This may explain it: http://support.sas.com/kb/13/786.html

csv file converted to txt file and name changed when emailed

FriedEgg — Thu, 23 Feb 2012 00:30:37 GMT

When you save the file on the remote server the email step will obsure the file name because of is on a remote system. If you modify the export step to save the file to your local computer the issue will not occur. Alternativly you could choose to program the process yourself and take full control of the operation.

proc export

data=sashelp.classfit

outfile="/tmp/classfit.csv"

dbms=csv;

run;

filename eml email to="someone@work" subject="Here is your file" attach="/tmp/classfit.csv";

data _null_;

file eml;

put 'Email Body';

run;

csv file converted to txt file and name changed when emailed

Doc_Duke — Thu, 23 Feb 2012 16:09:02 GMT

Chuy,

If you have a SAMBA connection to the unix server (essentially treating the unix directories as mapped windows directories), it should work. I don't have any naming problem picking up files attached to a Solaris Unix server.

The email task in EGuide is handled totally by EGuide, it is not sent to the server for processing, so the file needs to be seen as a Windows file, not as a SAS server file.

Doc Muhlbaier

Duke