topic Proc means output in SAS Programming

Proc means output

Biniie — Tue, 14 Jan 2020 17:07:23 GMT

I have a dataset ds1. I want to have a list, that shows me how many missing values there is per (numeric) variabel. I know I can get this by simply using a proc means:

data ds1;
input kon $ age ss;
cards;
M 20 1
K 22 2
M 24 2
M . .
K . .
. . .
;
run;

proc means data=ds1 NMISS N;
run;

But is it possibel to get the exact result output (se attachments) I get from the proc means into a actual dataset, so I use that for further analysis? I want to use it to calcute late the response rate for each variabel/question.

Re: Proc means output

novinosrin — Tue, 14 Jan 2020 17:17:02 GMT

Are you asking for OUTPUT OUT statement in proc means?



data ds1;
input kon $ age ss;
cards;
M 20 1
K 22 2
M 24 2
M . .
K . .
. . .
;
run;

 

proc means data=ds1 NMISS N;
output out=want nmiss= n=/autoname;
run;

Re: Proc means output

Biniie — Tue, 14 Jan 2020 17:24:46 GMT

Well, not exactly. The output out function gives me the type of data, that I need, but I would like to have one row per variabel, that contains the number of missing and non-missing values for each variabel - just like the "plot" you get in the result window (or see the attached file) when you run the proc means statement.

Re: Proc means output

novinosrin — Tue, 14 Jan 2020 17:29:40 GMT

Okay How about proc freq nlevels

data ds1;
input kon $ age ss;
cards;
M 20 1
K 22 2
M 24 2
M . .
K . .
. . .
;
run;
  ods output nlevels=want;
  proc freq data=ds1 nlevels;
     tables  age ss / noprint;
  run;