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-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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