topic Return Days of Year from Now() in SAS Visual Analytics

Return Days of Year from Now()

Bubson — Thu, 09 Feb 2023 03:24:19 GMT

I am getting a nonsense value for:

DayOfYear(TreatAs(_Date_, DatePart(Now())))

The result I get is 31,501,320

Should be 40.

Anybody no what I am doing wrong.

Many thanks in advance.

Tim

Re: Return Days of Year from Now()

MayurJadhav — Thu, 09 Feb 2023 09:51:04 GMT

There are couple of ways you can achieve this.

Here is the simplest one:

Example 1: Simple and straightforward

You can remove +1 if you don't want to count todays date.

data _null_;
	nrOfDays=intck('day', '01JAN2023'd, today()) + 1;
	put nrOfDays=;
run;

Example 2: Dynamic start date

In case if you don't want to hard code date 01JAN2023 then you can use following code:

data _null_;
	format beginning date9.;
	beginning=intnx('year ', today() , 0, 'b');
	nrOfDays=intck('day', beginning, today()) + 1;
	put beginning=;
	put nrOfDays=;
run;

Re: Return Days of Year from Now()

Nigel_Pain — Thu, 09 Feb 2023 10:43:08 GMT

If you check the properties of your calculated item you'll probably find that the Aggregation is set to "Sum", so that it's effectively multiplying the number of days in the year by the number of records. in the table. Change it to "Average", "Minimum" or "Maximum" and it should display the correct value.

Re: Return Days of Year from Now()

Ksharp — Thu, 09 Feb 2023 11:47:11 GMT

data _null_;
DayOfYear=put(date(),julday.);
put DayOfYear=;
run;

Re: Return Days of Year from Now()

Bubson — Thu, 09 Feb 2023 18:52:09 GMT

Thanks for your response. As you guessed, I had the aggregation set to sum. Changed it to minimum and it calculates as expected.

Re: Return Days of Year from Now()

Bubson — Thu, 09 Feb 2023 18:54:13 GMT

Thank you to everybody that replied. The problem was that I had aggregation set to 'Sum'. When set to 'Minimum' it calculates as expected.

Re: Return Days of Year from Now()

SASKiwi — Thu, 09 Feb 2023 19:02:57 GMT

Please update your post as answered in that case.