Hi!
If you have the SAS Add-in for Microsoft Office, then you can select either variable names or labels to appear in Excel when you access a SAS data source.
If you know about using ODS CSV, then there is another alternative available to you. Microsoft wrote and supports a standard called Spreadsheet Markup Language (SpreadsheetML), which is an XML representation of an Excel workbook/worksheet. ODS supports creation of a SpreadsheetML XML file starting in SAS 9 using the following syntax:
[pre]
ods tagsets.excelxp file='c:\temp\testML.xls'
style=sasweb;
proc print data=sashelp.shoes(obs=10) label;
var region subsidiary product sales;
run;
proc means data=sashelp.shoes min median mean max;
var sales;
class region;
run;
ods tagsets.excelxp close;
[/pre]
If you have SAS 9 and Excel 2002 or higher, you should be able to open this file with Excel and see the labels in the proc print output. You should be able to name the file with a .xls extension on Windows and have Excel open the file with no problems. Users can make changes, etc and then when they save, they can either choose to save as "native" .xls format or choose to retain the XML format.
You can find out more about the ExcelXP tagset on the ODS Community web site at:
http://support.sas.com/rnd/base
and follow the links to ODS MARKUP and the ExcelXP tagset.
cynthia