topic Re: Proc tabulate : cv in Statistical Procedures

Proc tabulate : cv

SASdevAnneMarie — Mon, 16 Feb 2026 16:05:14 GMT

Hello Experts,

I'm wondering if it is possible to calculate the cv wit proc tabulate for all variables.

When i try my code it does not work :


proc tabulate data=bdd;
	class departement;
	var _all_;
	table nom_departement, (_all_)*cv;
run;

Thank you for your help!

Re: Proc tabulate : cv

Sa_S — Mon, 16 Feb 2026 16:15:13 GMT

Hi @SASdevAnneMarie ,

you can use _NUMERIC_ (not _ALL_) because variables listed in the VAR statement of PROC TABULATE must be numeric, and CV is a valid TABULATE statistic keyword.

proc tabulate data=bdd;

class nom_departement;

var _numeric_;

table nom_departement, (_numeric_)*(cv);

run;

Please consider the following documentation for additional details:

SAS Elementary Statistics Procedures : Keywords and Formulas
SAS Help Center: Syntax: PROC TABULATE TABLE Statement

Hope this helps you!

Re: Proc tabulate : cv

SASdevAnneMarie — Mon, 16 Feb 2026 16:34:11 GMT

It is strange, but I have no output even for 1 variable :
29 proc tabulate data=bdd;
30 class departement;
31 var Nmbr_de_lgm;
32 table departement, (Nmbr_de_lgm)*(cv);
33 run;

WARNING: A logical page containing only missing values has been deleted from the output.
NOTE: There were 100 observations read from the data set WORK.BDD.
NOTE: PROCEDURE TABULATE used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds

Re: Proc tabulate : cv

Kathryn_SAS — Mon, 16 Feb 2026 16:42:10 GMT

You would get this message if your numeric variable, Nmbr_de_lgm, has all missing values. To check, run the following:

proc freq data=bdd;
tables Nmbr_de_lgm / missing;
run;

Re: Proc tabulate : cv

SASdevAnneMarie — Mon, 16 Feb 2026 16:46:05 GMT

I don't have the missing values in variables.

Re: Proc tabulate : cv

Kathryn_SAS — Mon, 16 Feb 2026 16:58:33 GMT

Can you send the results of the PROC FREQ I suggested?

Re: Proc tabulate : cv

SASdevAnneMarie — Mon, 16 Feb 2026 17:43:33 GMT

My data does not have the missing values, I can not understand why the proc tabulate does not work ( :

Re: Proc tabulate : cv

Kathryn_SAS — Mon, 16 Feb 2026 17:51:53 GMT

Please send your complete SAS log from the code below and the results of the PROC CONTENTS and PROC FREQ as attachments (not partial screenshots).

proc contents data=bdd;
run;

proc tabulate data=bdd;
class departement;
var Nmbr_de_lgm;
table departement, (Nmbr_de_lgm)*(cv);
run;

proc freq data=bdd;
tables Nmbr_de_lgm / missing;
run;

Re: Proc tabulate : cv

SASdevAnneMarie — Mon, 16 Feb 2026 18:20:48 GMT

Thank you, Kathryn!

Re: Proc tabulate : cv

ballardw — Tue, 17 Feb 2026 23:59:50 GMT

@SASdevAnneMarie wrote:
I don't have the missing values in variables.

How about all 0 values for Nmbr_de_lgm for one or more departement levels? The CV function has some issues with that I believe.