topic Re: How to split a date into mm ,dd and yy ? in New SAS User

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

u52766097 — Sat, 20 Nov 2021 05:07:45 GMT

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

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

Kurt_Bremser — Sat, 20 Nov 2021 06:05:38 GMT

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

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

u52766097 — Sat, 20 Nov 2021 06:14:47 GMT

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?

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

Kurt_Bremser — Sat, 20 Nov 2021 06:20:01 GMT

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

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

u52766097 — Sat, 20 Nov 2021 06:22:20 GMT

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

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

SASKiwi — Sat, 20 Nov 2021 06:24:07 GMT

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

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

Kurt_Bremser — Sat, 20 Nov 2021 06:27:01 GMT

@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?

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

u52766097 — Sat, 20 Nov 2021 07:00:56 GMT

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-

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

u52766097 — Sat, 20 Nov 2021 07:04:04 GMT

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

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

Kurt_Bremser — Sat, 20 Nov 2021 09:12:38 GMT

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