BookmarkSubscribeRSS Feed
csetzkorn
Lapis Lazuli | Level 10

I have this date format in my target system TeraData:

 

SomeDate DATE FORMAT 'YYYY-MM-DD'

 

I am using this transformation datastep before proc append:

 

data Dataset;
	set Dataset;
	DateCaptured=datepart(SomeDate);	
	format SomeDate DATE9.;
run;

Still getting:

 

A SAS value cannot be converted to a Teradata date

 

Any ideas? Thanks!

 

 

1 REPLY 1
kiranv_
Rhodochrosite | Level 12

looks like somedate is in timestamp and  not a date and you have date field in Teradata. try converting it to date, if you want to insert in as date using sasdatefmt during proc append also helps. below is the example of sasdatefmt dataset option  from sas documentation.

 

proc append base=mydblib.internat (sasdatefmt=(dates='date9.'))
   force data=saslib.delay;
run

 

or

 

 

proc append base=mydblib.internat(sasdatefmt=( date1='datetime21.'))

   force data=saslib.delay;
run

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 3197 views
  • 0 likes
  • 2 in conversation