Hello, i'm a SAS beginner and i have a question:
i'm trying to archive a part of my dataset
data _null_;
format archive_date date9.;
archive_date = date() - (30);
put 'Archief_datum = ' archive_date;
call symput('archive_date',left(put(archive_date,12.)));
run;
data rf300l3.W_status_foup_count;
set rf300l3.W_status_foup_count;
if Date > &archive_date then output rf300l3.W_status_foup_count;
run;
yet, i get this error:
NOTE: Character values have been converted to numeric values at the places given by:
(Line)Column).
1082:5
NOTE: Invalid numeric data, date='28OCT2010' , at line 1082 column 5.
dept=BIONE date=28OCT2010 code=HOLD CUST nbr=0 _ERROR_=1 _N_=1
NOTE: Invalid numeric data, date='28OCT2010' , at line 1082 column 5.
any help?
thanks
i'm trying to archive a part of my dataset
data _null_;
format archive_date date9.;
archive_date = date() - (30);
put 'Archief_datum = ' archive_date;
call symput('archive_date',left(put(archive_date,12.)));
run;
data rf300l3.W_status_foup_count;
set rf300l3.W_status_foup_count;
if Date > &archive_date then output rf300l3.W_status_foup_count;
run;
yet, i get this error:
NOTE: Character values have been converted to numeric values at the places given by:
(Line)Column).
1082:5
NOTE: Invalid numeric data, date='28OCT2010' , at line 1082 column 5.
dept=BIONE date=28OCT2010 code=HOLD CUST nbr=0 _ERROR_=1 _N_=1
NOTE: Invalid numeric data, date='28OCT2010' , at line 1082 column 5.
any help?
thanks