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 >variables. >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 BMI 8.2 height_in 8.0 height_ft 8.0 Weight_kg 8.2 ; Run ;

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= ;

HTH,

Kevin