Hi I'm back again with some more date questions since I can't seem to ever do anything right with them.
So I have a field that is a mixture of dates and other information that im importing from excel. I'm sorting it by a case statement then doing a data step to reformat it and I'm just getting back nulls when I try and turn this characters into dates.
Code:
proc sql; create table test as select * , case when length(field1) <= 5 then field1 end as new_date_field from work.name; run;
data test2; set test1; format var1 date9.; var1= input(new_date_field,yymmdd12.); run;
... View more