topic Re: Finding Month and day from number of days away from January 1. in SAS Programming

Finding Month and day from number of days away from January 1.

pr1 — Wed, 25 May 2016 14:05:22 GMT

Hello, I have a number that represents the number of days from January 1 of any year with January 1 as day 1. For example 10 will be January 10.

Using SAS how can I convert that number into day and month for example 10 = 01/10?

Thanks.

Pramodini

Re: Finding Month and day from number of days away from January 1.

Astounding — Wed, 25 May 2016 14:15:25 GMT

How do you intend to supply the year? Getting the correct answer depends on whether or not it is a leap year.

Re: Finding Month and day from number of days away from January 1.

pr1 — Wed, 25 May 2016 14:18:30 GMT

I have 1956229 as input field that should translate into 8/16/1956

Re: Finding Month and day from number of days away from January 1.

RW9 — Wed, 25 May 2016 14:22:41 GMT

Where is the data from? I mean I can see year=1956 as first four characters, but the rest doesn't make sense and formating as date value is wrong.

Re: Finding Month and day from number of days away from January 1.

pr1 — Wed, 25 May 2016 14:24:40 GMT

1956229 as a field in which the year is 1956 and 229 is the 229th day of year 1956 that is August 16th which should display as 8/16/1956

Re: Finding Month and day from number of days away from January 1.

Astounding — Wed, 25 May 2016 14:30:43 GMT

OK, it's easy enough to split this in two. These statements assume that your original variable is numeric. If it is actually character, the statements would change slightly.

year = int(juldateval / 1000);

days = mod(juldateval, 1000);

newdate = mdy(1, 1, year) + days - 1;

format newdate mmddyys10.;

Re: Finding Month and day from number of days away from January 1.

pr1 — Wed, 25 May 2016 14:33:08 GMT

THANKS!! that works.

Re: Finding Month and day from number of days away from January 1.

Ksharp — Thu, 26 May 2016 03:14:09 GMT

There already is a funtion to do that .

data _null_;
Xend=datejul(2001001);
put Xend / Xend date9.; 
run;

Re: Finding Month and day from number of days away from January 1.

pr1 — Thu, 26 May 2016 10:31:08 GMT

Thank You. Let me try this.