About TejaSurapaneni

TejaSurapaneni · ‎03-24-2018

Hi Team, I have two tables. Table 1: Product Bud_1988 Bud_1999 X 0 0 Y 0 0 Z 0 0 Table 2: Product Achvt_1988 Achvt_1999 X 0 0 Z 0 0 Required Output table: Product Var 1988 1999 X Bud 0 0 X Achvt 0 0 Y Bud 0 0 Z Bud 0 0 Z Achvt 0 0 This should be done in Single Data Step(without Proc Transpose). Can some one Please guide me Thanks

TejaSurapaneni · ‎03-08-2018

Hi David, 1) Create an Aggregated Measure i.e., Employees Bygroup / Employees Forall. Then Change the column properties to Percent. Or 2) If you are using Cross Table then you can create Sub Total. Thanks, Teja

TejaSurapaneni · ‎03-08-2018

Hi @SophieSaas, Yes you can.. you can do this with parameter as @MikeJenista said. Create a character parameter (Set Max, Min and Current Rank) and Name it as RANK or As you required. Assign that Rank to your Text Input Control. Create a Rank for your Object (which is available in Right hand side pane). There you will find Parameter Option (In Rank Tab). Hope this will help..... Thanks, Teja

TejaSurapaneni · ‎12-15-2017

Hi @Carrot17, sorry for the late reply.... In my knowledge there is no workaround for this in SAS VA. In simple form Tie option will work based on Alphabetical order (i.e., if you un-check the TIE for TOP Level it will remove/hide C, in the same way if you un-check the TIE for Bottom Level it will remove/hide B. ) Ex: Actual Data: Name Count A 4 B 4 C 2 D 2 E 2 F 2 For Top 5: Name Count A 4 B 4 D 2 E 2 F 2 For Bottom 5: A 4 C 2 D 2 E 2 F 2 Thanks, Teja Surapaneni

TejaSurapaneni · ‎12-08-2017

Hi, Instead of Dropdown, use List Control. Thanks, Teja

TejaSurapaneni · ‎12-06-2017

Hi @Akas_wankha, Can you please share the screenshot of ROLES (with Assigned columns). Thanks, Teja

TejaSurapaneni · ‎11-30-2017

Hi @Akas_wankha, Sorry for the late Reply... Steps for Custom Graph: 1) Drag and drop Two Bar Charts into canvas area (Not Side by Side). 2) Create a shared Role. 3) assign/share the created Shared Role with Bar charts Measure. (Right Click on Bar Measures you will get an option USE SHARED ROLE) Then Save it. In your Designer Create a Calculated (Character)/Custom Category and Name it as Total (as per my Exmple: IF Region in (EAST, West, North, South) Return Total else ' ') after that assign the roles for Custom Graph. Category 1 : Region Category 2: Total Shared Measure : Budget/Measure. Let me know if you found any difficulties while doing. Thanks, Teja Surapaneni

TejaSurapaneni · ‎11-29-2017

Hi, In my knowledge... option is not available to show Label value (TOTAL) in Bar Chart Instead of that you can use Data tip value (which is available Bar Graph roles) to show Total Value. create an Aggregated Measure and Name it as Total Budget/your Measure name. Then assign this Agg. Measure to Date tip value. The Previous Graph (In my last post) is done through Custom Graph builder. If you want I will share the steps. Thanks, Teja Surapaneni

TejaSurapaneni · ‎11-29-2017

Hi @Akas_wankha, is this your requirement? There are two ways to show the TOTAL Value in Bar Chart. Thanks, Teja Surapaneni

TejaSurapaneni · ‎11-21-2017

Hi, Did you checked crosstab properties? Thanks, Teja Surapaneni

TejaSurapaneni · ‎10-24-2017

Hi, I got struck, help me on this. I have a table Empldata (EMP_ID is in character format and Interest is in Numeric Format) EMP_ID Interest 101 .2 202 .4 303 .7 404 .1 I have Another Table EMPL_Hierarachy (all columns are in Character format) L1_ID(Empl ID) L2_ID (Reporting Manager ID) L3_ID (Senior Manager ID) L4_ID (Head of All Empls) 101 202 303 404 I need I output table like below EMP_ID Interest L1_ID L2_ID L3_ID L4_ID 101 .2 101 202 303 404 202 .4 202 303 404 303 .7 303 404 404 .1 404 OR EMP_ID Interest L1_ID L2_ID L3_ID L4_ID 101 .2 101 202 303 404 202 .4 202 303 .7 303 404 .1 404 Please can some body help me on this. Thanks in Adavance Teja

TejaSurapaneni · ‎10-13-2017

Hi there, Instead of Calculated Measure Please use Aggregated Measure. Thanks, Teja Surapaneni

TejaSurapaneni · ‎11-10-2016

Hi, Which object's you are using..? have a look on this.. https://communities.sas.com/t5/SAS-Communities-Library/Two-ways-to-split-bar-charts-in-SAS-Visual-Analytics/ta-p/224002 hope this will help... 🙂 Thanks & Regards, Teja Surapaneni

TejaSurapaneni · ‎10-06-2016

Hi all, Operating System: LIN X64 . SAS Version: 9.4 We want to calculate the output parameters for VA and set a benchmark figure and based on the benchmark figure we will measure whether the VA environment is slow or normal. The sample output parameters are like: 1) How much time it is taking to open the landing / home page after user credentials are provided. 2) How much time it is taking to open a particular report when user clicks on view report. 3) How much time it is taking to load all the charts in that particular report. 4) How much time it is taking to load all the charts in that particular report when an iteration parameter / drop down is changed. 5) In similar lines some other parameters. Is it possible to measure / calculate these parameters? If yes, Could you please help us where can we get these information and in which logs all these information are stored? Note: We don't want to enable audit report, it will give which user opened / accessed which report. Our requirement was not that.

TejaSurapaneni · ‎08-16-2016

Hello, in SAS VA, IF ( 'ResolvedTeam'n In ('A') ) RETURN ' ProductResposibleTeam'n ELSE 'ResolvedTeam'n Let me know. Thanks & Regards, Teja Surapaneni

Online Status	Offline
Date Last Visited	‎06-25-2019 02:40 PM

Data Transpose

Re: % of Total with Hierarchy

Re: interaction on a rank

Re: How to remove the last tie value?

Re: Search Control / Functionality

Re: SAS VA

Re: SAS VA

Re: SAS VA

Re: SAS VA

Re: SAS VA Cross Tab not enlarging

Re: Report Performance

Re: How to hide a warning message in SAS VA

Re: about word clouds

Re: delete rows from a LASR table

Displaying chosen system variable

Re: SAS VA

Re: SAS VA

Re: SAS VA

Re: How can I calucalate ratio of two measures?

Re: Add New Column based on IF Statement

Re: How do you use the Data Panel for SAS Visual Analytics?

Data Transpose

Re: % of Total with Hierarchy

Re: interaction on a rank

Re: How to remove the last tie value?

Re: Search Control / Functionality

Re: SAS VA

Re: SAS VA

Re: SAS VA

Re: SAS VA

Re: SAS VA Cross Tab not enlarging

Duplicate rows

Re: How can I calucalate ratio of two measures?

Re: Drill down across multiple graphs

Report Performance

Re: Add New Column based on IF Statement

SAS Global Forum 2016