Date:         Tue, 30 Jan 2001 17:19:29 GMT
Reply-To:     Charles_S_Patridge@PRODIGY.NET
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Charles Patridge <Charles_S_Patridge@PRODIGY.NET>
Organization: Deja.com
Subject:      Subject: SAS FILENAME V8 in OpenVMS

Subject: SAS FILENAME V8 in OpenVMS

Dennis, Rob and Others,

I ran one of Rob's SAS programs to create a NON-SAS external file and it
worked in both V6.12 and V8.1 without a problem.  I then compared Rob's
method to the one we have been running using "MYEXCEL.sas" macro in our
PMACRO library.

Basically, we use the following two statements to output our SAS
datasets to external files:

   FILENAME OUTFILE &DOWNLOAD LRECL=8000 RECFM=V;
   FILE OUTFILE NOPRINT NOTITLES &MOD;

which works fine in V6.12 but fails in V8.1.


I made a change to a TEST version of "MYEXCEL.sas" to use the following
statement to replace the above two statements:

   FILE &DOWNLOAD LRECL=8000 RECFM=V &MOD;

and this seems to work fine in both V6.12 and V8.1. So, I believe we
have a solution to this important flaw thanks to Rob Russell. I suspect
the FILENAME statement in V8.1 has a problem and maybe this will be
corrected in V8.2 due out at the end of February.


This message will document what needs to be done should V8.2 not resolve
our current use/logic of "MYEXCEL.sas".  Thanks Rob!  It is interesting
that SAS Institute Technical Support did not suggest this when we first
reported our problem back in May 2000.

Charles S Patridge
Corporate Actuarial
The Hartford
Hartford Plaza
HO-GL-140
Phone: 860-547-6644
Email: Charles.Patridge@thehartford.com

--
Charles Patridge - PDPC, Ltd.
172 Monce Road - Burlington, CT 06013 USA
Phone: 860-673-9278 or 860-675-9026
Email: Charles_S_Patridge@prodigy.net - Web: www.sconsig.com


Sent via Deja.com
http://www.deja.com/