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.);
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.