_all_应该怎么查看和使用？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

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

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：怎么操作 统计

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;

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=

若水烟寒 发表于 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;

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

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

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 将终止执行。

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 !

若水烟寒 发表于 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;

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?