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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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