Here is the description of variables. I did not create them, they were given to me, so I don't have a data step to display.
The variable of importance in this question is CHILD_WEIGHT, as it is the blank characters created in the ODS Excel output that are preventing Excel from reading it as numeric.
Alphabetic List of Variables and Attributes
#
Variable
Type
Len
Format
Informat
Label
2
ch_id
Char
9
$9.
$9.
Child ID
4
ch_subsidy
Char
4
$4.
$4.
ch_subsidy
3
child_weight
Num
8
1
prov_type
Num
3
PROV_TYPE.
Provider type
... View more