|Date: ||Fri, 5 Feb 2010 11:58:41 -0500|
|Reply-To: ||Kevin Viel <citam.sasl@GMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Kevin Viel <citam.sasl@GMAIL.COM>|
|Subject: ||Re: Access MsAccess data|
On Tue, 2 Feb 2010 16:09:55 -0800, Ching <kcwong5@GMAIL.COM> wrote:
>At this stage, I just used the round command to those problematic
>Was wondering if there is any quicker way to address this problem.
I would not use round at all. Do not voluntarily lose data (precision).
Most of the time, this is false precision, since the measurement tool does
not likely have that level of precision, but this is an issue almost
complete brushed under the statitical rugs.
I would wager that you have not short cut but to list *all* of the
variables and their *FORMATs*.
Data PERM.One ;
Set ODBC.Access_one ;
Format age 8.1
Remember FORMATs only affect the way the data are displayed. You may be
very wise to use something like:
If Round( height_in , 0 ) > 12 Then Put "Inch error " ID= height_in= ;