In reply to Ron Cody.

Data abc;
Attrib make length=$1. Format=$1.;
Set sashelp.class.
Stop!
Run

We use this technique to make sure our data match the db2. Create an empty template by retrieving definition from db2, append sas data, insert to database :)