Date:         Wed, 25 Mar 2009 10:07:40 -0500
Reply-To:     Mary <mlhoward@avalon.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Import comma and integer
Comments: To: ash007 <RamsamyAshley@GMAIL.COM>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
              reply-type=original

Does it have a comma in EVERY variable?  If so,
you could read it in as two separate character
variables and then concatenate them together-
looks like this would be a character variable.

If it is not in every variable, then you've got a problem-
perhaps go back to the source and write it out with
some other delimeter like a tab (or we always used
to like the ^ above the six because it hardly
ever occurs in the data.   If the data isn't huge,
then you could consider pulling it into Notepad and
doing a find and replace of commas by some other delimiter
where they should be delimiters, but leave the comma in this
variable alone, then import with the new delimiter.

-Mary


----- Original Message -----
From: "ash007" <RamsamyAshley@GMAIL.COM>
To: <SAS-L@LISTSERV.UGA.EDU>
Sent: Wednesday, March 25, 2009 9:53 AM
Subject: Import comma and integer


> Hello,
>
> Is it possible to import to SAS a cvs file which contains a column
> with comma value (-931132,5174) and integer (212369).
>
> Thanks.