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.
field4 = scan(_infile_,4,',');
11,"There is no comma here",13,14,15
21,"Here is a comma: [,] ",23,24,25
On Tue, 29 Jun 2004 23:19:53 +0100, =?iso-8859-1?q?taran=20Singh?=
>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
> ALL-NEW Yahoo! Messenger - sooooo many all-new ways to express yourself