Date:         Wed, 28 Apr 2004 13:38:07 -0700
Reply-To:     cassell.david@EPAMAIL.EPA.GOV
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV>
Subject:      Re: Is there a system option for OpenVMS SAS version 8 where a
              sas program can create an output file with a file attribute of
              "Stream_LF" so that these external files can be served through an
              Apache WebServer properly?
Content-type: text/plain; charset=US-ASCII

Charles Patridge <charles_s_patridge@PRODIGY.NET> wrote:
> Is there a system option for OpenVMS SAS version 8 where a sas program
can
> create an output file with a file attribute of "Stream_LF" so that
these
> external files can be served through an Apache WebServer properly?
>
> Currently, what happens is when we create a CSV file, the Apache
Webserver
> wants to load the contents of this CSV file into a single cell for
Excel.
> That is, all OBS are treated as a SINGLE record and all the contents
is
> loaded into a single cell within Excel.
>
> To fix this problem, we are able to use an "Convert/FDL" that will
convert
> our current files with "variable length" and "Fortran CC" to
"STREAM_LF"
> formats.
>
> Was hoping we could use a SAS option to do this without having to
modify
> our current application code.
>
> Have not been able to find any such option as yet.

I was going to suggest that you use Perl.  (Oh.  Everyone already knew I
was
going to say that.)  Perl now runs on OpenVMS, and you could probably
use a
Perl one-liner in a SYSTEM() command to change the file attribute.

But I just saw Jack's suggestion, and that seems better.  Go with Jack's
idea
if you can, and fall back on the Perl if needed.

David
--
David Cassell, CSC
Cassell.David@epa.gov
Senior computing specialist
mathematical statistician