Date: Wed, 28 Jan 1998 09:55:51 -0500
Reply-To: Michael Cadavillo <mcadavillo@HEALTHFIRST.ORG>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Michael Cadavillo <mcadavillo@HEALTHFIRST.ORG>
Subject: DDE from Lotus
Content-Type: text/plain; charset=US-ASCII
Hi! I have some data residing in a lotus worksheet. I would like to
read this data into a temporary SAS data set for further analysis
using the DDE function. I have the file lotus application running and
the lotus file open (vend999.wk4 or vend999.123). In the lotus file I
also created a range name "values". This range name values is the
table I would like to read into the data set vend999.
When I ran the program it said that the filename does not exist even
when I have the file open (I believe this is required). I also
printed a portion of the log below.
Also, is there a specific DDE function for lotus release 4 or 5 (wk4)
and another DDE function for lotus 97 (123)?
Please help and respond to mcadavillo@healthfirst.org. Thanks!
564 filename inf2 dde '123w|r:\mike\1099\123\sched\vend999!values';
565
566 data ven999;
567 infile inf2 dlm='09'x notab missover;
568 informat
569 dummy1 $ 5.
570 vendor $ 15.
571 dummy2 $ 15.
572 vfedtax $ 16.;
573 input
574 vendor $ 15.
575 vfedtax $ 16.;
576
NOTE: Variable DUMMY1 is uninitialized.
NOTE: Variable DUMMY2 is uninitialized.
ERROR: Physical file does not exist,
123w|r:\mike\1099\123\sched\vend999!values.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.VEN999 may be incomplete. When this step
was stopped there were 0 observations and 4 variables.
WARNING: Data set WORK.VEN999 was not replaced because this step was
stopped.
NOTE: The DATA statement used 0.16 seconds.
