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
Azurite | Level 17

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
Azurite | Level 17

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

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