topic Re: week calculation is SAS VA in SAS Visual Analytics

week calculation is SAS VA

rmalcata — Thu, 09 Feb 2017 01:24:49 GMT

Hi,

Can anyone let me know why this calculated field is not producing an output.

DATE_day is formated as date/time and that is why I am using TreatAs, otherwise VA doesn't accept the function:

WeekNumber(TreatAs(_Date_, 'DATE_day'n))

Any help would be really appreciated.

cheers

Rita

Re: week calculation is SAS VA

TobiasH — Thu, 09 Feb 2017 07:49:25 GMT

Hi Rita,

you may also try to use the function Datepart() which extracts the date information from a date/time number:

WeekNumber(Datepart(DATE_day))

As I understood the TreatAs function just converts a number (like 1) to a date/time information (01.01.1960 00:00:00) and the function weeknumber needs a date only information.

If your DATE_day is a number than you have to convert it first to a date/time (with treatas) and then extract the date part.

Let me know if I'm wrong!

Best,

Tobias

Re: week calculation is SAS VA

rmalcata — Thu, 09 Feb 2017 19:48:23 GMT

Hi Tobias,

Thank you for the reply.

The calculation produced something but not really what I expected.

This was the formula that I used as you described:

WeekNumber(DatePart('DAY_DATE'n))

Is there anything that I am doing wrong?! I am using a calculated field.

Cheers,

Rita

Re: week calculation is SAS VA

rmalcata — Tue, 14 Feb 2017 01:06:34 GMT

Hi,

The calcualtion was correct. I just forgot to change the aggregation to min, avg or max. the sum doesn't work.

Thanks

Rita