proc sql出错

dxystata

2028

收藏 2016-12-07

悬赏 30 个论坛币已解决

%let nby=4;
proc sql 中
select count(*) into: pp1-:pp&nby

标红的有空格出错，谢谢！

最佳答案

不是吧258123 查看完整内容

%let nby=4; proc sql 中 select count(*) into: pp1-:pp%sysfunc(left(&nby)) 就可以了

扫码加我拉你入群

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

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

全部回复

不是吧258123

2016-12-7 22:03:31

%let nby=4;
proc sql 中
select count(*) into: pp1-:pp%sysfunc(left(&nby))
就可以了

扫码加我拉你入群

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

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

hplcdadong

2016-12-7 23:38:20

Possible reason:
select count(*) only generate one number, you could not put it into multiple macro variables.

If you really want to store this count number into a macro variable, you could :

                        proc sql;
                        select count(*) into: pp
                        from ...

If you, for example , want to store the first 4 unique IDs into 4 different macros, you could:

                           %let nby=4;
                           proc sql noprint;
                           select distinct id into: pp1 - :pp&nby
                           from ...