About TejaSurapaneni

VivekRathod · ‎11-20-2017

1. I had a data of 800gb, but the user has loaded it on lasr, and the column trdng_wk_end was having the values in number 20170112. 2. To create a date out of 20170112 kind of numbers follow the following. 2. create a new calculated item. I used the combination of functions. mdy - outer shell parse - first inner shell substr - second inner shell format - inner most inner shell My case: DateFromMDY(Parse(Substring(Format('TRDNG_WK_END_DT'n, 'BEST2.'), 5, 2), 'COMMA2.'), Parse(Substring(Format('TRDNG_WK_END_DT'n, 'BEST2.'), 7, 2), 'COMMA2.'), Parse(Substring(Format('TRDNG_WK_END_DT'n, 'BEST4.'), 1, 4), 'COMMA4.')) Thanks Madhusudhan SAS Administrator Landmark Group

Astounding · ‎10-24-2017

Assuming it's OK to give you exactly what you asked for ... data want; if _n_=1 then set EMPL_Hierarchy; array L_ {4} L1_ID L2_ID L3_ID L4_ID; set EmplData; if _n_ > 1 then L_{_n_-1} = ' '; run;

Dreamer · ‎10-16-2017

For a quick fix I replaced all missing values to 0 (zeros). It worked for now. But I'll be looking for a good solution of this problem. I'm sure there should be some way to negate missing value effect.

SASKiwi · ‎08-09-2017

Well using SAS user-defined formats as described in this post is not going to work as they can't be applied to measures. I'm wondering if the VA 7.4 text object may help here. We haven't upgraded to 7.4 yet so I can't try it out.

mcgarrick · ‎07-11-2017

works perfectly. Thankyou!

Sam_SAS · ‎07-07-2017

Hello David, There is a new feature in 7.4 that might be helpful. In 7.4, you can create a slider prompt with a date assigned to it, then on the Properties tab you can set Value=Single and Set value to dynamic maximum. This will dynamically select the latest value for the date data item. Is that helpful? Thanks, Sam

Sam_SAS · ‎06-20-2017

Hello Nd, I believe that what Teja had in mind is using a Stack Container. You can add a stack container to your report by dragging "Stack Container" from the Objects pane at the left side of the screen. Here is some information about the different types of containers and container settings: https://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#p1xjtsldmiku6tn1n6c97tve50iq.htm Does that help? Thanks, Sam

itchyeyeballs · ‎04-28-2017

If you want top see the date in a table use the treat as function to create a numeric version create a top 1 rank on the numeric version but put the actual date value into the table then In the example above I have a second column showing when the data was refereshed by sas, to do this I just added column in my underlying data query which inserts todays date against every row.

sophiehd · ‎04-03-2017

Is this also worked for SAS VA 7.1? I have created a calculated item using the now() function and placed it inside a Text box on top of each report section. However, this doesn't seem to work? Any help would be much appreciated. Thanks

rmalcata · ‎03-15-2017

@TedStolarczyk thanks for the reply. The only reason why I'm using the geo region mas is that I do not have the lat/lon coordinates. I'm using the regions that SAS recognized. I will investigate this a bit further. To summarize the answer, it is not possible to hide/not shown the warning triangle. Thanks! Rita

Renato_sas · ‎01-30-2017

Hi @MahRaz, Yes, but you will need a few additional auxiliary calculations, because you cannot use categories in aggregated measures, like we used before with the calculated item to evaluate the parameter value. AuxMeasure1: IF 'selected measure1'p Missing RETURN 0 ELSE IF 'selected measure1'p = 'Aggreg Measure A' RETURN 1 ELSE IF 'selected measure1'p = 'Aggreg Measure B' RETURN 2 ELSE . NewMeasure1 (this is your new proxy aggregated measure): IF Min(AuxMeasure1) = 0 RETURN . ELSE IF Min(AuxMeasure1) = 1 RETURN AggregMeasureA ELSE Min(AuxMeasure1) = 2 RETURN AggregMeasureB ELSE . I've used the funtion Min(), but Max() and Avg() also work. Best, Renato

vivek_sas · ‎11-14-2016

Hi, It can be achieved if you create a custom graph . 1)In custom graph first select multiple pie charts based on your requirement. 2)create one shared rule for category 3)apply that shared rule to all graphs which you selected. If you use that custom graph in report...category will be same for all graphs and you can select different measure for each graph seperately.then you drill on one graph all graphs will drill. In the above i createted one shared rule - Shared rule 1 and applied it to all piecharts in the place of category Regards, Vivek R

LisaSAS · ‎11-09-2016

What is an alternate way to do this? I'm working with two pie charts and would like the interaction to exist between the two. Right now if I do an interaction from pie chart 1 to pie chart 2, it works great. However, I want to also have an interaction from pie chart 2 to pie chart 1. I'm in version 7.3, looking for suggestions on how to accomplish this.

SKG · ‎09-21-2016

Hi Peter, Sorry, I resolved my issue

tassekurt · ‎08-17-2016

Thank you so much.

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?

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

Re: Duplicate rows

Re: How can I calucalate ratio of two measures?

Re: billion or trillion conversion to crores and lakhs

Re: Simple way to remove the missings when you count distinct?

Re: Dynamic Filter on Most Recent Date Available in Data

Re: Conditional Show/Hide Tables/Graphs

Re: About getting the max date in a table field

Re: how to add current date to VA report

Re: How to hide a warning message in SAS VA

Re: Using measures in list or dropdown controls.

Re: Drill down across multiple graphs

Re: Both Ways interaction

Re: List Box default setting

Re: Add New Column based on IF Statement

SAS Global Forum 2016