A Useful tip in writing SAS program ---pipe info into clipboard.

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

I use three fingers for typing and it is hard for me and time consuming.

In SAS, one may pipe some usful information into clipboard and do a <crtl> -v to paste it into the program editor window. Then you can tailor those information and save you a great deal of time in writing programs.

Here is an example.

enter,

<crtl>-v                         *== paste;

in the program editor window after running the program below.

***************************************;
data tmp;
array var(2000);
do i = 1 to 500;
   var(i)=i;
end;
keep var:;
run;

proc sql noprint;
select name  into: vlist1 separated by ' '
from dictionary.columns
where upcase(libname)='WORK' and upcase(memname)='TMP'
         ;
quit;

filename dummy clipbrd;
data _null_;
file dummy;
put "&vlist1";
run;

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：clipboard Program writing useful Board SAS writing tip clipboard pipe

1# bobguy
thank you bobguy
it is very useful,learn more about sql and macro var

学习了。
调用dictionary.columns涉及到view的使用以及对应index的重建，有时候可能比较慢
用proc contents可能会快一点
从库名和表名参数化(宏)可行性来说也都可以实现(两者等价)

楼主，上次在使用你的程序时发生了一点问题，自由度出现了为0的情况，而且t值与P值也无法显示，能否指点一下迷津呢？谢谢！