全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 SAS专版
1906 0
2017-04-21
各位论坛大神:
今天我用SAS Studio读取excel里面的数据,直接用excel的第三行值作为变量名,但是出来的变量名竟然是带空格和特殊字符的。请大神们指教一下。log如下:

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
55         
56         proc import datafile="/home/weix10/08_DM support/B7601003 AE and condrug.xlsx"
57             out=raw_ae dbms=xlsx replace;
58             getnames=yes;
59             range="AE$B3:";
60             *guessingrows=30000;
61         run;

NOTE:    Duplicate Name Change...  WERE ANY ADVERSE EVENTS EXPERIENCED-DVN -> WERE ANY ADVERSE EVENTS EXPERIE1
NOTE:    Duplicate Name Change...  WERE ANY ADVERSE EVENTS EXPERIENCED-FUL -> WERE ANY ADVERSE EVENTS EXPERIE2
NOTE:    Duplicate Name Change...  IS THE ADVERSE EVENT STILL ONGOING-DVNL -> IS THE ADVERSE EVENT STILL ONGO1
NOTE:    Duplicate Name Change...  IS THE ADVERSE EVENT STILL ONGOING-FULL -> IS THE ADVERSE EVENT STILL ONGO2
NOTE:    Duplicate Name Change...  IS AE A RESULT OF A MEDICATION ERROR-DVN -> IS AE A RESULT OF A MEDICATION 1
NOTE:    Duplicate Name Change...  IS AE A RESULT OF A MEDICATION ERROR-FUL -> IS AE A RESULT OF A MEDICATION 2
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群