I'm quiet new to the wold of SAS, now I did the following. I have transported a big dataset from SAS EG to SAS VA (7.3). This dataset contains daily measurements like you see below (obviously the dataset is much, much bigger, this is just an example):
ID -- Location -- Section -- Date -- Time -- Type -- Value
Now I want to make a time series plot which shows me the top 4 highest values per day. But it has to be dynamic, I want to use use a selection list which allows me to (de)select a specific vehicle-type (or more). If that vehicle type was measured at least 4 times that day I will automatically get a top 4 of that specific vehicle-type. If not, then obviously the time series plot will give me an error.I then have to select extra vehicle-types to complete a top 4 per day.
It sounds a bit complicated, but the outcome seems very logic, I have a feeling that its possible to workout in SAS VA.
Can someone help me out? I appreciate your help - thank you in advance.
If I understand correctly, what you are asking for is actually rather difficult.
In your data preparation, you could use the RANK procedure to select the top 4 values for each date, but that selection won't be dynamic when you filter by vehicle type.
In VA, you can apply rankings on the Ranks tab. These will be dynamic, but they will be ranking for all time instead of for each day. If you filter your table in VA by date as well as vehicle type, you should get the result you want, but you will only see data for one day at a time.
Someone else might have additional ideas, but this is what I can offer off the top of my head.
Let us know if my understanding above sounds right, and if this info helps.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.