标题: SAS在用EXCEL引擎是如何去掉$？ [打印本页] 作者: shiyiming 时间: 2007-10-31 19:04 标题: SAS在用EXCEL引擎是如何去掉$？ 例如：
libname test "d:\test.xls";
对生成的三个sheet1$;sheet2$;sheet3$中的符号$如何去掉？作者: shiyiming 时间: 2007-11-7 15:28 标题: to zhiyong75 似乎是去不掉的
[quote:wzxuat69]What you are seeing in the SAS Explorer window are either Excel spreadsheets or named ranges. In Excel, a name range is a descriptive name that represents cells, ranges of cells, formulas, or constant values in an Excel file. You can see what name ranges are in an Excel file by clicking the Name box at the left end of the formula bar. Since a name range and a spreadsheet can have the same name, Excel adds a '$' to the end of a spreadsheet name. SAS can import both name ranges and entire spreadsheets, so this is what you are seeing in the Explorer window. Any table name that ends in a '$' is the spreadsheet, and a name without a '$' is a name range.[/quote:wzxuat69]
<!-- m --><a class="postlink" href="http://support.sas.com/kb/13/050.html">http://support.sas.com/kb/13/050.html</a><!-- m -->