LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page