Data Step

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,040
Accepted Solution

Data Step


Hi,

I was trying to use SET statement to pull data from a dataset.

It says the name is too long . It was named that way in the "apple library "

data WANT;

SET apple. HOSPITALREADMISSIONDATASUMMARYINFORMATION;

WHERE put(accountid,accounts.)="true";

RUN;

THE TABLE IS NAMED LIKE THAT IN sql SERVER AND I AM USING LIBNAME STATEMENT TO CONNECT TO THAT TABLE

ERROR 307-185: The data set name cannot have more than 32 characters.

Could you please help me understand the concept?


Accepted Solutions
Solution
‎06-26-2015 01:28 PM
Super User
Super User
Posts: 6,351

Re: Data Step

The concept is simple. SAS supports table names (and variable names) up to 32 characters long.

If you have a table in your SQL database with a name longer than that then you need to rename it or create a view to it that uses a shorter name.

If you cannot get it renamed then you will need to use passthrouh SQL instead of LIBNAME to reference the table.

proc sql ;

connect using apple;

create table want as select *

from connection to apple

(select * from HOSPITALREADMISSIONDATASUMMARYINFORMATION)

WHERE put(accountid,accounts.)="true";

quit;


View solution in original post


All Replies
Solution
‎06-26-2015 01:28 PM
Super User
Super User
Posts: 6,351

Re: Data Step

The concept is simple. SAS supports table names (and variable names) up to 32 characters long.

If you have a table in your SQL database with a name longer than that then you need to rename it or create a view to it that uses a shorter name.

If you cannot get it renamed then you will need to use passthrouh SQL instead of LIBNAME to reference the table.

proc sql ;

connect using apple;

create table want as select *

from connection to apple

(select * from HOSPITALREADMISSIONDATASUMMARYINFORMATION)

WHERE put(accountid,accounts.)="true";

quit;


☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 172 views
  • 0 likes
  • 2 in conversation