https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-to-Excel-from-UNIX-Enviroment/m-p/7628#M2778 Has anyone had luck using ods to move data to an Excel sheet directly from a UNIX enviroment. I know it is very easy to do locally(PC SAS), but want to automate the output directly from UNIX. <BR /> Thanks Mon, 24 Mar 2008 17:50:37 GMT deleted_user 2008-03-24T17:50:37Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-to-Excel-from-UNIX-Enviroment/m-p/7628#M2778 Has anyone had luck using ods to move data to an Excel sheet directly from a UNIX enviroment. I know it is very easy to do locally(PC SAS), but want to automate the output directly from UNIX. <BR /> Thanks Mon, 24 Mar 2008 17:50:37 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-to-Excel-from-UNIX-Enviroment/m-p/7628#M2778 deleted_user 2008-03-24T17:50:37Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-to-Excel-from-UNIX-Enviroment/m-p/7629#M2779 Hi:<BR /> If you have SAS/Access for PC File Formats on your UNIX system, then see Example 2 at this Tech Support note site:<BR /> <A href="http://support.sas.com/documentation/cdl/en/acpcref/59619/HTML/default/a002644677.htm" target="_blank">http://support.sas.com/documentation/cdl/en/acpcref/59619/HTML/default/a002644677.htm</A><BR /> <BR /> Otherwise, if you do not have SAS/Access for PC File Formats on your UNIX system, then your choices are to use PROC EXPORT to create a CSV (comma separated value file) or to use ODS to create either a CSV file (ODS CSV) or TAGSETS.EXCELXP to create a Spreadsheet Markup Language (XML) file. Since the CSV or XML files are both ASCII text files, you should be able to FTP them from UNIX to Windows with no problems.<BR /> <BR /> For more help with this task, you might consider contacting SAS Technical Support.<BR /> <BR /> cynthia Mon, 24 Mar 2008 17:58:33 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-to-Excel-from-UNIX-Enviroment/m-p/7629#M2779 Cynthia_sas 2008-03-24T17:58:33Z