topic Re: ERROR 307-185: The data set name cannot have more than 32 bytes. Solution? in SAS Programming

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

mstjean — Fri, 28 May 2021 23:31:54 GMT

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.

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

Tom — Fri, 28 May 2021 23:57:38 GMT

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;

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

Sajid01 — Sat, 29 May 2021 01:17:45 GMT

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/td-p/552491

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

Ksharp — Sat, 29 May 2021 11:27:07 GMT

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