topic Re: Basic description of many variables in one Proc command. in SAS Procedures

Basic description of many variables in one Proc command.

GKati — Tue, 23 May 2017 11:32:55 GMT

Hi All,

I have 30+ variables called client1, client2, client3, etc. I would like to see a basic description of these variables (no of obs, mean, min, max, etc.) but using only one PROC command, so I don't have to type it up 30+ times.

How would I do this efficiently?

Thanks,

Re: Basic description of many variables in one Proc command.

PeterClemmensen — Tue, 23 May 2017 11:47:02 GMT

Like this?

ods select variables;
proc contents data = sashelp.cars;
run;

Re: Basic description of many variables in one Proc command.

Kurt_Bremser — Tue, 23 May 2017 11:47:21 GMT

proc means:

proc means data=sashelp.class;
var _numeric_;
run;

If you need more statistics, add them in the proc means statement.

Re: Basic description of many variables in one Proc command.

RW9 — Tue, 23 May 2017 11:57:43 GMT

Just to add @Kurt_Bremser, as they have not provided the dataset (as always), we are guessing that there is only those variables in there. It may be simpler if there are other numeric variables to take:

proc means data=sashelp.class;
  var client:;
run;

Alkthough of course if there are other variables with client prefix then that is also a problem

Re: Basic description of many variables in one Proc command.

GKati — Tue, 23 May 2017 12:00:31 GMT

Thanks for your help. I have other variables as well, but only those with the prefix client.