sas中的rename

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

求高手！
我想问一下，sas中的rename有时候怎么不好用？
proc import out=temp datafile='E:\新数据\干燥.xls' dbms=excel replace;
getnames=yes;sheet='sheet5$';
run;
data temp1;set temp;keep=ttwd1  sdz1;rename ttwd1=ttwd  sdz1=sdz;run;
这时候输出的数据集
            


为什么显示的变量还是ttwd1和sdz1？？此时变量的属性中Name为ttwd，Label为ttwd1.求解！十分感谢！

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：rename name ENA replace import replace import excel

因为显示的是label，在查看里勾选列名就显示列名。

remove the "=" in keep=ttwd1  sdz1; It's a error.

If you want to remove the labels in data set, try this way:

* Remove all the labels in data set;
proc datasets lib=work memtype=data;
  modify your_data_set;
  attrib _all_ label=' ';
run;

Sorry, cannot type Chinese on my computer

wwd1015 发表于 2012-9-20 22:04
remove the "=" in keep=ttwd1  sdz1; It's a error.

If you want to remove the labels in data set,  ...

Thanks very much.But I have to ask you another question.
The following codes run successfully,but the 'attrid' is in red colour,why?Are they right?The log does't show any error.
proc datasets lib=work memtype=data;
modify temp1 ;
attrib ttwd label='ttwd ' sdz label='sdz';
run;

usm007 发表于 2012-9-20 22:00
因为显示的是label，在查看里勾选列名就显示列名。

十分感谢。不过是不是我太笨了？我怎么没在sas中找到查看选项那？求解！

fyfzhdsfdx 发表于 2012-9-21 10:00
Thanks very much.But I have to ask you another question.
The following codes run successfully,but ...

Well, sometimes the SAS Enhanced Editor syntax coloring feature doesn't work correctly, so don't worry too much about the 'red' color. The attrid statement here is definitely right and you can check the link below
http://support.sas.com/documenta ... .htm#a003185601.htm

Thanks

wwd1015 发表于 2012-9-21 22:30
Well, sometimes the SAS Enhanced Editor syntax coloring feature doesn't work correctly, so don't w ...

Thank you very much.

rename语句无论放在code的哪里, 总是最后才在pdv中起作用的

wwd1015 发表于 2012-9-20 22:04
remove the "=" in keep=ttwd1  sdz1; It's a error.

If you want to remove the labels in data set,  ...

您好，我想问您一个问题，sas里的逻辑库还能改名字吗？

wwd1015 发表于 2012-9-20 22:04
remove the "=" in keep=ttwd1  sdz1; It's a error.

If you want to remove the labels in data set,  ...

就是将原逻辑库的名字换一个，路径不改变，只是改名字，比如一个逻辑库叫aa，我现在想把它改为a，应该是怎么样一个程序呢，拜托了，谢谢~~