SAS studio读取excel后出来的程序名非法

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

各位论坛大神：
今天我用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

扫码加我 拉你入群

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

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

关键词：Studio EXCEL xcel exce dio excel