ERROR 307-185: The data set name cannot have more than 32 bytes. Solution?

[mstjean]

Hi all,

I've encountered the following error "ERROR 307-185: The data set name cannot have more than 32 bytes."

Unfortunately given that I am setting a data set stored in an ODBC database server, I cannot shortened the name of this dataset. Is there anything I can do to load this data without remaining it?

Many thanks.

[Tom]

Use pass thru SQL.

So if you have a libname defined:

libname mylib odbc ..... ;

You can use that to run SQL in the remote database.

proc sql;
connect using mylib;
create table shortname as
select * from connection to mylib
( select * from my_really_long_unreadable_and_unusable_name
);
quit;

[Sajid01]

Please have a look at this forum post. It has a solution for problems like this
https://communities.sas.com/t5/SAS-Data-Management/Table-names-longer-than-32-character-using-ODBC/t... 

[Ksharp]

Or ask DBA create a VIEW with short name for that table . But Tom 's idea is great one.