Create SAS view via ODBC

proc sql;
connect to odbc(dsn=dsn_name uid=user_name pwd=password);
create view work.view_name as select
column_name format 2. from connection to odbc(select
column_name
from source_table_name);
disconnect from odbc;
quit;