About HansSteenhuis

HansSteenhuis · ‎09-30-2024

Thank you very much. It worked!

HansSteenhuis · ‎09-30-2024

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).

HansSteenhuis · ‎09-30-2024

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

HansSteenhuis · ‎03-23-2023

Oh I'm using SAS visual Analytics to create the graph (all point and click)

HansSteenhuis · ‎03-23-2023

Yes i'm using SAS Viya to create the graph

HansSteenhuis · ‎03-23-2023

I'm refering to SAS Viya

HansSteenhuis · ‎03-23-2023

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

HansSteenhuis · ‎10-08-2021

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.

HansSteenhuis · ‎10-07-2021

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

HansSteenhuis · ‎10-07-2021

thank you very much

HansSteenhuis · ‎10-07-2021

thank you very much is it possible for this to be a table?

HansSteenhuis · ‎10-07-2021

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

HansSteenhuis · ‎09-10-2020

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

HansSteenhuis · ‎07-23-2019

I have just added a sas table as an example 🙂

HansSteenhuis · ‎07-23-2019

Thanks for your comment. I have added an excel file.

Online Status	Offline
Date Last Visited	‎10-23-2024 08:56 AM

Re: Display the last date of the month

Re: Display the last date of the month

Display the last date of the month

Re: Create a dot graph with a linear line

Re: Create a dot graph with a linear line

Re: Create a dot graph with a linear line

Create a dot graph with a linear line

Re: roll out key value per hour

Re: roll out key value per hour

Re: roll out key value per hour

Re: Display the last date of the month

Re: Display the last date of the month

Display the last date of the month

Re: Create a dot graph with a linear line

Re: Create a dot graph with a linear line

Re: Create a dot graph with a linear line

Create a dot graph with a linear line

Re: roll out key value per hour

Re: roll out key value per hour

Re: roll out key value per hour

Re: roll out key value per hour

roll out key value per hour

IF statement for Excel in EG

Re: Changes within a test number

Re: Changes within a test number