topic Re: Proc Means in SAS Programming

Proc Means

GN0001 — Wed, 30 Jun 2021 18:32:21 GMT

Hello team,

I need the total rows for a dataset. I use proc means to get the count of a variable in a dataset,

The query gives errors: log says: Variable memberletter in list doesn't match type prescribed for this list.

I assume memberletter is a character and means requires data type as number.

I used proc freq and that gave me the memberletter broken by the values that exists in the variable.

I need a total line.

I appreciate your response.

Regards,

Blue blue

Re: Proc Means

ballardw — Wed, 30 Jun 2021 18:44:23 GMT

Proc means will only do statistics for numeric variables. I have to assume you placed the name of a character variable on a VAR statement to generate that message.

And why are you using Proc means if you want a number of records in a data set? Proc Contents will do that.

Or you could use proc summary with the variable on a CLASS statement (NO var variables).

Or query sashelp.vtables.

Instead of piecemeal questions it might help to provide a description of where all this is going and some data.

Re: Proc Means

PaigeMiller — Wed, 30 Jun 2021 18:56:46 GMT

PROC FREQ does give the total. It is the cumulative value in the last row:

proc freq data=sashelp.class;
    tables sex;
run;

This produces the total value of N, which is the value of 19 in the cumulative frequency in the last line