TejaSurapaneni Tracker

Data Transpose

TejaSurapaneni — Sat, 24 Mar 2018 13:23:17 GMT

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

Re: % of Total with Hierarchy

TejaSurapaneni — Thu, 08 Mar 2018 17:47:40 GMT

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

Re: interaction on a rank

TejaSurapaneni — Thu, 08 Mar 2018 17:36:31 GMT

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

Re: How to remove the last tie value?

TejaSurapaneni — Fri, 15 Dec 2017 06:56:37 GMT

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

Re: Search Control / Functionality

TejaSurapaneni — Fri, 08 Dec 2017 17:32:04 GMT

Hi,

Instead of Dropdown, use List Control.

Thanks,
Teja

Re: SAS VA

TejaSurapaneni — Wed, 06 Dec 2017 09:16:14 GMT

Hi @Akas_wankha,

Can you please share the screenshot of ROLES (with Assigned columns).

Thanks,

Teja

Re: SAS VA

TejaSurapaneni — Thu, 30 Nov 2017 06:40:38 GMT

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

Re: SAS VA

TejaSurapaneni — Wed, 29 Nov 2017 12:36:35 GMT

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

Re: SAS VA

TejaSurapaneni — Wed, 29 Nov 2017 12:35:14 GMT

Hi @Akas_wankha,

is this your requirement?

There are two ways to show the TOTAL Value in Bar Chart.

Thanks,

Teja Surapaneni

Re: SAS VA Cross Tab not enlarging

TejaSurapaneni — Tue, 21 Nov 2017 09:12:27 GMT

Hi,

Did you checked crosstab properties?

Thanks,

Teja Surapaneni

Duplicate rows

TejaSurapaneni — Tue, 24 Oct 2017 15:57:34 GMT

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

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

Re: How can I calucalate ratio of two measures?

TejaSurapaneni — Fri, 13 Oct 2017 09:49:02 GMT

Hi there,

Instead of Calculated Measure Please use Aggregated Measure.

Thanks,

Teja Surapaneni

Re: Drill down across multiple graphs

TejaSurapaneni — Thu, 10 Nov 2016 05:39:58 GMT

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

Report Performance

TejaSurapaneni — Thu, 06 Oct 2016 12:32:00 GMT

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.

Re: Add New Column based on IF Statement

TejaSurapaneni — Tue, 16 Aug 2016 10:39:03 GMT

Hello,

in SAS VA,

IF ( 'ResolvedTeam'n In ('A') )
RETURN ' ProductResposibleTeam'n
ELSE 'ResolvedTeam'n

Let me know.

Thanks & Regards,

Teja Surapaneni

Re: About numeric to character conversion in expressions of calculated item

TejaSurapaneni — Tue, 05 Jul 2016 08:31:06 GMT

Hi Sillin Borro,

Instead of that use Best Format.

Thanks & Regards,

Teja Surapaneni.

Re: how to use the same filter for multiple charts on same section

TejaSurapaneni — Wed, 01 Jun 2016 05:32:34 GMT

Hi,

Can you please share the two charts info like roles

Thanks & Regards,

Teja Surapaneni

Re: Hadoop to SAS VA

TejaSurapaneni — Wed, 04 May 2016 10:47:19 GMT

Hi,

Thanks for your quick rply.

Best way to load HBASE/phonix to LASR (both batch & Trigger based).

Present we are using HIVE to load the Hbase files.

Can I loade the HBase files directly to the LASR..?

Thanks.

Hadoop to SAS VA

TejaSurapaneni — Wed, 04 May 2016 10:19:27 GMT

Hi All,

Is there any best way to load data from Hadoop to LASR (SAS VA).

Thanks

Re: Sum of averages

TejaSurapaneni — Wed, 06 Apr 2016 09:03:16 GMT

Hello Soman,

Sorry I thought that you asking about percent of subtoal.

i have seen your screen shot.

As per my knowledge it is not possible..

let's hope someone can help..

Thanks & Regards,

Teja Surapaneni.