[统计软件] 求助，急，sas，非常感谢 [推广有奖]

1关注
0粉丝

硕士生

77%

还不是VIP/贵宾

威望: 0 级
论坛币: 53 个
通用积分: 1.0000
学术水平: 0 点
热心指数: 0 点
信用等级: 0 点
经验: 10400 点
帖子: 56
精华: 0
在线时间: 244 小时
注册时间: 2011-12-30
最后登录: 2023-8-23

楼主

左岸光华 发表于 2016-7-20 20:11:54 |AI写论文

5论坛币

需要导入的数据大于256列，用如下方法导入无法使变量名变成中文的，非常感谢，请教大家！
options validvarname=any;
PROC IMPORT OUT= WORK.A
         DATAFILE= "E:\a.xlsx"
         DBMS=xlsx REPLACE;
   RANGE="Sheet1$";

RUN;

最佳答案

见路不走查看完整内容

The intent of the VALIDVARNAME=ANY system option is to enable compatibility with other DBMS variable (column) naming conventions, such as allowing embedded blanks and national characters. Throughout SAS, using the name literal syntax with variable names that exceed the 32-byte limit or have excessive embedded quotation marks might cause unexpected results. 以上是SAS官方说明书，看来是变量名溢出了

分享0 收藏0 回帖

关键词：非常感谢 options replace import Option 中文

相关帖子

沙发

见路不走

发表于 2016-7-26 15:11:11

The intent of the VALIDVARNAME=ANY system option is to enable compatibility with other DBMS variable (column) naming conventions, such as allowing embedded blanks and national characters. Throughout SAS, using the name literal syntax with variable names that exceed the 32-byte limit or have excessive embedded quotation marks might cause unexpected results.
以上是SAS官方说明书，看来是变量名溢出了