Desktop productivity for business analysts and programmers

Proc SQL :Librefs are restricted to eight characters

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Proc SQL :Librefs are restricted to eight characters

Hi.


I'm using passthrough sql to fetch data from

sys_calendar.calendar in teradata.

and i get the error

ERROR: Librefs are restricted to eight characters. sys_calendar has been truncated.

How can i bypass this?


Thanks

Rafael




1                                                          The SAS System                                09:42 Tuesday, July 7, 2015

1          ;*';*";*/;quit;run;

2          OPTIONS PAGENO=MIN;

3          %LET _CLIENTTASKLABEL='Program5';

4          %LET _CLIENTPROJECTPATH='I:\מערכות מידע\SAS\Rafael\Main\Main222.egp';

5          %LET _CLIENTPROJECTNAME='Main222.egp';

6          %LET _SASPROGRAMFILE=;

7        

8          ODS _ALL_ CLOSE;

9          OPTIONS DEV=ACTIVEX;

10         GOPTIONS XPIXELS=0 YPIXELS=0;

11         FILENAME EGSR TEMP;

12         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue

12       ! STYLESHEET=(URL="file:///C:/SASHome/SASEnterpriseGuide/5.1/Styles/HtmlBlue.css") NOGTITLE NOGFOOTNOTE

12       ! GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on");

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR

13       

14         GOPTIONS ACCESSIBLE;

15         proc sql;

16         connect to teradata as teracon (server=DWPROD  schema=DWP_VALL mode=teradata);

17       

18         (

19       

20         select *

21         from sys_calendar.calendar calendar

ERROR: Librefs are restricted to eight characters. sys_calendar has been truncated.

22         where calendar.calendar_date between date-100 and date

23       

24         order by calendar_date

           _____

           79

ERROR 79-322: Expecting a ).

25       

26       

27       

28         );

           _

           79

ERROR 79-322: Expecting a (.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

29       

30           disconnect from teracon;

NOTE: Statement not executed due to NOEXEC option.

31       

32           quit;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

      real time           3.33 seconds

      cpu time            0.01 seconds

    

33       

34       

35       

36         GOPTIONS NOACCESSIBLE;

37         %LET _CLIENTTASKLABEL=;

2                                                          The SAS System                                09:42 Tuesday, July 7, 2015

38         %LET _CLIENTPROJECTPATH=;

39         %LET _CLIENTPROJECTNAME=;

40         %LET _SASPROGRAMFILE=;

41       

42         ;*';*";*/;quit;run;

43         ODS _ALL_ CLOSE;

44       

45       

46         QUIT; RUN;

47       


Accepted Solutions
Solution
‎07-07-2015 03:35 AM
Respected Advisor
Posts: 3,828

Re: Proc SQL :Librefs are restricted to eight characters

Wouldn't your code need to be something like:

select * from connection to teracon

     (

          select * from ......

     );

View solution in original post


All Replies
Solution
‎07-07-2015 03:35 AM
Respected Advisor
Posts: 3,828

Re: Proc SQL :Librefs are restricted to eight characters

Wouldn't your code need to be something like:

select * from connection to teracon

     (

          select * from ......

     );

Occasional Contributor
Posts: 14

Re: Proc SQL :Librefs are restricted to eight characters

Hi Patrick

You are right Smiley Happy

I'm new to this..

Thanks

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 3214 views
  • 0 likes
  • 2 in conversation