i have a date in my data which is only day and month (eg. 25/03)
when doing an infile, it imports as a text value.
i am trying to add a year to this value, but with no joy.
i am trying to use the following:
data may_3010;
set may_3010;
format year $4.;
format newdate date9.;
year= '2010';
newdate= input(Prom_D_1||year,mmddyy10.);
run;
You need to add a / between your text-date and the year and you should use the informat ddmmyy10.:
[pre]data work.may_3010;
set work.may_3010;
length newdate 8;
format newdate date9.;
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!