topic Re: Extract Month and date value as character from date field in SAS Programming

Extract Month and date value as character from date field

Babloo — Mon, 08 Oct 2018 12:09:42 GMT

Previously I used to extract month and date field as follows.

NEW_RENEWAL_DAY_MONTH_YEAR=mdy(NEW_RENEWAL_MONTH,NEW_RENEWAL_DAY,RENEWAL_YEAR);
format DATE5.;

Then I convert the date field to character as follows.

NEW_RENEWAL_DAY_MONTH_YEAR_char=put(NEW_RENEWAL_DAY_MONTH_YEAR,date5.);

So that the output will be like 21NOV or 31DEC ... in character. Now the requirement is to get the values like 11-21 or 12-31. Since we do not have any formats like mmdd5. or similar format, I'm not certain how to achieve this. Please guide me.

Re: Extract Month and date value as character from date field

Kurt_Bremser — Mon, 08 Oct 2018 12:13:24 GMT

Use a yymmddd10. format and extract the last 5 characters with substr(.....,6).

Re: Extract Month and date value as character from date field

RW9 — Mon, 08 Oct 2018 12:21:05 GMT

I would ask why you want only day-month in either format. Unless you have specific (very) data, then that date part is going to be pretty useless. Why not just put a proper date on there and be done with it, yymmdd10 gives a nice sortable (in directory views and such like), and ISO dates are pretty standard now.

Re: Extract Month and date value as character from date field

Astounding — Mon, 08 Oct 2018 16:21:28 GMT

A trick for brevity:

length newvar $ 5;

newvar = put(new_renewal_day_month_year, mmddyyd10.);

There is only room to store the first five characters, so that's going to be the result.

Re: Extract Month and date value as character from date field

singhsahab — Mon, 08 Oct 2018 16:59:03 GMT

data HAVE;
input date DATE9.;
FORMAT DATE MMDDYYD10.;
datalines;
31DEC2018
21NOV2018
;
run;

DATA WANT;
SET HAVE;
NEW_D=SUBSTR(PUT(DATE,MMDDYYD10.),1,5);
RUN;