home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!gatech!asuvax!lll-winken!miguel.llnl.gov!macq
- From: macq@miguel.llnl.gov (Don MacQueen)
- Newsgroups: bit.listserv.sas-l
- Subject: Re: Comma delimited output file from SAS on MVS/ESA
- Message-ID: <131968@lll-winken.LLNL.GOV>
- Date: 30 Jul 92 21:22:04 GMT
- References: <9207301512.AA21510@espresso.bcs.eca>
- Sender: usenet@lll-winken.LLNL.GOV
- Organization: Lawrence Livermore National Laboratory
- Lines: 55
- Nntp-Posting-Host: miguel.llnl.gov
-
- In article <9207301512.AA21510@espresso.bcs.eca>, oldenkmp@ESPRESSO.BOEING.COM (P. Oldenkamp 5-4481) writes:
- |> ----------------------------------------------------------------------
- |> CONTENT: Comment
- |> SUMMARY: SI to have SAS/ACCESS product for PC file formats.
- |> REL/PLTF: 6.07.02/SunOS 6.06/MVS 6.06/CMS 6.04/PC-DOS
- |> E-ADDR: oldenkmp@ESPRESSO.boeing.com
- |> NAME: Paul OldenKamp
- |> PHONE: 206-865-4481
- |> ----------------------------------------------------------------------
- |> Simon Dunkley commented on Kevin's complaint:
- |>
- |> > Kevin Nechodom <knechod@EDU.UTAH.MED.STACC> writes:
- |> > > Finally, to voice an old complaint, it would be nice if the standard
- |> > > implementation of SAS included 'standard' (in quotes in deference to
- |> > > those who actually measure and evaluate such standards) file formats,
- |> > > like CSV, DBF, DIF, etc. With the proliferation of UN*X workstations
- |> > > and the migratation of DOS programs like dBase to those workstations,
- |> > > the need is becoming greater!
- |> > >
- |> > What about proc dbf and proc dif?
- |>
- |> They don't exist in releases beyond 6.04. At a marketing 'seminar' last
- |> week the regional marketing manager announced that SI has decided to offer
- |> a SAS/ACCESS product for popular PC file structures(dbf, dif, etc.) under
- |> OS/2. In response to a question, she said that no decision had been made
- |> on Windows 3.1.
- |>
- |> It occures to me that with SAS/TOOLKIT third parties could meet the need
- |> and sell it independently of SI. Wow, competition in SAS Software!!!
- |>
-
- In my opinion what is needed is a DELIMITER= option for the FILE statement,
- analagous to the same option for the INFILE statement. This option would
- put the chosen delimiter between each variable named in a PUT statement,
- with no extra spaces, and using the usual default formats. Or user
- specified formats. Then people who wanted tab or comma delimiters could
- do something as simple as:
-
- data _null_;
- set whatever;
- file 'outfile.dat' delimiter=',';
- put x y z;
- run;
-
- And get exactly what they want. No fuss, no muss, no macros, no
- SAS/ACCESS, no SAS/TOOLKIT and having to buy extra software.
-
- What could be simpler?
- --
- ---------------------------------------------------
- Don MacQueen macq@miguel.llnl.gov
- Lawrence Livermore Nat. Lab.
- 7000 East Ave., L-307 (510) 423-1062
- Livermore, CA 94550
- ---------------------------------------------------
-