One way I think might work is to create a new aggregated table containing year and count of number of observations.
You might also add some dimensions if you filter on these in the report.
... View more
Hi!
You can create something similiar by using a bar chart.
Create a calculated measure with value 1 and add to the bar chart as measure.
Add your time dimension to the bar chart as categoy.
group the bar chart (rows) on your machine (or what you use), as in yourexample grd_a and grd_b.
Create calculated measures for each of your statAcronym
Create a display rule for each of the measures.
Could look something like this:
BR
Fredrik
... View more
HI! The easiest (i think :)) is to use the data driven content object and create the report using a viya job. You create the job using SAS/Base and ODS. There is no "report"-object in SAS VA to create what you want other than list/cross-table. You can create interactions to/from the DDC to interact with other objects in the VA report. BR Fredrik
... View more
You can use a data driven content and create a viya job that creates the table dynamically and display it in VA. Might help you...:) BR Fredrik
... View more
I think you are on the right track by creating different dimension variables depending on what the "General RTA category" contains. The visualization part can be done by using different objects for each of the variables. Maybe different bar charts, key indicators can be used? Another way could be to create differnt meassures depending on the contined value and then use these in an bar chart as different measures. In that case tou can create a "total" dimension variable with only one value; "Total". Just my 5 cents, have not tested my thoughts 🙂
... View more
Could it work by create numeric variables of the dates and then use the aggregate table function to get min/max per id, and then calculate the days? BR Fredrik
... View more
One way could be to have three different objects, one for each stage. The objects show the sum of stage1, stage2 and stage3. You can add labels and text to each object to tell what stage is shown. I don't really understand why you need to create a hierarchy, could it not be done just graphically? //Fredrik
... View more
Hi! I don't think it is possible without pre-arranging the data. I usually join the interval-data with a calendar-dataset before loading it to VA, but the data grow very quick 🙂 //Fredrik
... View more
Sorry for late answer, you might already found a fix, but anyways:
Create a textvariable for weekday:
IF ( DayOfWeek('date'n) = 1 ) RETURN 'Sunday' ELSE ( IF ( DayOfWeek('date'n) = 2 ) RETURN 'Monday' ELSE ( IF ( DayOfWeek('date'n) = 3 ) RETURN 'Tuesday' ELSE ( IF ( DayOfWeek('date'n) = 4 ) RETURN 'Wednesday' ELSE ( IF ( DayOfWeek('date'n) = 5 ) RETURN 'Thursday' ELSE ( IF ( DayOfWeek('date'n) = 6 ) RETURN 'Friday' ELSE 'Saturday' ) ) ) ) )
and one for date:
Format('date'n[Raw], 'YYMMDD8.')
And use them instead of the date variables, should work 🙂
//Fredrik
... View more
I think the date format is the problem. Is it possible to create two text objects containing day/week and then use them and the format string? //Fredrik
... View more
Hi! I am not sure about the first one, I don't think its possible, i usually rename the measure to . The second one should be possible if you remove all data references (dimension, measure, filter, rank, etc) on the object and then change the data source and assign measures and dimensions from this new data source. //Fredrik
... View more
Hi!
I did a work around where I used ranking to get the lastest data and also rolling 30 days.
When the users opens the report it always shows the latest data and if they want they can change the date using a drop down.
I added a parameter to the drop down. The purpose is to store the selected date. I set default values to 1939 and 2039.
I then added a data source filter to do the filtering:
date <= [date parameter]
I also created a numeric variable from the date to use in the rankings.
The BANs and the bar charts shows the latest figures using rank (hope you get the swedish :)):
The line chart shows the rolling 30 days also using rank:
Hope this helps you 🙂
//Fredrik
... View more
Hi!
Hope I understand your problem correct 🙂
I did a test using sashelp.class. You can try it yoursellf by importing sashelp.class into VA.
This is the outcome:
On the report there are 2 button bars and 1 cross-tab. All measures are set to average aggregation. I have created 2 new dimensions that are used in the cross-tab. I also created 2 dimension for the choices in the button bars.
I use the button bars to select level of detail for sex and name (using parameters). Depending on their values the drill level will change:
Then create a new report and add the data set.
Then create 2 new dimensions (*_dim, 2 new level choice (*_choice) and 2 paramters (*_level):
Set default value for the parameters to 'Sex' and 'Name'.
Define the sex_dim as:
Create name_dim as:
Create level choice as:
Add two button bars and assign them as:
Add a cross-tab and assign as:
Set all the measures to average aggregation and start testing 🙂
//Fredrik
... View more
![SASGF 2020 [Virtual] Attendee](/html/@A53A708409112314CE528E074D4C8C1F/badge_icons/badge_sasgf20_attendee.png "SASGF 2020 [Virtual] Attendee"){kind=icon}
