[求助]如何让生成的dataset和output一致呢？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

code 如下：

proc means data=dataset n nmiss min p5 p10 p25 p50 p75 p90 p95 max mean std;
var _numeric_;
output out=dataset2;
run;

新生成的dataset2 和sas 程序跑出来的output 不一样，dataset2 里只有 N min max mean median std, 缺少p5 p10 p25 等等

如何让生产的dataset  和跑出来的output 一样？

请各位热心的朋友解答一下，谢谢！

扫码加我 拉你入群

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

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

分享0 收藏0 回帖

关键词：dataset output outpu DataS Data output dataset

data dataset;

dataset;

input x y;

x y;

cards;

1 2

1 2

1 3

;

;

1 2

1 2

1 3

;

proc means data=dataset n nmiss min p5 p10 p25 p50 p75 p90 p95 max mean std;

means data=dataset n nmiss min p5 p10 p25 p50 p75 p90 p95 max mean std;

var _numeric_;

_numeric_;

output out=dataset2 n=n nmiss=nmiss min=min p5=p5 p10=p10 p25=p25 p50=p50 p75=p75 p90=p90 p95=p95 max=max mean=mean std=std;

out=dataset2 n=n nmiss=nmiss min=min p5=p5 p10=p10 p25=p25 p50=p50 p75=p75 p90=p90 p95=p95 max=max mean=mean std=std;

run;

;

*there, if without specifying anything in output statement, dataset2 would only include the default statistics, which is nothing to do with your

specification in means statement;note that, the name of statistics is arbitrary, for example, you can say, n=sample p25=q1, and so on;

*thanks;

i find that all my replies are not exactly shown the same as I hoped. please take your own judgement for that.

basically,

proc means data=dataset; *you don't need to write those statistics here;
  var _numeric_;
  output out=datasets
            n=sample nmiss=Nmissing min=minimum max=max p5=p5 p10=p10 p25=q1 p75=q3 p50=median p90=p90 mean=average std=std;
            *you have to list all what you want here otherwise you will get the default statistics about which you were complaining;
            *arbitrary names,but you have to correctly spell the statistic names;
run;

thanks,

学习了

谢谢。 知道了

大哥这个运行出来只有一行啊,请高手再解答下吧.

Thanks for your reply, however your code seems not slove my problem. I want the new dataset has all the numeric variables with their min p5 p10 p25 ....etc.  Using your codes, I just get one row in my new dataset, and this new dataset is still different from my output.

Please give your further suggesiton, thanks!

[em10]