- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 05-28-2021 07:31 PM
(6104 views)
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.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Or ask DBA create a VIEW with short name for that table . But Tom 's idea is great one.