07-15-2013 02:33 AM
In my source file,I have date column (for eg.)
Rohan 15/07/2013(today's date)
I want to apply filter - (today's date should not be in my target).
In extract transformation,I have applied (DOJ ^= 'today()'),(DOJ ^= 'date()'),(DOJ ^= "&sysdate()").
All are not working.
I need ny target as
Kindly help me on this.
07-15-2013 03:31 AM
I have defined the date column as character in source and i need to load as numeric in target.
I need to apply date filter on target.(i.e after file reader).
I am using SAS DI 4.21.
07-15-2013 06:21 AM
I think this is what you are after.
INFILE DATALINES DELIMITER=",";
LENGTH NAME $5. DOJ $10.;
INPUT NAME $ DOJ $;
DATA WANT (WHERE = (DOJ ~= "&SYSDATE."D));
FORMAT DOJ1 DDMMYY10.;
DOJ1 = INPUT(DOJ,?? DDMMYY10.);
RENAME DOJ1 = DOJ;