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
Wouldn't your code need to be something like:
select * from connection to teracon
(
select * from ......
);
Wouldn't your code need to be something like:
select * from connection to teracon
(
select * from ......
);
Hi Patrick
You are right
I'm new to this..
Thanks
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.