Kroken Tracker
https://communities.sas.com/kntur85557/tracker
Kroken TrackerWed, 24 Apr 2024 18:41:04 GMT2024-04-24T18:41:04ZRe: Visual Analytics:How can I calculate growth in percent frequency of category classes?
https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-How-can-I-calculate-growth-in-percent-frequency/m-p/358754#M7172
<P>Thank you for you tips, time and insight Ahmed! Much appreciated. I'm going small!</P><P> </P><P>Kind regards,</P><P>Kroken</P>Mon, 15 May 2017 14:17:37 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-How-can-I-calculate-growth-in-percent-frequency/m-p/358754#M7172Kroken2017-05-15T14:17:37ZRe: Visual Analytics:How can I calculate growth in percent frequency of category classes?
https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-How-can-I-calculate-growth-in-percent-frequency/m-p/358677#M7169
<P>HI Ahmed -</P><P> </P><P>Thanks for you reply. Are you an experienced user of VA? I am very new to the tool and I get the feeling that it lacks the flexibility that I was hoping for. It seems that I very often get stuck when I try to build a graphical solution (I am only working in report builder so far) that requires data to be processed over more than two or three dimensions (or "steps"). For this example my initial intention was to load the actual age variable into the LASR and then make custom catetories and calculate the % frequencey and then the development of each category. But it seems it has to be done outside of the VA (as you suggests). Other attempts to work with the devolpment of grouped data has also failed and I have been advised to create purpose build data outside VA.</P><P> </P><P>It seems to me that I should change my mindset and start to work with smaller datasets with purpose build data instead of trying to work with a large datamart containing raw data. For example to calculate the growth per age group outside VA and add a maximum of one or mabye two additional dimensions (as for example date). And use different source data tables for my reports. It kind of removes the benifits I thought I would find in this tool but it seems it is the best way to avoid getting stuck and frustrated.</P><P> </P><P>Do you think that this is a better approach whenever I want to present something that requires processing raw data more than two or three times within the report builder? </P><P> </P><P>Kind regards,</P><P>Kroken</P><P> </P>Mon, 15 May 2017 09:27:00 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-How-can-I-calculate-growth-in-percent-frequency/m-p/358677#M7169Kroken2017-05-15T09:27:00ZVisual Analytics:How can I calculate growth in percent frequency of category classes?
https://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-How-can-I-calculate-growth-in-percent-frequency/m-p/358210#M7160
<P>I have a category variable with age groups, such as 1-10, 11-20, 21-20, 31-, and want to graphically present the change in percent frequency of each class between two dates. Does anyone have an idea on how I can do this within the Report Designer in SAS visual analytics? The desired reslut (which should be presented grapically somehow) is something like this. </P><P> </P><P>The first three columns are percent frequency by data and the last two are growth in percent frequncey.</P><P> </P><TABLE><TBODY><TR><TD>Age group</TD><TD>2016-01-01</TD><TD>2016-06-01</TD><TD>2017-01-01</TD><TD>2016-01-01 - 2016-06-01</TD><TD>2016-01-01 - 2017-01-01</TD></TR><TR><TD>0-10</TD><TD>30%</TD><TD>20%</TD><TD>20%</TD><TD>-33%</TD><TD>-33%</TD></TR><TR><TD>11-20</TD><TD>20%</TD><TD>30%</TD><TD>20%</TD><TD>50%</TD><TD>0%</TD></TR><TR><TD>21-30</TD><TD>20%</TD><TD>30%</TD><TD>40%</TD><TD>50%</TD><TD>100%</TD></TR><TR><TD>31-</TD><TD>30%</TD><TD>20%</TD><TD>20%</TD><TD>-33%</TD><TD>-33%</TD></TR><TR><TD>Tot</TD><TD>100%</TD><TD>100%</TD><TD>100%</TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P> </P><P>which shold be calculated from data something like this: </P><P> </P><TABLE><TBODY><TR><TD>Date</TD><TD>ID</TD><TD>Age group</TD></TR><TR><TD>2016-01-01</TD><TD>1</TD><TD>0-10</TD></TR><TR><TD>2016-01-01</TD><TD>2</TD><TD>0-10</TD></TR><TR><TD>2016-01-01</TD><TD>3</TD><TD>0-10</TD></TR><TR><TD>2016-01-01</TD><TD>4</TD><TD>11-20</TD></TR><TR><TD>2016-01-01</TD><TD>5</TD><TD>11-20</TD></TR><TR><TD>2016-01-01</TD><TD>6</TD><TD>21-30</TD></TR><TR><TD>2016-01-01</TD><TD>7</TD><TD>21-30</TD></TR><TR><TD>2016-01-01</TD><TD>8</TD><TD>31-</TD></TR><TR><TD>2016-01-01</TD><TD>9</TD><TD>31-</TD></TR><TR><TD>2016-01-01</TD><TD>10</TD><TD>31-</TD></TR><TR><TD>2016-06-01</TD><TD>1</TD><TD>0-10</TD></TR><TR><TD>2016-06-01</TD><TD>2</TD><TD>0-10</TD></TR><TR><TD>2016-06-01</TD><TD>3</TD><TD>11-20</TD></TR><TR><TD>2016-06-01</TD><TD>4</TD><TD>11-20</TD></TR><TR><TD>2016-06-01</TD><TD>5</TD><TD>11-20</TD></TR><TR><TD>2016-06-01</TD><TD>6</TD><TD>21-30</TD></TR><TR><TD>2016-06-01</TD><TD>7</TD><TD>21-30</TD></TR><TR><TD>2016-06-01</TD><TD>8</TD><TD>21-30</TD></TR><TR><TD>2016-06-01</TD><TD>9</TD><TD>31-</TD></TR><TR><TD>2016-06-01</TD><TD>10</TD><TD>31-</TD></TR><TR><TD>2017-01-01</TD><TD>1</TD><TD>0-10</TD></TR><TR><TD>2017-01-01</TD><TD>2</TD><TD>0-10</TD></TR><TR><TD>2017-01-01</TD><TD>3</TD><TD>11-20</TD></TR><TR><TD>2017-01-01</TD><TD>4</TD><TD>11-20</TD></TR><TR><TD>2017-01-01</TD><TD>5</TD><TD>21-30</TD></TR><TR><TD>2017-01-01</TD><TD>6</TD><TD>21-30</TD></TR><TR><TD>2017-01-01</TD><TD>7</TD><TD>21-30</TD></TR><TR><TD>2017-01-01</TD><TD>8</TD><TD>21-30</TD></TR><TR><TD>2017-01-01</TD><TD>9</TD><TD>31-</TD></TR><TR><TD>2017-01-01</TD><TD>10</TD><TD>31-</TD></TR></TBODY></TABLE><P> </P>Fri, 12 May 2017 12:17:09 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/Visual-Analytics-How-can-I-calculate-growth-in-percent-frequency/m-p/358210#M7160Kroken2017-05-12T12:17:09ZRe: Percent difference from "fixed" previous period
https://communities.sas.com/t5/SAS-Visual-Analytics/Percent-difference-from-quot-fixed-quot-previous-period/m-p/355635#M7094
<P>Thanks - both of you!</P>Wed, 03 May 2017 14:57:35 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/Percent-difference-from-quot-fixed-quot-previous-period/m-p/355635#M7094Kroken2017-05-03T14:57:35ZPercent difference from "fixed" previous period
https://communities.sas.com/t5/SAS-Visual-Analytics/Percent-difference-from-quot-fixed-quot-previous-period/m-p/355509#M7088
<P>HI -</P><P> </P><P>I'm new to SAS VA and this community and would like to see if anyone here can help me to solve a problem I have when designing a report. I want to create a graph showing percent difference from a <STRONG>fixed</STRONG> previous period (the first date in my data). I do not really understand how I can achieve this from the optional settings in the aggregated measure editor. Does anyone have any kind of solution for this?</P><P> </P><P>Kind regards,</P><P>Mats</P><P> </P><P>P.S It doesnt have to be solved within the editor - any solution woud be greatly appreciated.</P><P> </P>Wed, 03 May 2017 08:26:55 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/Percent-difference-from-quot-fixed-quot-previous-period/m-p/355509#M7088Kroken2017-05-03T08:26:55Z