Data visualization with SAS programming

Exporting SAS scatterplot into Excel

Occasional Contributor
Posts: 15

Exporting SAS scatterplot into Excel

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;


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!

Trusted Advisor
Posts: 1,270

Re: Exporting SAS scatterplot into Excel

Posted in reply to SASbeginner20


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;


Trusted Advisor
Posts: 3,215

Re: Exporting SAS scatterplot into Excel

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

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 2 replies
  • 1 like
  • 3 in conversation