|
Folks, Im new to looking at DDE, and havn't got much idea whats happening here,
only I expected this one to work, ANYONE??
Thanx again and again............
PROG-------------------------
x ' "c:\program files\microsoft office\office\excel" ';
x 'excel.exe';
data _null_;
x=sleep(5);
run;
filename cmds dde 'Excel|System';
filename tester dde 'Excel|U:\xlfiles\[xlspeclimits.xls]IPT1
Specs!R1C4:R62C4';
*data _null_;
* file cmds;
* put '[FILE-OPEN("U:\xlfiles\xlspeclimits.xls")]';
*run;
data _null_;
file tester;
put '[FILE-OPEN('U:\xlfiles\xlspeclimits.xls')]';
run;
data Parameter;
infile tester dlm='09'x notab dsd missover;
length Parameter $17;
input Parameter;
run;
data _null_;
file tester;
put '[save()]';
put '[close()]';
x = sleep(3);
put '[quit()]';
run;
LOG-----------------------------
65 x ' "c:\program files\microsoft office\office\excel" '
65 ! ;
66 x 'excel.exe'
66 ! ;
67 data _null_;
68 x=sleep(5);
69 run;
NOTE: DATA statement used:
real time 5.02 seconds
cpu time 0.00 seconds
70 filename cmds dde 'Excel|System';
71 filename tester dde 'Excel|U:\xlfiles\[xlspeclimits.xls]IPT1
72 Specs!R1C4:R62C4';
73 *data _null_;
74 * file cmds;
75 * put '[FILE-OPEN("U:\xlfiles\xlspeclimits.xls")]';
76 *run;
77 data _null_;
78 file tester;
NOTE: SCL source line.
79 put '[FILE-OPEN('U:\xlfiles\xlspeclimits.xls')]';
-
22
-------
202
ERROR: Invalid variable specification, xlspeclimits.xls. Variable names of the
form X.X must be either FIRST.X or LAST.X.
ERROR: Illegal variable type for I/O statement.
ERROR 22-322: Syntax error, expecting one of the following: a name, an integer
constant, arrayname, #, $, &, (, +, /, //, :, ;, ?, @, @@, OVERPRINT, _ALL_,
_BLANKPAGE_, _ODS_, _PAGE_, ~.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
80 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.01 seconds
81 data Parameter;
82 infile tester dlm='09'x notab dsd missover;
83 length Parameter $17;
84 input Parameter;
85 run;
| 
