envoyer des mails avec piece jointe / SAS v9.1

**franz2b** · 03/05/2010, 18h39

Bonjour à tous,

j'utilise un code qui est senser tourner, mais une ligne ne passe pas.
Voici mon code :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
proc sql;
     CREATE TABLE MAIL (adress char(50),file char(100)); 
 
     INSERT INTO MAIL (adress, file)
	VALUES ("toto@toto.com","D:\toto\toto.xls");
quit;
 
filename reports email "toto@toto.com";
 
data _null_ ; 
     file reports;
     length adress $ 30 file $ 100;
     set mail;
     put '!EM_TO!' adress;
     put '!EM_SUBJECT! Report for ' file;
     put adress ',';
     put 'Report for ' file '.';
     put '!EM_ATTACH! ('file') ';
     put '!EM_SEND!';
     put '!EM_NEWMSG!';
     put '!EM_ABORT!';
run;

Voici ma log :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
 
NOTE: (E9BX04) SAS 9.1.3 SP 4
 
NOTE: SAS Initialization used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
1        !   proc sql;
2        CREATE TABLE MAIL (adress char(50),	file char(100));
NOTE: Table WORK.MAIL created, with 0 rows and 2 columns.
3          
4        INSERT INTO MAIL (adress, file)
5        VALUES ("toto@toto.com","D:\toto\toto.xls");
NOTE: 1 row was inserted into WORK.MAIL.
6        quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
7          
8       filename reports email "toto@toto.com";
9          
10         		
10       !   data _null_ ;
11         	file reports;
12         	length adress $ 30 file $ 100;
13         	set mail;
14         	put '!EM_TO!' adress;
15         	put '!EM_SUBJECT! Report for ' file;
16         	put adress ',';
17         	put 'Report for ' file '.';
18         	put '!EM_ATTACH! ('file') ';
                    49
NOTE 49-169: The meaning of an identifier after a quoted string may change
in a future SAS release.  Inserting white space between a quoted string and
the succeeding identifier is recommended.
 
19         	put '!EM_SEND!';
20         	put '!EM_NEWMSG!';
21         	put '!EM_ABORT!';
22         	run;
 
NOTE: The file REPORTS is:
      E-Mail Access Device
 
ERROR: Invalid value for the !EM_ATTACH option.
FATAL: Unrecoverable I/O error detected in the execution of the data step program.  Aborted during the EXECUTION phase.
Message sent
      To:          'toto@toto.com
      Cc:          
      Bcc:         
      Subject:     Report for D:\toto\toto.xls
      Attachments: 
NOTE: 4 records were written to the file REPORTS.
      The minimum record length was 31.
      The maximum record length was 78.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set WORK.MAIL.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
1           The SAS System 
            18:31 Monday, May 3, 2010
 
      cpu time            0.01 seconds