I wanted to get the current date & time to insert in one of the attributes of ORacle Table.
I tried below 2 options & i am getting default date of SAS.
Option 1 :
data_null_;
RECORD_DATE = compress(put(today(),yymmddn8.)||'-'||Trim(Left(put(time(),time11.2))),':.')
run;
Option2 :
PROC SQL;
INSERT INTO DBMS.&MyTable (RECORD_DATE, Other attributes )
SELECT
DATETIME(),
Other attributes
FROM MANUAL_TEMP B
Both are not working to resolve current date & time.
Thanks,
Ana
I would try something like this with your preferred date/time format,
%let tday = %sysfunc(today(),yymmddn8.);
Or you could get fancy and do something like this to get HMS,
proc format;
picture myfmt low-high = '%Y%0m%0d_%0H%0M%0S' (datatype = datetime) ;
run ;
%let timestamp=%sysfunc(datetime(), myfmt.);
I would try something like this with your preferred date/time format,
%let tday = %sysfunc(today(),yymmddn8.);
Or you could get fancy and do something like this to get HMS,
proc format;
picture myfmt low-high = '%Y%0m%0d_%0H%0M%0S' (datatype = datetime) ;
run ;
%let timestamp=%sysfunc(datetime(), myfmt.);
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.
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.