topic Re: Create a dot graph with a linear line in SAS Viya

Create a dot graph with a linear line

HansSteenhuis — Thu, 23 Mar 2023 12:23:58 GMT

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

Re: Create a dot graph with a linear line

BrunoMueller — Thu, 23 Mar 2023 12:57:10 GMT

Are you referring to SAS Visual analytics or some SAS program using Proc SGPLOT?

Re: Create a dot graph with a linear line

HansSteenhuis — Thu, 23 Mar 2023 13:04:53 GMT

I'm refering to SAS Viya

Re: Create a dot graph with a linear line

BrunoMueller — Thu, 23 Mar 2023 13:11:06 GMT

Are you using SAS visual Analytics to create the graph (all point and click) or are you writing a SAS program?

Re: Create a dot graph with a linear line

HansSteenhuis — Thu, 23 Mar 2023 13:12:36 GMT

Yes i'm using SAS Viya to create the graph

Re: Create a dot graph with a linear line

BrunoMueller — Thu, 23 Mar 2023 13:48:01 GMT

SAS Viya as answer does not help much.

To create the graph are you using code like this:

proc sgplot data=sashelp.stocks;
  where
    stock = "IBM"
    and year(date) between 2004 and 2006
  ;
  scatter x=date y=close / ;
  reg x=date y=close / ;
run;

Creating this

Or another way?

Re: Create a dot graph with a linear line

HansSteenhuis — Thu, 23 Mar 2023 15:02:10 GMT

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

Re: Create a dot graph with a linear line

BrunoMueller — Tue, 28 Mar 2023 07:32:08 GMT

In SAS Visual Analytics, the Scatter plot supports a "Fit Line", use either the right mouse button or the options pane to add it.

See https://documentation.sas.com/doc/en/vacdc/default/vaobj/n02h2a3i8htlhln1o4ngyz6f1ox5.htm#p0bvwvf3yyxx1bn18whdz89b78ub for more details

However the Scatter plot only supports measures. So currently there is no point and click way of creating such a graph using a measure and a date.

You could use the TreatAs operator to convert the date to a measure and then use it in the scatter plot, but you will loose the date information, but you would see the data points as well as the fit line.

Then there is always the Data Driven Content object that will allow to use for instance D3.js to do something like this or run some SAS code and generate a graph.