_all_应该怎么查看和使用？

若水烟寒

7582

收藏 2012-11-10

_all_表示所有变量的名称，但是我要怎么查看和使用呢？
比如说想统计一下变量的个数，应该怎么操作呢？谢谢！

扫码加我拉你入群

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

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

全部回复

davil2000

2012-11-10 19:14:42

These option has many function.
For example, "put _ALL_ "writes the values of all variables, which includes automatic variables, that are defined in the current DATA step by using named output.

data a;
do i= 1 to 5;
x=sqrt(i);
output;
put _all_;
end;
run;

扫码加我拉你入群

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

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

若水烟寒

2012-11-10 19:37:41

davil2000 发表于 2012-11-10 19:14
These option has many function.
For example, "put _ALL_ "writes the values of all variables, which ...

谢谢！那应该怎么统计有多少个变量呢？（不含自动变量……）
本来是想在宏里面用dim(array)来统计的……结果后来发现宏里面不能用array啊……
https://bbs.pinggu.org/forum.php? ... =2130886&extra=

扫码加我拉你入群

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

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

davil2000

2012-11-10 20:03:55

若水烟寒发表于 2012-11-10 19:37
谢谢！那应该怎么统计有多少个变量呢？（不含自动变量……）
本来是想在宏里面用dim(array)来统计的…… ...

really?

%macro name;
data _null_;
array r(2) x y (1,2);
put _all_;
put 'r(1)='r(1) ' r(2)='r(2);
run;
%mend name;
%name;

扫码加我拉你入群

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

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

obertan

2012-11-10 20:10:51

在ODS中也可以用_all_来关闭所有输出方式，如 ods _all_ close;

扫码加我拉你入群

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

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

davil2000

2012-11-10 20:18:12

data _null_;
dsid=open("sashelp.prdsale");
xxx=attrn(dsid,"nvars");
put "the number of variables is " xxx;
run;

扫码加我拉你入群

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

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

点击查看更多内容…

若水烟寒

2012-11-10 21:37:19

davil2000 发表于 2012-11-10 20:03
really?

%macro name;

I'm sorry, but I can't apply the dim() function in the macro. I can't figure out why. Would you help me to solve this problem? I'm a green hand in this area and I can't thank you more^^
data _null_;
set d1;
array _allvar_(*) _all_;
do i=1 to dim(_allvar_);
vname=vname(_allvar_(i));
put vname=;
end;
run;

%macro name;
data d1;
set d1;
array _allvar_(*) _all_;
%do i=1 %to dim(_allvar_);
vname=vname(_allvar_(i));
put vname=;
%end;
run;
%mend name;
%name;

The error is:

ERROR: 需要的操作符在以下表达式中没有找到: dim(_allvar_)
ERROR: %TO 值（%DO I 循环中）无效。
ERROR: 宏 NAME 将终止执行。

扫码加我拉你入群

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

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

若水烟寒

2012-11-10 21:45:39

davil2000 发表于 2012-11-10 19:14
These option has many function.
For example, "put _ALL_ "writes the values of all variables, which ...

Actually, my attempt was to change the names of a dataset to v1-v5. The original names may not follow a fornula, for example, like "id name age address phone" and so on. How can I program it by the macro method? Thank you !

扫码加我拉你入群

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

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

davil2000

2012-11-11 08:43:04

若水烟寒发表于 2012-11-10 21:37
I'm sorry, but I can't apply the dim() function in the macro. I can't figure out why. Would you he ...

/*If you use _ALL_, all the previously defined variables must be of the same type.*/
data _null_;
set sashelp.prdsale(obs=1);
array  _allvar_(*) _numeric_;
array  _allvar2_(*) _character_ ;
do i=1 to dim(_allvar_);
vname=vname(_allvar_(i));
put vname=;
end;
do i=1 to dim(_allvar2_);
vname2=vname(_allvar2_(i));
put vname2=;
end;
run;

%macro name;
data _null_;
set sashelp.prdsale(obs=1);
array  _allvar_(*) _numeric_;
array  _allvar2_(*) _character_ ;
do i=1 to dim(_allvar_);
vname=vname(_allvar_(i));
put vname=;
end;
do i=1 to dim(_allvar2_);
vname2=vname(_allvar2_(i));
put vname2=;
end;
run;
%mend name;
%name;

扫码加我拉你入群

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

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

若水烟寒

2012-11-11 16:09:22

davil2000 发表于 2012-11-11 08:43
/*If you use _ALL_, all the previously defined variables must be of the same type.*/
data _null_; ...

Thank you very much! But I don't understand why I can't use functions like dim() in the macro loop "%do %to %end". For example, I want to use some macro variables like "&***" in the loop, but at the same time such useful functions are not available for me. In this situation I can't replace it for the data loop. What can I do and how these functions can be used on that condition?

扫码加我拉你入群

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

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

davil2000

2012-11-11 16:23:46

若水烟寒发表于 2012-11-11 16:09
Thank you very much! But I don't understand why I can't use functions like dim() in the macro loop ...

No, u r wrong! Functions like dim() can be definitely used in the macro loop "%do %to %end", but only inside the data step. Besides, the macro loop "%do %to %end" is not permitted to used inside the data loop, but outside.

扫码加我拉你入群

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

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

鼓浪@听涛

2012-11-11 16:26:54

davil2000 发表于 2012-11-11 16:23
No, u r wrong! Functions like dim() can be definitely used in the macro loop "%do %to %end", but ...

really?

扫码加我拉你入群

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

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

若水烟寒

2012-11-11 16:33:23

davil2000 发表于 2012-11-11 16:23
No, u r wrong! Functions like dim() can be definitely used in the macro loop "%do %to %end", but ...

er...But in the following example, isn't the "%do %to %end" used in the data step "data temp"? It seems it works well in the sas...

data temp;
input x1-x10;
datalines;
1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
;
run;
%macro name;
data temp;
set temp;
%do i=1 %to 10;
rename x&i=w&i;
%end;
run;
%mend name;
%name;
proc print data=temp;
run;

扫码加我拉你入群

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

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

davil2000

2012-11-11 16:44:47

若水烟寒发表于 2012-11-11 16:33
er...But in the following example, isn't the "%do %to %end" used in the data step "data temp"? It ...

sorry! I have make a mistake in the expression. The macro loop will disappear after compilatin.
For example, there exists such a macro
%macro name;
data temp2;
set temp1;
%do i=1 %to 2;
rename x&i=w&i;
%put x&i;
%end;
run;
%mend name;

After compilation , it will become

data temp2;
set temp1;
rename x1=w1;
rename x2=w2;
run;

扫码加我拉你入群

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

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

davil2000

2012-11-11 16:47:14

so you can't use functions such as dim() in the macro loop.

扫码加我拉你入群

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

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

若水烟寒

2012-11-11 17:04:15

davil2000 发表于 2012-11-11 16:47
so you can't use functions such as dim() in the macro loop.

Oh, Thank you very much!~~I think I have a long way to go in the sas study....

扫码加我拉你入群

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

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

lqyrendajinji

2012-11-13 04:27:07

thanks thanks thanks

扫码加我拉你入群

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

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

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

分享

扫码加好友，拉您进群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群