BookmarkSubscribeRSS Feed
sas_pkc1
Fluorite | Level 6

 Dear Friends,

 

I have one issue in SAS DI, Actually while loading data from LANDING TO STAGE  i am loading datetime on which the record are inserted, but the problem is its not taking the system date its taking 01JAN1960(SAS BIRTH DATE).

 

Please help.

 

Thanks & Regards,

Prashant Chittam.

+91-9075643369.

3 REPLIES 3
JuanS_OCS
Amethyst | Level 16

Dear @sas_pkc1,

 

could you please share the piece of code that is actually loading the dates? That should help us to know where to start from.

 

Thank you in advance,

Juan

sas_pkc1
Fluorite | Level 6

Dear JuanS_OSC,

 

Problem resolved, i used ------%SYSFUNC(DATETIME())------ not its taking today's date.

 

Thanks & Regards,

Prashant 

JuanS_OCS
Amethyst | Level 16

Excellent @sas_pkc1, great to know that you got your problem solved 🙂

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 957 views
  • 2 likes
  • 2 in conversation