Thanks a lot for writing me! So, this is how I'm creating table:
proc sql;
create table table_name (CUSTOMER_NUMBER varchar(20) not null, ACCOUNT_NUMBER varchar(35), CARD_NUMBER varchar(19), CAMPAIGN_ID varchar(20) not null, WAVE_ID varchar(20) not null, DATE_INSERTED num format = date9., TIME_INSERTED num format = time., SYNC varchar(2), SOEID varchar(2), DATE_MODIFIED num format = date9.);
This is how I was trying to write a rule for inserting date:
alter table table_name modify DATE_INSERTED,DATE_MODIFIED ON UPDATE today() NOT NULL ;
Please help me on how to write full syntax for inserting sysdate (to DATE_INSERTED & DATE_MODIFIED) and systime (to TIME_INSERTED) After creation users will upload data using - insert select Thanks a lot Max
... View more