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.
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;
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...
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: