sas的sql中如何从第3行开始select？（怎么记录行观测号？）

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

请问sas的sql中有没有记录行观测号的变量呢？比如我想从第3行开始select……应该怎么实现？谢谢！

proc sql noprint;
select cat("mean(",compress(name),") as  ",compress(name),"_mean")
into: mean_names        separated by ","
from dictionary.columns
where libname="SASHELP" and memname="CLASS";
quit;
%put &mean_names;

扫码加我 拉你入群

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

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

分享0 收藏2 回帖

关键词：Select Elect sas的 LEC ele sql 如何

1. proc sql noprint;
   
2.         select cat("mean(",compress(name),") as ",compress(name),"_mean")
   
3.                 into: mean_names
   
4.                 separated by ","
   
5.                 from dictionary.columns
   
6.                 where libname="SASHELP" and memname="CLASS" and type="num";
   
7. quit;
   
8. %put &mean_names;

复制代码

老师她摸我 发表于 2012-12-14 16:17

谢谢！但是如果想从第4个开始呢……那……

若水烟寒 发表于 2012-12-14 16:33
谢谢！但是如果想从第4个开始呢……那……

1. proc sql noprint;
   
2.         select cat("mean(",compress(name),") as ",compress(name),"_mean")
   
3.                 into: mean_names
   
4.                 separated by ","
   
5.                 from dictionary.columns
   
6.                 where libname="SASHELP" and memname="CLASS" and varnum ge 4;
   
7. quit;
   
8. %put &mean_names;

复制代码

proc sql noprint;
select cat("mean(",compress(name),") as  ",compress(name),"_mean")
into: mean_names        separated by ","
from dictionary.columns
where libname="SASHELP" and memname="CLASS" and monotonic() >=4 ;
quit;
%put &mean_names;

老师她摸我 发表于 2012-12-14 16:57

谢谢^^~

pobel 发表于 2012-12-14 17:11
proc sql noprint;
select cat("mean(",compress(name),") as  ",compress(name),"_mean")
into: mean_ ...

谢谢~~^^

一种新的技巧:

1. %let i=1;
   
2. proc sql noprint;
   
3.   create table class as
   
4.   select *, resolve('&i. %let i=%eval(&i+1)') as ord
   
5.   from sashelp.class
   
6.   ;
   
7. quit;

复制代码