LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2009, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.


Back to: Top of message | Previous page | Main SAS-L page