topic Re: derived types for measures for diff in yesterdays sales - 2 days ago sales in SAS Visual Analytics

derived types for measures for diff in yesterdays sales - 2 days ago sales

mhamlett — Wed, 15 Jun 2016 20:30:22 GMT

va 7.3

i am pulling sales from a data source that contains a date and sales amount.

i want to show the sales from yesterday with increase/descrease amount over the prior week/same day sales amount

ex. today is 06.15

i will show sales for 06.14 (tuesday) compared to sales 06.07 (tuesday).

trying to use derived item but no luck making this work.

month works cannot get the calculation to work with a day.

using inferred and -7 on the previous side of the calculation.

arodriguez — Thu, 16 Jun 2016 07:54:52 GMT

Hi mhamlett,

Have you tried to use the intck function?

data test;
days=intck('day','10jan16'd,'01jul16'd);
put days;
run;

With this function you can specify days, months, weeks... Using this function should be easy identify the dates comparing with actual day.

I usually take the actual day with

%let today	=	%qsysfunc(date(),yymmdd10.);

mhamlett — Thu, 16 Jun 2016 14:27:31 GMT

sorry, but what you are suggesting does not exist in the VA product under creating a calculated measure or aggregated measure.

TriciaAanderud — Thu, 16 Jun 2016 16:57:45 GMT

If you want to do that in SAS VA - just use the TreatAs function.

Try this post for some specific guidance: