topic Re: export graphs to doc file in SAS Programming

export graphs to doc file

Barkamih — Thu, 30 Nov 2017 13:53:53 GMT

Hi guys

I just wanted to export this graph to the word file, I tried to do it with this code. the code was correct but the graph does not appear in the word file.

ods html file = ' C:\Users\Barkamih\Desktop\fat % ods\ proteina curve1.doc';
proc gplot data=fit;
title1' Lactation curve of milk fat depression ';
	plot pred*time TEST_DAY_PROT_PERCENT*time/overlay;
run;quit;
ods html close;

kind regards

Ibrahim

Re: export graphs to doc file

collinelliot — Thu, 30 Nov 2017 14:01:09 GMT

Use ODS RTF, not HTML.

Re: export graphs to doc file

Kurt_Bremser — Thu, 30 Nov 2017 14:13:31 GMT

You are not creating a Word document file. You are writing a HTML file that is incorrectly named with a .doc extension.

HTML files do not embed graphics, they contain links to those graphics, and have them loaded separately by the user agent (usually a browser). This means you also have to make sure that the graphics are stored in a way that the link can be resolved when an application opens the HTML. Make proper use of the path= and gpath= options of the ods html statement, and the (url=) suboption for those.

Re: export graphs to doc file

Barkamih — Thu, 30 Nov 2017 14:25:59 GMT

this is my path file

C:\Users\Barkamih\Desktop\fat % ods

could you please write the correct code for this action, because I'm new in sas

best regards

Ibrahim

Re: export graphs to doc file

Kurt_Bremser — Thu, 30 Nov 2017 14:44:30 GMT

ods rtf file = 'C:\Users\Barkamih\Desktop\fat_ods\proteina_curve1.rtf';

title1' Lactation curve of milk fat depression ';

proc gplot data=fit;
plot pred*time TEST_DAY_PROT_PERCENT*time/overlay;
run;

ods rtf close;

Do NOT use blanks or special characters in file or path names. They are never necessary and only cause confusion and work that can easily be avoided.

Re: export graphs to doc file

Barkamih — Thu, 30 Nov 2017 15:49:08 GMT

Thank you so much
I appreciate that
thank you again
regards