Proc SQL :Librefs are restricted to eight characters

RafaelZ — Tue, 07 Jul 2015 07:10:14 GMT

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=;

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

14 GOPTIONS ACCESSIBLE;

15 proc sql;

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

18 (

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

24 order by calendar_date

_____

ERROR 79-322: Expecting a ).

28 );

ERROR 79-322: Expecting a (.

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

30 disconnect from teracon;

NOTE: Statement not executed due to NOEXEC option.

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

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=;

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

43 ODS _ALL_ CLOSE;

46 QUIT; RUN;

Re: Proc SQL :Librefs are restricted to eight characters

Patrick — Tue, 07 Jul 2015 07:35:25 GMT

Wouldn't your code need to be something like:

select * from connection to teracon

(

select * from ......

);

Re: Proc SQL :Librefs are restricted to eight characters

RafaelZ — Tue, 07 Jul 2015 07:46:33 GMT

Hi Patrick

You are right

I'm new to this..

Thanks

topic Re: Proc SQL :Librefs are restricted to eight characters in SAS Enterprise Guide

Proc SQL :Librefs are restricted to eight characters

Re: Proc SQL :Librefs are restricted to eight characters

Re: Proc SQL :Librefs are restricted to eight characters