Date: Fri, 30 Mar 2007 01:47:47 -0400
Reply-To: Ya Huang <ya.huang@AMYLIN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Ya Huang <ya.huang@AMYLIN.COM>
Subject: Re: Numeric formats....
remove the 12.6 informat, sas will use default best32. to read in.
to show 6 decimal, you need 12.6 FORMAT:
25 data _null_;
26 infile cards;
27 input a b;
28 put a= 12.6 b= 12.6;
29 cards;
a=99.123456 b=98.123456
a=8.000000 b=7.123456
a=7.123456 b=8.000000
a=23.345600 b=100.000000
a=100.000000 b=23.345600
On Thu, 29 Mar 2007 23:48:25 -0400, Nirmal kumar <lazybone2k@GMAIL.COM>
wrote:
>I should have been more specific. The following codes (data in the cards)
>provides a example of my data. The data in the external file has a mix of
>numeric formats like --- real numbers, intergers and floating points. But
in
>the SAS dataset, it has to have 6 decimal points.
>
>data _null_;
>infile cards;
>input a b 12.6;
>put a= b= ;
>cards;
>99.123456 98.123456
>8 7.123456
>7.123456 8
>23.3456 100.000000
>100.000000 23.3456
>;
>run;
>
>I want all the numeric values to have 6 decimal digits.
>
>Thanks.
>
>Cheers,
>Kumar
|