Hello lads,
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
01 -- Germany -- BB --1/1/20 -- 10:10 -- VW -- 9,0
02 -- Germany -- AA --1/1/20 -- 11:20 -- AU -- 7,0
03 -- Germany -- AA --1/1/20 -- 13:50 -- AU -- 6,0
04 -- Germany -- BB --1/1/20 -- 13:50 -- AU -- 5,7
05 -- Germany -- BB --1/1/20 -- 15:10 -- MC -- 11,3
06 -- Germany -- BB --1/1/20 -- 19:10 -- VW -- 12,0
07 -- Germany -- AA --2/1/20 -- 15:20 -- OP -- 6,7
08 -- Germany -- AA --2/1/20 -- 15:20 -- AU -- 2,0
09 -- Germany -- BB --2/1/20 -- 16:16 -- MC -- 1,5
10 -- Germany -- BB --2/1/20 -- 11:45 -- MC -- 5,8
11 -- Germany -- AA --2/1/20 -- 09:40 -- OP -- 2,7
12 -- Germany -- AA --2/1/20 -- 02:40 -- VW -- 2,0
etc...
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.
... View more
