About Elle

Elle · ‎05-17-2017

I don't know how to explain it in a simpler way. I want to highlight some points on the price series with different colours. I want to graph the Price and then overlay the points found in Signal variable. I want to highlight on the price series when an orange signal is given (orange dot), I want to show the significant spikes in prices (grey dots) and then finish with a green signal (green dot) to show the price has stabilized. Your code gives me the attached result. ...I've attached a sample of data, maybe it will become clearer why this code won't work.

Elle · ‎05-17-2017

I edited my graph in Paint to show how I want it to look like (attached)

Elle · ‎05-17-2017

This wouldn't work, as I need the Close Price on Y2. I did post a photo on how my graph looks like. I'm happy with the way it looks. I just want the writing for Orange Signal/Green Signal/Low Return/High Return to have different colours and different coloured markers

Elle · ‎05-17-2017

Ok, I thought those were PROC SGPLOT options. My mystake. The resulting graph looks weird however.

Elle · ‎05-17-2017

The data is a simple stock market data with a date variable, volume and close price. My Signal variable is a simple numeric variable =( . , 0 , 1 , 2 , 10 ) with a format attached to it. It is supposed to highlight important changes in Close Price.

Elle · ‎05-17-2017

STYLEATTRS gives an error. ERROR 22-322: Syntax error, expecting one of the following: ;, ASPECT, CYCLEATTRS, DATA, DATTRMAP, DESCRIPTION, NOAUTOLEGEND, NOBORDER, NOCYCLEATTRS, NOOPAQUE, NOSUBPIXEL, NOWALL, OPAQUE, PAD, PCTLEVEL, PCTNDEC, RATTRMAP, SGANNO, SUBPIXEL, TMPLOUT, UNIFORM.

Elle · ‎05-17-2017

Hello, I have some stock market data that I've put on a graph. PROC SGPLOT DATA=HC2016 (WHERE=(Date=&d)); XAXIS VALUES=(&start TO &finish BY MINUTE) INTERVAL=MINUTE; SERIES X=DT Y=Volume / LEGENDLABEL="Volume"; SERIES X=DT Y=Close / Y2AXIS LEGENDLABEL="Close Price" DATALABEL=Signal markers; RUN; My Signal Variable has the following values: 0 (Orange Signal), 1 (Low Return), 2 (High return), 10 (Green Signal) I would like to know how to colour the markers by Signal values. I want the "Orange Signal" value to be orange, the "Green Signal" value to be green and everything in between to be grey. How do I change my syntax? Also, how do I change the F6 and F7 values with Volume and Close Price?

Elle · ‎02-24-2017

Thank you for your post, but I cannot use any form of data steps, procedures or statements in MIP. ONLY functions.

Elle · ‎02-24-2017

Hello, I'm using SAS Model Implementation Platform and need to integrate some Base SAS code in order to do some calculations. I would like to know if there's a function equivalent for this: proc sql; select SUM(subaccount_EAD) as account_EAD from table group by account_number; quit; My variables are: account_number, subaccount_number and subaccount_EAD. I'm looking for a function like: sumby.account_number(subaccount_EAD) if such a thing even exists. I cannot use data steps or proc sql in MIP. So, ... help?

Elle · ‎11-23-2016

Hello, I appreciate you answering me, but this isn't what I'm looking for. Sure, I want to split Mass into ranges, but how do I determine those ranges? I want to split Mass in such a way that each mass range gets associated with each Name level. So, let's say Mass ranges from 1 to 1600. I want to be able to say mass1 (1 - 100) is associated with Name=A1, mass2 (201-300) is associated with Name=A2, and so on... that makes me think, maybe I could pull this off by using a decision tree, where Name is the target and Mass is the feature...

Elle · ‎11-23-2016

I would like to perform an ANOVA analysis with a blocking variable. My dependent variable would be Intensity (interval) My independent variable is Name (A1 through A16) And my blocking variable would be mass (interval). In order to use mass as a blocking factor, I would have to transform it into a categorical variable. Basically, I would like to do something similar to an Interactive Grouping (EM) for Mass in Base SAS depending on the values for Name. I need to know which mass intervals are associated with which names. Any ideas? Thanks

Elle · ‎10-18-2016

Hello, Yes I have Visual Statistics, but passing to linear regression switches my response variable with the explanatory variable and everything gets duplicated, which is a major inconvenience since there are a lot of scatter plots generated at a high frequency. This option would be perfect if somehow I could program VA to do it automatically whenever a scatter plot is created. Any thoughts on that?

Elle · ‎10-17-2016

Hello, I'm doing a scatter plot with a linear fit line. I would like to export (in whatever format) the Details, more specifically the equation that's being generated, correlation coefficient and R-square. I need to use the estimates in another calculation. Does anyone have any ideas on how to do it? Thank you

Elle · ‎10-12-2016

Hello, I have a dataset that I would like to visualize in VA in the following way: I want a regression line per block of data (by chemical compound and by experiment number). My regression is: Concentration=Intercept+Slope*Area. What I need is a big graph that will be split into little squares and every square should contain a linear regression per block of data. Here is an approximate image of what it should look like (please ignore values and names in the graphs): COMPOUND 1 COMPOUND 2 Experiment 1 Experiment 2 Experiment 1 Experiment 2 Is it possible to do something like this in VA? I would also like to know how to automatically print the regression equation on each graph (or underneath it).

Elle · ‎08-17-2016

The 5 tables are delivered to my supervisor that wants to validate my work. I'm validating it beforehand to make sure he doesn't get any strange results. Thank you for the input. I think I'll use macro variables to check the sums.

Online Status	Offline
Date Last Visited	‎08-19-2021 10:07 AM

Re: array length

Re: array length

Re: Recode values of a character variable to make it sas friendly for ...

Re: Recode values of a character variable to make it sas friendly for ...

Recode values of a character variable to make it sas friendly for proc...

Re: How to automatically define macro variables (names and values) bas...

Re: How to automatically define macro variables (names and values) bas...

How to automatically define macro variables (names and values) based o...

Re: Complete list of Nodes in SAS Enterprise Miner

Re: Help with RETAIN

Re: Help with RETAIN

Re: Help with RETAIN

Re: Help with RETAIN

Re: Help with RETAIN

Re: Is proc means syntax different when working with hadoop data?

Re: array length

PROC SQL: Sum column totals over multiple tables

Re: How to format dates in PROC SQL outside the SELECT statement ?

Re: Choosing between and evaluating ARIMA / ESM / UCM for a model with...

Re: Macro syntax error %SCAN used in %DO loop

Re: PROC SGPLOT SERIES: Colour markers by variable values

Re: PROC SGPLOT SERIES: Colour markers by variable values

Re: PROC SGPLOT SERIES: Colour markers by variable values

Re: PROC SGPLOT SERIES: Colour markers by variable values

Re: PROC SGPLOT SERIES: Colour markers by variable values

Re: PROC SGPLOT SERIES: Colour markers by variable values

PROC SGPLOT SERIES: Colour markers by variable values

Re: In search of a Base SAS function: SUM BY GROUP

In search of a Base SAS function that does a SUM BY GROUP

Re: Use a categorical variable to split a numeric variables into inter...

Use a categorical variable to split a numeric variables into intervals

Re: VA Exploration: How to export Details section?

VA Exploration: How to export Details section?

Visualising multiple (linear) regression lines in the same graph

Re: PROC SQL: Sum column totals over multiple tables