Date:         Wed, 30 Jun 2004 15:06:58 -0400
Reply-To:     Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Subject:      Re: Reading desired column 's from CSV FILE

If you have the position numbers, you can use the SCAN function to extract
fields from the _INFILE_ automatic variable. Beware however if there are
text fields containing commas masked by quotation marks.

Example:

   data _null_;
   input @;
   field4 = scan(_infile_,4,',');
   put field4=;
   cards;
   11,"There is no comma here",13,14,15
   21,"Here is a comma: [,]  ",23,24,25
   ;

Result:

   field4=14
   field4=23

On Tue, 29 Jun 2004 23:19:53 +0100, =?iso-8859-1?q?taran=20Singh?=
<taran_jit@YAHOO.COM> wrote:

>Hi folks:
>Can you please provide an insight on how can i read  specific column's
from a csv file . If the struture of the csv file is dynamic .
>I have the column's names.
>
>Thanks in advance
>
>Taran
>
>
>---------------------------------
> ALL-NEW Yahoo! Messenger - sooooo many all-new ways to express yourself