topic Re: wrs : using expression in amount in SAS Web Report Studio

wrs : using expression in amount

deleted_user — Wed, 16 Jul 2008 14:26:12 GMT

Hi,

in WRS, I try 'd like to make amount in cross-tabulation. One variable (C) is a composed variable : C= a/B defined in Info Map.
My problem is that for C variable, i don't want to have the sum in the amount but to realize the expression that compose the variable (A/B).
I have modified the aggregations properties in Info map but in WRS, i still have then sum like result and not then expression (A/B).

Thanks for your help

Nolwenn

Re: wrs : using expression in amount

Cynthia_sas — Wed, 16 Jul 2008 16:35:38 GMT

Hi:
This doesn't seem like a stored process question. Your best bet for a response that focuses on Information Maps and WRS would be to contact Tech Support.

cynthia

Re: wrs : using expression in amount

AngelaHall — Wed, 18 Nov 2009 03:51:39 GMT

Have you tried to create a custom measure within the Web Report Studio report itself? I have a feeling that the difference between running it query time (information map) and running it post time (web report studio) is causing a hiccup in the ratio.

Go to Select Data and choose Custom to create a custom measure. There are screenshots of this within my paper : http://www2.sas.com/proceedings/forum2008/194-2008.pdf on pg 12.

Then attempt to use this custom measure in your cross-tab.

Angela Hall
Zencos Consulting
http://www.zencos.com