thank you for your response. I'm using Visual Analytics (VIYA). It concerns the last day of the month. I only want to see the dates highlighted in yellow (see image).
... View more
Hello everyone, Is it also possible in SAS VIYA to display the last date of the month? I currently have a table with various dates and values. However, I only want to see the last day of the respective month. Is this possible in SAS VIYA? In any case, thank you for the responses. Regards, Hans
... View more
does this graph also exist in SAS VIYA? Or can I make it myself? On the x line I need the dates. On each day there are several points of the starting times. I'm using the scatter chart now, but how can I get that linear line? see example how it should be
... View more
Thank you very much, great! If I have a start time of 21 and it runs for 8 hours. Then the code continues to count. Can that also be solved? A test can never last longer than 24 hours.
... View more
I do not get it I use this table: Then i use this code: data have;
infile datalines dsd dlm=" ";
input test_number $ hours start_hour key_value;
datalines;
23 0 .
21085484 5 13 .8
25874521 3 15 .75
;
data long;
set _TEST_FORUM;
do hr = start_hour to start_hour + hours - 1;
output;
end;
run;
proc transpose
data=long
out=want (drop=_name_ where=(test_number ne " "))
;
by test_number hours start_hour;
var key_value;
id hr;
run; But now I only get errors I must be doing something wrong
... View more
Hello everyone, Is it possible in EG to create a formula in the red marked columns? (attachment in excel) So that the "key value" is filled at the hour of the column "start hour" and that it is expanded with the number of hours of the column "amount of hours" see also the attachment in excel. thank you so much for the comments
... View more
Hello everyone,
Is it possible to apply this function that I have in Excel in EG?
NUMBER
CODE
IF statement
1410647
313
1410647
322
313
1411948
313
1411948
320
313
1411950
322
1411950
303
322
1412210
318
1412210
313
318
1412210
320
313
1412210
312
320
1598745
314
1598745
380
314
1598745
312
380
1598745
314
312
1598745
380
314
1598745
380
380
1598745
314
380
1598745
380
314
regards,
Hans
... View more