topic Re: filename mail email PUT with unix varaible in SAS Programming

filename mail email PUT with unix varaible

Nasser_DRMCP — Mon, 10 Dec 2018 11:41:33 GMT

data _null_;
filename mail email 
to=(&mv_email_destinataire_list) 
from="SAS"		
subject="Export file";
file mail;
put "hello, please find enclosed the file";
PUT "link= \\\ukipu004.dummy-website.fr\cdg\Export_files\result.xls";
run;

Hello,

by launching this code, it works. I mean, in the reveived email, by clicking on the link, the file is found and opened.

however I 've got a unix variable $GRPFPU that contains ukipu004.dummy-website.fr\cdg

so I try to launch with this line ==>PUT "link= \\\$GRPFPU\Export_files\result.xls";

but the email contains \\\$GRPFPU\Export_files\result.xls instead of \\\ukipu004.dummy-website.fr\cdg\Export_files\result.xls then this link doesn't work.

thanks a lot in adavance for your help

Nasser

Re: filename mail email PUT with unix varaible

Kurt_Bremser — Mon, 10 Dec 2018 12:40:53 GMT

UNIX environment variables are not automatically imported into SAS. Exceptions: environment variables that contain a path to a directory or to a file are automatically used as librefs or filerefs, respectively.

To create a macro variable from a UNIX environment variable, use the %sysget() function:

data _null_;
filename mail email 
to=(&mv_email_destinataire_list) 
from="SAS"		
subject="Export file";
file mail;
put "hello, please find enclosed the file";
PUT "link= \\\%sysget(GRPFPU)\Export_files\result.xls";
run;

To be more specific, I'd incorporate the protocol and proper UNIX-style syntax:

put "link= https://%sysget(GRPFPU)/Export_files/result.xls";

Replace https with whatever you're using to access the file.

Re: filename mail email PUT with unix varaible

Nasser_DRMCP — Mon, 10 Dec 2018 13:08:39 GMT

thnaks a mot Kurt. It works as attended. evenf if the link is a littl weird with "\" and "/" like this :

lien= \\\/ukipu004.dummy-website.fr\folst\Export_files\result.xls