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 ?
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
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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.