Proc SQL :Librefs are restricted to eight characters

[RafaelZ]

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       

[Patrick · Accepted solution]

Wouldn't your code need to be something like:

select * from connection to teracon

     (

          select * from ......

     );

[RafaelZ]

Hi Patrick

You are right

I'm new to this..

Thanks