SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
HashimBasheer
Fluorite | Level 6

select DATEPART(LATEST) format=DATE9.0
          from connection to TERAVW
                  /* dbms=TERADATA, connect options=(USER='1213144@LDAP' PASSWORD=XXXXX TDPID=dwprod2 CONNECTION=GLOBAL
DBSLICEPARM=(ALL,2) MODE=TERADATA) */
                  ( SELECT MAX(SOR_DTM) AS LATEST FROM test1);

Segmentation Violation In Task [ SQL      ]
tryotcv+0x7c
trget+0x260
fetch+0x644
sqxextr_get_next+0x27c
next_common+0x1a0
sqxslct_get_next+0xa8
sqxslct_open+0x2c8
sqxslct_init+0x140
sqxexec+0x510
process_sql+0xa58
sqlloop+0x1dc
sqlloop+0x38 -- bridge stub
sassql+0x188
vvtentr+0xf0
_uc_trampoline

1 REPLY 1
Tom
Super User Tom
Super User

What makes you think FAST EXPORT is causing that error? Why would SAS even call FAST EXPORT to return a single number?

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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