Desktop productivity for business analysts and programmers

csv file converted to txt file and name changed when emailed

Reply
Occasional Contributor
Posts: 10

csv file converted to txt file and name changed when emailed

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.

PROC Star
Posts: 7,437

csv file converted to txt file and name changed when emailed

Trusted Advisor
Posts: 1,301

csv file converted to txt file and name changed when emailed

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;

Trusted Advisor
Posts: 2,114

csv file converted to txt file and name changed when emailed

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

Ask a Question
Discussion stats
  • 3 replies
  • 146 views
  • 0 likes
  • 4 in conversation