topic Re: add day to format date in SAS Programming

add day to format date

sasphd — Thu, 07 Apr 2022 10:50:50 GMT

hello,

I have date format yymmn6. I want to change it to MMDDYY10.

by adding the last day of the month

have : 198605

want 05/31/1986

thanks

change date format yymmn6. to MMDDYY10.

sasphd — Thu, 07 Apr 2022 10:40:28 GMT

hello,

I have date format yymmn6. I want to change it to MMDDYY10.

by adding the last day of the month

have : 198605

want 05/31/1986

thanks

Re: add day to format date

Kurt_Bremser — Thu, 07 Apr 2022 10:57:09 GMT

Is the variable in question already a SAS date with a format of YYMMN6., or is it a character variable containing the string?

If it is already a date, then this does it:

format var mmddyy10.;
var = intnx('month',var,0,'e');

If it is a string, do this:

numdate = intnx('month',input(chardate,yymmn6.),0,'e');
format numdate mmddyy10.;

Re: change date format yymmn6. to MMDDYY10.

PaigeMiller — Thu, 07 Apr 2022 11:42:50 GMT

DUPLICATE THREAD

Do not reply here

Reply at https://communities.sas.com/t5/SAS-Programming/add-day-to-format-date/m-p/806467#M317742

Re: change date format yymmn6. to MMDDYY10.

Kurt_Bremser — Thu, 07 Apr 2022 12:58:59 GMT

I merged this back into the original question.

@sasphd please do not double-post.

Re: add day to format date

dexcort2020 — Thu, 07 Apr 2022 13:54:57 GMT

If it is already a date, then this does it:

2022 var mmddyy10.; var = intnx('month',var,0,'e');

If it is a string, do this:

numdate = intnx('month',input(chardate,yymmn6.),0,'e'); 2022 numdate mmddyy10.;

Re: add day to format date

Kurt_Bremser — Thu, 07 Apr 2022 15:22:02 GMT

@dexcort2020 wrote:

If it is already a date, then this does it:
2022 var mmddyy10.; var = intnx('month',var,0,'e');
If it is a string, do this:
numdate = intnx('month',input(chardate,yymmn6.),0,'e'); 2022 numdate mmddyy10.;

2022 is not a valid SAS statement.

Re: add day to format date

Kurt_Bremser — Thu, 07 Apr 2022 16:05:56 GMT

Please reconsider which of the posts you mark as a solution. My correction of @dexcort2020 's post is not a solution for your initial question.

Re: add day to format date

Tom — Thu, 07 Apr 2022 17:26:36 GMT

And if the original variable is numeric with values like 202,201 which humans might see as meaning January 2022 then you need add another layer to the function call sandwich.

So pick the proper second statement based on whether VAR is

1) date valued numeric

2) character

3) regular integer valued numeric.

format want mmddyy10.;
want = intnx('month',var,0,'e');
want = intnx('month',input(var,yymmn6.),0,'e');
want = intnx('month',input(put(var,z6.),yymmn6.),0,'e');