SAS中文论坛

 找回密码
 立即注册

扫一扫,访问微社区

查看: 685|回复: 1
打印 上一主题 下一主题

SAS在用EXCEL引擎是如何去掉$?

[复制链接]

49

主题

76

帖子

1462

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1462
楼主
 楼主| 发表于 2007-10-31 19:04:19 | 只看该作者

SAS在用EXCEL引擎是如何去掉$?

例如:
libname test "d:\test.xls";
对生成的三个sheet1$;sheet2$;sheet3$中的符号$如何去掉?
回复 支持 反对

使用道具 举报

49

主题

76

帖子

1462

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1462
沙发
 楼主| 发表于 2007-11-7 15:28:32 | 只看该作者

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 -->
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|小黑屋|手机版|Archiver|SAS中文论坛  

GMT+8, 2026-2-4 10:31 , Processed in 0.068872 second(s), 20 queries .

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表