SAS Support Communities

rjassem1 · ‎02-11-2021

For now, I might just do an overall aggregate and make a note that that this is an overall number and does not change using the drop-down filters.

rjassem1 · ‎02-11-2021

I'm trying to think this through. The dates from the first year are fixed because it happened in the past but the dates for the 2nd year are updated daily so every day there is a new max date.

rjassem1 · ‎02-08-2021

This question is a little bit tricky. I'm trying to get the difference between the last head count for term one and the last head count for term two knowing that Head Count is a sum of individual registrations for that day. What this chart is doing is pulling daily enrollment. Daily enrollment increases by day and includes a sum of all individual registrations for that day. The initial solution was to use Parallel Period and attempt to rank BUT we can't rank by most recent date because the max date is different between the two so Rank shows the most recent date that applies to both terms which is incorrect and if I change rank so it has the most recent date then the head count of the 2nd term would be excluded. The other solution was to use an aggregate table BUT that would only work if we don't apply drop-down filters. If we add the drop-down filters then we end up in square one. I tried using Max in a calculate item but I keep getting errors about a boolean value. How do I get the latest number for term one form the chart below - the latest number for term two while having the numbers change depending on the drop down selections? I feel that there must be a logical way to do this. Any ideas are appreciated!

rjassem1 · ‎02-08-2021

Thanks! I will try this. I'm assuming though the SAS VA 8.4 time series chart will accept the DATE5. format from the dataset since there is no DATE5. format within SAS VA that I could find and that the time series will sort DATE5. correctly.

rjassem1 · ‎02-05-2021

Thank you for responding so quickly! Right now my list is short so it's manageable but it wouldn't be as you mentioned with 365 values. Is there any way to customize the date further? I'm wondering why there is no day/month format in SAS. It seems like a feature we would want in a time series?

rjassem1 · ‎02-05-2021

Actually, I found a workaround using custom sort by right clicking on the variable under the data section. All is good now! But ideally, another solution would be better but this works!

rjassem1 · ‎02-05-2021

I actually found a way around it and created a MON-Day string format and used that in a line chart BUT I can't sort it. It was initially something like 1-Jun but then I changed in to Jun-1 so I could sort better but obviously it's still not sorted correctly. Line charts, it seems, don't have the ability to sort by a hidden variable as a drop-down object would. any workarounds for this?

rjassem1 · ‎02-05-2021

I'm wonder if it it possible to display a day and month only as a date in a time series chart? As an example, 1Apr 2Apr 3Apr etc I can't seem to find that format. If not, is there another way to achieve this? Because we are trying to compare 1Apr from 2019 for example to 1Apr 2020 so we can't include the years. Or do you think that I should just convert to a categorical value and use that in a line chart? This is in SAS VA 8.5 or SAS Viya 3.5

rjassem1 · ‎11-06-2020

Hi Sam, It worked. Thank you! I need to narrow it down but it works.

rjassem1 · ‎11-04-2020

I'm hoping I can find a solution here to a problem I'm having with Geo Networks. The goal is to find out which county students came from and where they are working. Both source and target are geography items. Source is based on county code and target is based on state 2-letter abbreviation. I can't see any lines. As I'm typing this, I'm wondering if it's because they both belong to different providers?

rjassem1 · ‎04-06-2018

Thank you. Approach 2 seems to cause some problems. Approach 1 works except that I can't change the background for unpopulated columns but I can make it smaller so that the grey doesn't show that much and the scroll bars don't show.

rjassem1 · ‎04-06-2018

I'm using a text object and there aren't really any options there. I noticed that there are a lot of features that are no longer available in 8.1. I did a workaround. I wanted to display a percentage so I had to create a custom category variable with the sub-categories I wanted to count then created a measure for the percent of the sub-categories in relation to all the categories. I added that measure to the gauge and adjusted the rules with a max of 100 or actually 1. It seems like a lot to get a simple percentage! That being said, I wish it could have just been in a text box.

rjassem1 · ‎04-06-2018

We have 8.1. I tried adding a measure to a role for a text box but it says "roles cannot be applied to the selected object"

rjassem1 · ‎04-06-2018

I ended up creating a percentage and adding it to the gauge and creating another measure with a value of 100 and adding it to the gauge. I wish I could just add a number in a text box.

rjassem1 · ‎04-06-2018

I can't seem to add a single number in a report in SAS VA/Viya 8.1. Then I tried using a gauge but it doesn't seem to work with percentages and the filter doesn't apply since the min and max values are fixed. Any idea how I can add a percentage as a single value in a report?