Date: Wed, 25 Mar 2009 11:43:42 -0400
Reply-To: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject: Re: Import comma and integer
you can also use the commax format. That one expects a ',' as decimal sign.
x = input("1234,56",commax10.);
Gerhard
On Wed, 25 Mar 2009 10:07:40 -0500, Mary <mlhoward@AVALON.NET> wrote:
>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.
|