Date:         Wed, 14 Apr 2004 10:59:39 -0500
Reply-To:     Gary Ross <gary_ross@MGIC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gary Ross <gary_ross@MGIC.COM>
Organization: http://extra.newsguy.com
Subject:      Re: creating CSV dataset on MVS
Content-Type: text/plain; charset=us-ascii

Otherwise, the "ods xml", "type=csv" markup chould work for 8.2 on mvs.
So to support.sas.com, choose the  "documentation" icon in the upper
left and search on "ods csv". The first document gives a good example.

"Choate, Paul@DDS" wrote:
>
> Ravi -
>
> A standard sequential file with whatever width you need will do.
>
> Here's a couple _quickie_ _kludges_ - the first just uses comma separators,
> and the second uses comma and quotes.  They each insert an extra comma to
> start and a blank space after each value, and in the second an extra set of
> quotes.
>
> //CSVEXP    JOB (DSDBX0000T,DS80,20,5,0),PCHOATE,TIME=1,
> //             USER=DSPAULC,MSGCLASS=X,NOTIFY=DSPAULC
> //***************************************************************
> //**>> EXPORT CSV TO NEW SEQ DS
> //***************************************************************
> //STEP1    EXEC HWSAS
> //SYSIN    DD *
>
> FILENAME TEST 'DSPAULC.TEST.CSV' DISP=new LRECL=80;
>
> DATA _NULL_;
>      SET SASHELP.CLASS;
>      FILE TEST;
>      PUT (_ALL_) (',');
> RUN;
>
>    /* or */
>
> DATA _NULL_;
>      SET SASHELP.CLASS;
>      FILE TEST;
>      PUT (_NUMERIC_) (',') @;
>      PUT ',"' @;
>      PUT (_CHARACTER_) ('","')@;
>      PUT '"';
> RUN;
>
> You alternately could use arrays on the _numeric_ and _character_ lists to
> loop through the variables and avoid the extra commas and quotes.
>
> Paul Choate
> DDS Data Extraction
> (916) 654-2160
>
> -----Original Message-----
> From: Ambat Ravi Nair [mailto:ravi04@SINGNET.COM.SG]
> Sent: Tuesday, April 13, 2004 7:50 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: creating CSV dataset on MVS
>
> i'm using SAS/Base 8.2 on OS/390 R10.
> i'd like to create a CSV dataset which i can
> then download to my PC (only IND$FILE available).
>
> 1. what should be the DCB of this dataset ?
> 2. besides the "PUT" method, how else can i
>     create the CSV file ?  using "PUT" to handle
>     many variables is very tiring.
>
> thank you.
>
> - ravi.