proc sql;
connect to odbc(dsn="" user="" password="");

create table my_table as
select * from connection to odbc
(
	select top 100 * from dbnm.schnm.tblnm
);
disconnect from odbc;
quit;

proc print data=my_table;
run;