|Date: ||Fri, 10 Nov 2000 07:30:19 -0600|
|Reply-To: ||"Muzny, Robert V." <MUZNRV@INTEGRIS-HEALTH.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Muzny, Robert V." <MUZNRV@INTEGRIS-HEALTH.COM>|
|Subject: ||Re: SAS Language|
|Content-Type: ||text/plain; charset="iso-8859-1"|
I've had the unfortunate need to do the same thing. After searching various
informats and coming up empty, I contacted tech support. There is not a
numerical format to cover this. What was suggested was reading the data in
as text, searching for the "-" with the index function, and then converting
the character data to numeric. Of course, if the "-" was found then
multiply the numeric by (-1).
data a(keep=numtext chartext);
input chartext $;
if index(chartext,"-") then convert=(-1);
From: michelle_kay@MY-DEJA.COM [mailto:michelle_kay@MY-DEJA.COM]
Sent: Thursday, November 09, 2000 21:10
Subject: SAS Language
I need to import a numeric field into SAS from a flat file that I
downloaded from mainframe system. All negative numbers have the minus
signs in the back of the number instead of in front of the number. How
do I read this and convert it into a correct format?
Thank you for your help.
Sent via Deja.com http://www.deja.com/
Before you buy.