topic Re: Exporting SAS scatterplot into Excel in Graphics Programming

Exporting SAS scatterplot into Excel

SASbeginner20 — Mon, 04 Aug 2014 16:35:59 GMT

I would like to export my scatterplot generated by SAS into excel. I have read through previous threads and I am still lost on how to do this.

proc gplot data=scatterplot;

plot F*V =S;

run;

My data is grouped data, similar to this: SAS/GRAPH(R) 9.2: Statistical Graphics Procedures Guide, Second Edition

Is there a way to add a line of best fit for each group, one line for Male, and line for Female?

Thanks so much!

Re: Exporting SAS scatterplot into Excel

stat_sas — Mon, 04 Aug 2014 17:09:51 GMT

Hi,

I've used sgplot to do this, may be helpful for the desired results.

proc sgplot data=scatterplot;

reg x=F y=V /LINEATTRS=solid group=s;

run;

Re: Exporting SAS scatterplot into Excel

jakarman — Mon, 04 Aug 2014 17:25:37 GMT

would use the SG proceduers see: ODS Statistical Graphics. What has happened is a silent move of functionality.
"In SAS 9.2, SAS/GRAPH software is required for ODS Graphics functionality. With SAS 9.3, all ODS Graphics capabilities moved to Base SAS."