topic Re: Exported excel files from EG are without Author in SAS Enterprise Guide

Exported excel files from EG are without Author

teltarrass — Wed, 15 Feb 2023 12:57:49 GMT

Trying to Export tables from EG as Excel file, if I chose share then excel I can find the Author on the extracted file,

however if I followed the below steps I can't find the Author

share> export> file tybe: excel

anyone knows how to fix this ?

Re: Exported excel files from EG are without Author

SASJedi — Wed, 15 Feb 2023 14:02:32 GMT

What is there to fix? As you stated, if you choose Share -> Send to Microsoft Excel, the author information is properly populated. If you want more control over the metadata in the Excel file you created, you should look into using code and ODS EXCEL to produce your output. For example:

ods excel file="c:\temp\myExcelReport.xlsx" 
	author="SAS Jedi"
	title="My Cars Report"
	category="Special CARS report"
	comments="See SASHELP.CARS for the source data"
	keywords="CARS REPORT SAS JEDI"
;
ods excel options(sheet_name="Detail Report");
ods noproctitle;
proc sql;
select * from sashelp.cars;
quit;
ods excel options(sheet_name="Summary Stats");
proc means data=sashelp.cars min mean median max;
	var MSRP MPG_Highway;
	class Origin;
run;
ods excel close;

Produces a nice Excel report with this metadata:

May the SAS be with you 😁

Mark

Re: Exported excel files from EG are without Author

teltarrass — Thu, 16 Feb 2023 08:22:59 GMT

Thank you Mark, really appreciate your response, will try to use this workaround , however I need to force the users to have the Author and remove any other options for them, any idea if this even something can be fixed ?

Re: Exported excel files from EG are without Author

SASJedi — Thu, 16 Feb 2023 13:10:39 GMT

I guess I'm not understanding the dilemma here. Why not tell just them to use Share -> Send to Microsoft Excel to produce Excel files? The feature you want is already there. As far as I can determine, there is nothing that needs to be "fixed". The details of what is currently happening that produces an incorrect result (describe the process, what's wrong, and the ideal result) and why the already-provided option isn't resolving the problem would be helpful.