How to split a date into mm ,dd and yy ?

[u52766097]

 How can I split these dates into mm , yy and dd for full dates and yy, and  mm for partial dates?  These dates are character values.

feb2010 05mar2010 05jan2010 25jul2010 
aug2010

[Kurt_Bremser]

Use SUBSTR() to extract parts of strings, and LENGTH() to determine if a day is present or not.

[u52766097]

I tried with ' substr ' funcation , it worked but if we have to change mm, yy and dd into numeric form and create a date format for partial date  ,how can we do that?

[Kurt_Bremser]

Please show which values you want to get for each of your example strings.

[SASKiwi]

data want;
  date = '05jan2010';
  date_num = input(date,date9.);
  format date_num ddmmyy10.;
run;

[u52766097]

jan2010 05mar2010 05jan2010 25jul2010
feb2010 05mar2010 05jan2010 25jul2010

[Kurt_Bremser]

---

@u52766097 wrote:
jan2010 05mar2010 05jan2010 25jul2010
feb2010 05mar2010 05jan2010 25jul2010

---

And which separate numeric day, month and year values do you want to get for each of these strings?

[u52766097]

data have;
input aestdtc : $9 aeendtc :$9. rfxstdc : $9. rfxendtc : $9.;
datalines;
11jan2010 09mar2010 05jan2010 25jul2010
21jan2010 05mar2010 05jan2010 25jul2010
jan2010 05mar2010 05jan2010 25jul2010
feb2010 05mar2010 05jan2010 25jul2010
aug2010 05mar2010 05jan2010 25jul2010
05mar2010 05jan2010 25jul2010
04jan2010 05jan2010 25jul2010
;
run;

I need all the dates in numeric form, like below-

[Kurt_Bremser]

And which day of the month needs to be set from an incomplete string?

[u52766097]

10-01-2010 05-03-2010 05-01-2010 25-07-2010
01-01-2010 05-03-2010 05-01-2010 25-07-2010
01-2010 05-03-2010 05-01-2010 25-07-l2010
02-2010 05-03-2010 05j-01-2010 25j-07-2010
08-2010 05-03-2010 05-01-2010 25-07-2010