Exported excel files from EG are without Author

[teltarrass]

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 ?

[SASJedi]

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

[teltarrass]

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 ?

[SASJedi]

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.