Formatting Teradata columns as numeric

[supp]

Hello, I am connecting to a Teradata database. There are columns that I need to be numeric to perform calculations. In Teradata these columns are varchar(50). I have tried the 'dbtype' option with no luck:

LIBNAME teradata teradata server=server USER=user PASSWORD=password schema=schema;

data work.want;
	set teradata.have(dbtype=(COL_1='Numeric(3)'));
run;

The program runs without error but COL_1 is still character, not numeric. I have also tried adding a format statement before the set statement

format COL_1 3.;

But then I get an error that COL_1 has been defined as both numeric and character.

How do I bring in COL_1 as numeric?

[SASKiwi · Accepted solution]

The correct option to use is DBSASTYPE:

https://documentation.sas.com/?docsetId=acreldb&docsetTarget=n0v4ma1zb9lu99n1728j279rjcqi.htm&docset...

DBTYPE is used when creating database tables.

[supp]

Thanks @SASKiwi, this was it! Thanks for the explanation of the two options.

[Kurt_Bremser]

Play the rename/convert/drop game:

data work.want;
set teradata.have(rename=(COL_1=_col_1));
col_1 = input(_col_1, best32.);
drop _col_1;
run;